/**
* 列表
**/
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;
}
