function action_login_as() { $request = \PtLib\http_request("uid"); $uid = $request['uid']; $user = \PtLib\db_select_row("select n.* from users as u left join new_users as n on n.id = u.app_uid where n.id = ?", $uid); $user_info = array("nick_name" => $user['nickname'] ? $user['nickname'] : ($user['mobile'] ? $user['mobile'] : $user['email']), "mobile" => $user['mobile'], "email" => $user['email'], "uid" => $user['id']); Model_User_Auth::set_login($user_info); \PtLib\location("/user/index"); }
/** * 列表 **/ function action_list() { $table = "et_activity_info as a"; $join = ' left join et_activity_produce as p on a.id = p.id'; $request = PtLib\http_request("rows", "page", "sidx", "sord", "ship_status", "production_status", "activity_name", "activity_id"); $limit = $request['rows']; $page = $request['page']; $sort = $request['sidx']; $sort_type = $request['sord']; //fields $select_fields = " p.*,a.production_status,a.ship_status,a.status,a.verify,a.id,a.name,a.uid,a.sale_count,a.sale_target,a.sale_total,a.start_time,a.sale_profit,a.end_time,a.period,a.thumb_svg_url,a.thumb_img_url,date_add(a.end_time, interval 7 day) as give_time"; if (empty($limit)) { $limit = 20; } if (empty($page)) { $page = 1; } if (empty($sort)) { $sort = "id"; $sort_type = "desc"; } else { if (empty($sort_type)) { $sort_type = "desc"; } } //where $args = array(); //达到最低销量 或者成功的 $where = " where 1=1 "; if ($request['activity_name']) { $where .= ' and a.name= ? '; $args[] = $request['activity_name']; } if (!empty($request['activity_id'])) { $where .= ' and a.id= ? '; $args[] = $request['activity_id']; } if ($request['production_status'] === "0" || $request['production_status']) { if ($request['production_status'] === "01" || $request['production_status'] === '02') { //待生产 if ($request['production_status'] === "01") { //进行中 完成最低销量 $where .= ' and a.sale_profit > 0 and a.status = 1 and a.production_status = 0'; } else { //成功的 $where .= ' and a.status = 3 and a.production_status = 0'; } } else { $where .= ' and a.production_status= ? and (a.sale_profit > 0 or a.status = 3)'; $args[] = $request['production_status']; if ($request['production_status'] == 2 && ($request['ship_status'] === '0' || $request['ship_status'])) { //发货状态 $where .= ' and a.ship_status= ? '; $args[] = $request['ship_status']; } } } else { //全部生产 $where .= ' and (a.sale_profit > 0 or a.status = 3) '; } //order $order = ""; if ($sort) { $order = "order by p." . addslashes($sort) . " " . $sort_type; } $sql = "select count(a.id) as total from {$table} {$join} {$where} "; // $count_res = db()->select_row($sql,$args); $count_res = PtLib\db()->select_row($sql, $args); $records = $count_res['total']; $response = new stdClass(); $response->page = $page; //cur page if ($records > 0) { $total_pages = ceil($records / $limit); } else { $total_pages = 1; } if ($page > $total_pages) { $page = $total_pages; } $response->total = $total_pages; //total pages $response->records = $records; //count $skip = ($page - 1) * $limit; $sql = "select {$select_fields} from {$table} {$join} {$where} {$order} limit {$skip},{$limit} "; $rows = PtLib\db()->select_rows($sql, $args); foreach ($rows as $row) { $response->rows[] = array('id' => $row['id'], "cell" => $row); } return $response; }
function action_money_flow() { //$request = http_request("rows","page","sidx","sord"); $request = PtLib\http_request("rows", "page", "sidx", "sord", "uid", "username", "mobile", "startTime", "endTime", 'status'); $limit = $request['rows']; $page = $request['page']; $sort = $request['sidx']; $sort_type = $request['sord']; //fields $select_fields = " l.*,u.mobile,u.nick_name"; if (empty($limit)) { $limit = 20; } if (empty($page)) { $page = 1; } if (empty($sort)) { $sort = "id"; $sort_type = "desc"; } else { if (empty($sort_type)) { $sort_type = "desc"; } } //where $args = array(); $where = " where 1=1 "; if ($request['uid']) { $where .= ' and u.id = ?'; $args[] = $request['uid']; } if ($request['username']) { $where .= ' and u.nick_name = ?'; $args[] = $request['nick_name']; } if ($request['startTime']) { $where .= ' and l.create_time >= ?'; $args[] = date('Y-m-d 00:00:00', strtotime($request['startTime'])); } if ($request['endTime']) { $where .= ' and l.create_time <= ?'; $args[] = date('Y-m-d 23:59:59', strtotime($request['endTime'])); } if ($request['mobile']) { $where .= ' and u.mobile = ?'; $args[] = $request['mobile']; } //order $order = ""; if ($sort) { $order = "order by l." . addslashes($sort) . " " . $sort_type; } $sql = "select count(l.id) as total from et_user_finance_log as l left join et_user as u on u.id = l.uid {$where} "; //$count_res = db()->select_row($sql,$args); $count_res = PtLib\db()->select_row($sql, $args); $records = $count_res['total']; $response = new stdClass(); $response->page = $page; //cur page if ($records > 0) { $total_pages = ceil($records / $limit); } else { $total_pages = 1; } if ($page > $total_pages) { $page = $total_pages; } $response->total = $total_pages; //total pages $response->records = $records; //count $skip = ($page - 1) * $limit; $sql = "select {$select_fields} from et_user_finance_log as l left join et_user as u on u.id = l.uid {$where} {$order} limit {$skip},{$limit} "; $rows = PtLib\db()->select_rows($sql, $args); foreach ($rows as $row) { $response->rows[] = array('id' => $row['id'], "cell" => $row); } return $response; }
static function table_list() { $table_alias = $table = self::$table; $table_alias = 'w'; //fields // select u.nick_name,u.mobile from user as u where id = 1; $select_fields = " w.*,u.nick_name "; if (empty($table_alias)) { throw new ErrorException("table is not defined"); } // $request = http_request("rows","page","sidx","sord"); $request = PtLib\http_request("uid", "rows", "page", "sidx", "sord", "username", "mobile", "startDate", "endDate", "status"); $limit = $request['rows']; $page = $request['page']; $sort = $request['sidx']; $sort_type = $request['sord']; //where $args = array(); $where = " where 1=1 "; if ($request['mobile']) { $where = " and u.mobile = ? "; $args[] = $request['mobile']; } if ($request['uid']) { $where .= " and u.id = ? "; $args[] = $request['uid']; } if ($request['username']) { $where .= " and u.nick_name = ? "; $args[] = $request['username']; } if ($request['startDate']) { $where .= ' and ' . $table_alias . '.create_time >="' . date('Y-m-d 00:00:00', strtotime($request['startDate'])) . '"'; } if ($request['endDate']) { $where .= ' and ' . $table_alias . '.create_time <="' . date('Y-m-d 23:59:59', strtotime($request['endDate'])) . '"'; } if ($request['status']) { $where .= ' and ' . $table_alias . '.status = ?'; $args[] = $request['status']; } if (empty($limit)) { $limit = 20; } if (empty($page)) { $page = 1; } if (empty($sort)) { $sort = "id"; $sort_type = "desc"; } else { if (empty($sort_type)) { $sort_type = "desc"; } } //order $order = ""; if ($sort) { $order = "order by {$table_alias}." . addslashes($sort) . " " . $sort_type; } $join = ' left join et_user as u on u.id = w.uid'; $sql = "select count(w.id) as total from {$table} as {$table_alias} {$join} {$where} "; //echo $sql;exit; $count_res = PtLib\db()->select_row($sql, $args); $records = $count_res['total']; $response = new stdClass(); $response->page = $page; //cur page if ($records > 0) { $total_pages = ceil($records / $limit); } else { $total_pages = 1; } if ($page > $total_pages) { $page = $total_pages; } $response->total = $total_pages; //total pages $response->records = $records; //count $skip = ($page - 1) * $limit; $sql = "select {$select_fields} from {$table} as {$table_alias} {$join} {$where} {$order} limit {$skip},{$limit} "; //echo $sql;exit; // $rows = db()->select_rows($sql,$args); $rows = PtLib\db()->select_rows($sql, $args); foreach ($rows as $row) { $response->rows[] = array('id' => $row['id'], "cell" => $row); } return $response; }
static function table_list() { $table_alias = $table = self::$table; $select_fields = " {$table_alias}.* "; if (empty($table_alias)) { throw new ErrorException("table is not defined"); } $request = PtLib\http_request("rows", "page", "sidx", "sord", "username", "real_name", "student_no", "mobile", "school"); $limit = $request['rows']; $page = $request['page']; $sort = $request['sidx']; $sort_type = $request['sord']; $join = ' '; if (empty($limit)) { $limit = 20; } if (empty($page)) { $page = 1; } if (empty($sort)) { $sort = "id"; $sort_type = "desc"; } else { if (empty($sort_type)) { $sort_type = "desc"; } } //where $args = array(); $where = " where real_name is not null "; if ($request['student_no']) { $where .= ' and ' . $table_alias . '.student_no = ?'; $args[] = $request['student_no']; } if ($request['real_name']) { $where .= ' and ' . $table_alias . '.real_name like"%' . $request['real_name'] . '%"'; } if ($request['school']) { $where .= ' and ' . $table_alias . '.school_name like "%' . $request['school'] . '%"'; } //order $order = ""; if ($sort) { $order = "order by {$table_alias}." . addslashes($sort) . " " . $sort_type; } $sql = "select count({$table_alias}.id) as total from {$table} as {$table_alias} {$join} {$where} "; // $count_res = db()->select_row($sql,$args); $count_res = PtLib\db()->select_row($sql, $args); $records = $count_res['total']; $response = new stdClass(); $response->page = $page; //cur page if ($records > 0) { $total_pages = ceil($records / $limit); } else { $total_pages = 1; } if ($page > $total_pages) { $page = $total_pages; } $response->total = $total_pages; //total pages $response->records = $records; //count $skip = ($page - 1) * $limit; $sql = "select {$select_fields} from {$table} as {$table_alias} {$join} {$where} {$order} limit {$skip},{$limit} "; // $rows = db()->select_rows($sql,$args); $rows = PtLib\db()->select_rows($sql, $args); foreach ($rows as $row) { $response->rows[] = array('id' => $row['id'], "cell" => $row); } return $response; }