*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px;} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }

:)

ThinkPHP V5.1
12载初心不改（2006-2018） - 你值得信赖的PHP框架

'; } public function get(Request $request) { $param = $request->param(); // $GLOBALS['allData'] = []; $allData = []; $data = null; // sy_user: { // id: 55, // "@column":"id, balance, intergral, icon, is_vip, mobile, surename, username" // } foreach ($param as $table => $where) { if (endsWith($table, '[]')) { $content = $where; $sub = $table; foreach ($content as $table => $where) { // 这里应该使用递归 start if (endsWith($table, '[]')) { $content = $where; $sub = $table; foreach ($content as $table => $where) { $data = Db::table($table); foreach ($where as $field => $condition) { if ($field === "@column") { $data = $data->field($condition); continue; } if (endsWith($field, '@')) { $field = substr($field, 0, -1); list($items, $withTable, $withKey) = explode("/", $condition); foreach ($allData[$items] as $keyNum => $item) { $data1 = clone $data; $data1 = $data1->where($field, $allData[$items][$keyNum][$withKey]); $allData[$items][$keyNum][$sub] = $data1->select(); // $allData[$items][$keyNum][$sub] = $data->select(); // $allData[$items][$keyNum][$sub] = $data->getLastSql(); } continue; } } } continue; } // 这里应该使用递归 end $data = Db::table($table); // $data = clone $data1; foreach ($where as $field => $condition) { if (endsWith($field, '@')) { $field = substr($field, 0, -1); // list($withTable, $withKey) = explode("/", $condition); // list($items, $withTable, $withKey) = explode("/", $condition); $explodeArr = explode("/", $condition); if (count($explodeArr) == 3) { // list($items, $withTable, $withKey) = $explodeArr; // // $data = $data->where($field, $allData[$items][$withTable][$withKey]); // $allData['aaaaa'] = $allData[$items][$withTable][$withKey]; $allData['aaaaa'] = $explodeArr; }elseif (count($explodeArr) == 2) { list($withTable, $withKey) = $explodeArr; $data = $data->where($field, $allData[$withTable][$withKey]); } continue; } if ($field === "@column") { $data = $data->field($condition); continue; } $data = $data->where($field, $condition); // $allData['dddd'] .= $allData['dddd'] ? $allData['dddd'] : $table; $allData['sub'] = $sub; $allData['table'] = $table; // $allData[$sub][$table] = $data->select(); } // $allData[$sub][$table] = $data->select(); $allData[$sub] = $data->order('id','desc')->select(); } continue; } $data = Db::table($table); foreach ($where as $field => $condition) { if ($field === "@column") { $data = $data->field($condition); continue; } $data = $data->where($field, $condition); } $allData[$table] = $data->find(); } return json($allData); } public function post(Request $request) { // config('app.app_trace', false); $allowField = [ // 'username' => 'username', // 'surename' => 'surename', // 'mobile' => 'mobile', // 'openid' => 'openid', // 'icon' => 'icon', ]; $param = $request->param(); $tableName = array_key_first($param); $data = Db::table($tableName)->insertGetId($param[$tableName]); $result = Db::table($tableName)->find($data); return json($result); } public function delete(Request $request) { $param = $request->param(); $tableName = array_key_first($param); $result = Db::table($tableName)->delete($param[$tableName]['ids']); return $result; } public function put(Request $request) { $param = $request->param(); $tableName = array_key_first($param); return Db::table($tableName)->update($param[$tableName]); } }