/** * 列表 **/ 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; }
<?php $design_id = $row['activity']['design_id']; $svgs = PtLib\db()->select_rows("select * from design_svg_side where design_id = ?", $design_id); ?> <div class="row"> <div class="col-xs-12"> <div class="widget-box"> <div class="widget-header"> <h4 class="widget-title"><?php echo $row['activity']['name']; ?> </h4> </div> <div class="widget-body"> <div class="widget-main"> <div class="row"> <div class="col-xs-2"> <?php if ($row['activity']["thumb_img_url"]) { ?> <img style="width: 100px;height:100px;" src="<?php echo $row['activity']["thumb_img_url"]; ?> " alt=""> <?php } else { ?> <img style="width: 100px;height:100px;" src="<?php echo $row['activity']["thumb_svg_url"];
static function _db($key = "default") { return PtLib\db($key); }
<li class="active"> <a data-toggle="tab" href="#change_man">更换供应商</a> </li> <li> <a data-toggle="tab" href="#finish_product">完成生产</a> </li> </ul> <div class="tab-content"> <div id="change_man" class="tab-pane in active"> <div class="modal-body"> <div class="form-group" style="margin-left: 0px;"> <label class="col-sm-3 control-label no-padding-right" for="form-field-1">请选择印花供应商</label> <div class="col-sm-9"> <select id="change_man_id" class="col-xs-10 col-sm-5"> <?php $manufacturers = PtLib\db()->select_rows("select * from et_product_manufacturer"); foreach ($manufacturers as $manufacturer) { ?> <option value="<?php echo $manufacturer['id']; ?> "><?php echo $manufacturer['name']; ?> </option><?php } ?> </select> </div> </div> </div>
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; }
<?php //判断活动活动id是不是存在 if (empty($_GET['id'])) { throw new Exception("活动id不存在"); } $activity_id = $_GET['id']; //查询数据库活动表的字段 $activity_info = PtLib\db()->select_row("select a.uid,a.name,a.sale_count,a.sale_target,a.content,a.thumb_img_url,a.start_time,a.end_time,u.nick_name from et_activity_info as a LEFT JOIN et_user as u on a.uid = u.id where a.id = ? ", $activity_id); //判断数据库是不是有该活动 if ($activity_info == false) { throw new Exception("没有该活动"); } //include(block("block/header")) ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <link rel="stylesheet" type="text/css" href="css/sale/sale.css"> <link rel="stylesheet" type="text/css" href="css/common/style.css"> <link rel="stylesheet" type="text/css" href="css/common/popup.css"> <!-- <script type="text/javascript" src="js/app/sale/time.js"></script> --> <script type="text/javascript" src="js/app/common/jquery-1.11.2.min.js"></script> <script type="text/javascript" src="/js/libs/crypt/sha1.js"></script> <script type="text/javascript" src="/js/libs/jquery.cookie.js"></script> <!-- <script type="text/javascript" src="js/app/common/jquery.mousewheel.min.js"></script> --> <script type="text/javascript" src="js/app/sale/index.js"></script> <script type="text/javascript" src="js/app/common/popup.js"></script> <script type="text/javascript" src="js/app/common/index.js"></script> </head>
function action_withdraw_download() { $rows = PtLib\db()->select_rows('select uwa.*,u.mobile,u.nick_name from user_withdraw_applies as uwa inner join users as u on u.id = uwa.uid where uwa.status="passed"'); if ($rows) { $myval = array(); $myval[] = "体现人名称,提现金额,联系电话,收款账号,支付类型"; $myval[] = "\r\n"; foreach ($rows as $row) { $myval[] = "\t" . $row['nick_name'] . ","; $myval[] = "\t" . $row['money'] - $row['fee'] . ","; $myval[] = "\t" . $row['mobile'] . ","; $myval[] = "\t" . $row['pay_account'] . ","; $myval[] = $row['pay_type'] . ","; $myval[] = "\r\n"; } $content = iconv("UTF-8", "GBK", implode($myval)); header("Content-Type: text/html; charset=GBK"); header("Pragma: public"); header("Expires: 0"); header('Content-Encoding: none'); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Cache-Control: public"); header("Content-type: application/octet-stream\n"); header("Content-Description: File Transfer"); header('Content-Disposition: attachment; filename=申请提现明细.csv', $content); header("Content-Transfer-Encoding: binary"); header('Content-Length: ' . strlen($content)); echo $content; exit; } }
<?php //查热门活动 $i = 0; $activity_hot = PtLib\db()->select_rows("select a.id, a.name,a.content,a.sale_count,a.sale_target,a.sale_total,a.start_time,a.end_time,a.period,a.sale_count,a.thumb_img_url,a.thumb_svg_url,a.Hot,u.nick_name,s.sell_price from et_activity_info as a left join et_user as u on a.uid = u.id left join activity_product_styles as s on s.activity_id = a.id where hot = 1 limit 0,4 "); //var_dump($activity_hot) ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <link rel="stylesheet" type="text/css" href="css/common/style.css"> <link rel="stylesheet" type="text/css" href="css/index/index.css"> <link rel="stylesheet" type="text/css" href="css/common/popup.css"> <script type="text/javascript" src="js/app/common/jquery-1.11.2.min.js"></script> <script type="text/javascript" src="/js/libs/crypt/sha1.js"></script> <script type="text/javascript" src="js/app/common/popup.js"></script> <script type="text/javascript" src="js/app/common/index.js"></script> <script type="text/javascript" src="js/app/index/index.js"></script> <script type="text/javascript" src="js/app/common/mobile_index.js"></script> </head> s <body> <!-- <div class="try"> <i></i> </div> --> <div class="tanceng"> <span class="close"></span>
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; }