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;
}
