/** * 获得数据列表 */ public function doDefault(ZOL_Request $input, ZOL_Response $output) { $wArr = array(); #搜索字段 $whereSql = ""; $page = (int) $input->get('page') < 1 ? 1 : (int) $input->get('page'); $output->memberPhone = $input->get("memberPhone"); //会员电话 $output->memberNm = $input->get("memberNm"); //会员姓名 //获得会员信息 $memInfo = Helper_Member::getMemberInfo(array('phone' => $output->memberPhone, 'name' => $output->memberNm)); if ($memInfo) { $whereSql = " and memberId = {$memInfo['id']} "; } $pageUrl = "?c={$output->ctlName}&a={$output->actName}&page={$page}&memberPhone={$output->memberPhone}&memberNm={$output->memberNm}"; $pageSize = 30; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_Andyou", 'tblName' => "log_scorechange", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } $output->setTemplate('LogScoreChange'); }
/** * 获得数据列表 */ public function doDefault(ZOL_Request $input, ZOL_Response $output) { $wArr = array(); #搜索字段 $whereSql = ""; $page = (int) $input->get('page') < 1 ? 1 : (int) $input->get('page'); $output->sername = $wArr['name'] = $input->get('name'); if (!empty($wArr)) { foreach ($wArr as $k => $v) { if (gettype($v) == 'string') { $whereSql .= !empty($v) ? ' AND ' . $k . ' like binary "%' . $v . '%" ' : ''; } else { $whereSql .= !empty($v) ? ' AND ' . $k . '=' . $v : ''; } } } $pageUrl = "?c={$output->ctlName}&a={$output->actName}&page={$page}&name={$wArr['name']}"; $pageSize = 30; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_Andyou", 'tblName' => "staffcate", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } $output->setTemplate('StaffCate'); }
/** * 获得数据列表 */ public function doDefault(ZOL_Request $input, ZOL_Response $output) { $wArr = array(); #搜索字段 $whereSql = ""; $page = (int) $input->get('page') < 1 ? 1 : (int) $input->get('page'); $member = $input->get('member'); if ($member) { $memInfo = Helper_Member::getMemberInfo(array('phoneOrCardno' => $member)); if ($memInfo) { $output->memberId = $memInfo["id"]; } } if ($output->serctype) { $whereSql .= " AND ctype = " . $output->serctype; } if ($output->memberId) { $whereSql .= " AND memberId = " . $output->memberId; } $pageUrl = "?c={$output->ctlName}&a={$output->actName}&page={$page}&memberId={$output->memberId}&ctype={$wArr['ctype']}"; $pageSize = 30; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_Andyou", 'tblName' => "memeberotherpro", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } $output->member = $member; $output->proCtypeArr = ZOL_Config::get("GLOBAL", "PRO_CTYPE"); $output->setTemplate('MemeberOtherPro'); }
/** * 获得数据列表 */ public function doDefault(ZOL_Request $input, ZOL_Response $output) { $wArr = array(); #搜索字段 $output->isAddUser = (int) $input->get("isAddUser"); $whereSql = ""; $page = (int) $input->get('page') < 1 ? 1 : (int) $input->get('page'); $output->serbno = $wArr['bno'] = $input->get('bno'); $output->serstaffid = $wArr['staffid'] = $input->get('staffid'); $output->sermemberId = $wArr['memberId'] = $input->get('memberId'); $output->sermemberPhone = $input->get('memberPhone'); $output->isBuyScore = $input->get('isBuyScore'); $output->hasChangePrice = (int) $input->get("hasChangePrice"); //销售员修改过的订单 //如果传入了会员电话 if ($output->sermemberPhone) { $wArr['phone'] = $output->sermemberPhone; } if ($output->isBuyScore == 1) { $whereSql .= " and isBuyScore = 1"; } if ($output->isBuyScore == 2) { $whereSql .= " and isBuyScore = 0"; } //销售员修改了价格 if ($output->hasChangePrice) { $whereSql .= " and priceTrue > 0 "; } if (!empty($wArr)) { foreach ($wArr as $k => $v) { if (gettype($v) == 'string') { if ($k == "phone") { $whereSql .= !empty($v) ? ' AND ' . $k . '=' . $v : ''; } else { $whereSql .= !empty($v) ? ' AND ' . $k . ' like binary "%' . $v . '%" ' : ''; } } else { $whereSql .= !empty($v) ? ' AND ' . $k . '=' . $v : ''; } } } if ($output->isAddUser) { $whereSql .= " AND memberId = 0 "; } $pageUrl = "?c={$output->ctlName}&a={$output->actName}&page={$page}&bno={$wArr['bno']}&isAddUser={$output->isAddUser}&staffid={$wArr['staffid']}&memberPhone={$output->sermemberPhone}&hasChangePrice={$output->hasChangePrice}"; $pageSize = 30; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_AndyouYun", 'tblName' => "bills", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } $output->staffInfo = Helper_Yun_Staff::getSiteStaffPairs(); $output->setTemplate('Bills'); }
/** * 获得数据列表 */ public function doDefault(ZOL_Request $input, ZOL_Response $output) { $wArr = array(); #搜索字段 $whereSql = ""; $page = (int) $input->get('page') < 1 ? 1 : (int) $input->get('page'); $output->serproId = $wArr['proId'] = $input->get('proId'); $output->sercateId = $wArr['cateId'] = $input->get('cateId'); $output->sername = $wArr['name'] = $input->get('name'); $output->sercode = $wArr['code'] = $input->get('code'); $output->startTime = $wArr['startTime'] = $input->get('startTime'); $output->endTime = $wArr['endTime'] = $input->get('endTime'); if ($output->sercateId) { $whereSql .= ' AND cateId =' . $output->sercateId; } if ($output->sercode) { $whereSql .= ' AND cateId =\'' . $output->sercode . '\''; } if ($output->sername) { $whereSql .= ' AND name like \'%' . $output->sername . '%\''; } if ($output->startTime) { $stm = strtotime($output->startTime . "00:00:00"); $whereSql .= " AND dateTm > {$stm}"; } if ($output->endTime) { $stm = strtotime($output->endTime . "23:59:59"); $whereSql .= " AND dateTm < {$stm}"; } $pageUrl = "?c={$output->ctlName}&a={$output->actName}&page={$page}&proId={$wArr['proId']}&cateId={$wArr['cateId']}&name={$wArr['name']}&code={$wArr['code']}&startTime={$wArr['startTime']}&endTime={$wArr['endTime']}"; $pageSize = 30; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_Andyou", 'tblName' => "log_productinstorage", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } //获得所有的产品分类 $output->proCateArr = Helper_Product::getProductCatePairs(); $output->setTemplate('LogInStorage'); }
/** * 获得数据列表 */ public function doDefault(ZOL_Request $input, ZOL_Response $output) { $wArr = array(); #搜索字段 $whereSql = ""; $page = (int) $input->get('page') < 1 ? 1 : (int) $input->get('page'); $output->sername = $wArr['name'] = $input->get('name'); $output->sercode = $wArr['code'] = $input->get('code'); $output->sercateId = $wArr['cateId'] = $input->get('cateId'); if (!empty($wArr)) { foreach ($wArr as $k => $v) { if (gettype($v) == 'string') { $whereSql .= !empty($v) ? ' AND ' . $k . ' like binary "%' . $v . '%" ' : ''; } else { $whereSql .= !empty($v) ? ' AND ' . $k . '=' . $v : ''; } } } $pageUrl = "?c={$output->ctlName}&a={$output->actName}&page={$page}&name={$wArr['name']}&code={$wArr['code']}&cateId={$wArr['cateId']}"; $pageSize = 30; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_Andyou", 'tblName' => "product", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); //获得符合条件的库存总量 $db = Db_Andyou::instance(); $sql = "select sum(stock) sumstock,sum(stock*price) sumprice from product where ctype = 1 {$whereSql}"; $tmp = $db->getRow($sql); $output->sumstock = $tmp["sumstock"]; $output->sumprice = $tmp["sumprice"]; if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } $output->cateInfo = Helper_Product::getProductCatePairs(); $output->setTemplate('ProductSm'); }
/** * 获得数据列表 */ public function doSendTable(ZOL_Request $input, ZOL_Response $output) { header("Pragma: no-cache"); header('Content-type: application/x-msexcel;charset=utf-8'); header("Content-Disposition: attachment; filename=商品数据_" . date('Y-m-d H:i:s') . ".xls"); $wArr = array(); #搜索字段 $whereSql = ""; $output->sername = $wArr['name'] = $input->get('name'); $output->sercode = $wArr['code'] = $input->get('code'); $output->sercateId = $wArr['cateId'] = $input->get('cateId'); if (!empty($wArr)) { foreach ($wArr as $k => $v) { if ($k == 'cateId' && $v) { $whereSql .= ' AND cateId =' . $v; } elseif ($k == 'code' && $v) { $whereSql .= ' AND code =\'' . $v . "'"; } else { if (gettype($v) == 'string') { $whereSql .= !empty($v) ? ' AND ' . $k . ' like binary "%' . $v . '%" ' : ''; } else { $whereSql .= !empty($v) ? ' AND ' . $k . '=' . $v : ''; } } } } $pageSize = 100000; $orderSql = "order by id desc"; $data = Helper_Dao::getList(array('dbName' => "Db_AndyouYun", 'tblName' => "product", 'cols' => "*", 'pageSize' => $pageSize, 'page' => 1, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); if ($data) { $output->pageBar = $data['pageBar']; $output->allCnt = $data['allCnt']; $output->data = $data['data']; $output->pageUrl = $pageUrl; } $output->cateInfo = Helper_Product::getProductCatePairs(); //获得所有的种类 $output->proCtype = ZOL_Config::get("GLOBAL", "PRO_CTYPE"); $html = $output->fetchCol('ProductToExcel'); echo mb_convert_encoding($html, "utf-8", "gbk"); exit; }