/**
* 获得数据列表
*/
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;
}
