/** * 根据不同的站点获得员工 */ public static function getSiteStaffPairs() { $db = Db_AndyouYun::instance(); $res = $db->getAll("select id,name,site,objId from staff"); $outArr = array(); if ($res) { foreach ($res as $re) { $outArr[$re["site"]][$re["objId"]] = $re["name"]; } } return $outArr; }
/** * 获得数据列表 */ 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 ($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 : ''; } } } } $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_AndyouYun", 'tblName' => "product", 'cols' => "*", 'pageSize' => $pageSize, 'page' => $page, 'pageUrl' => $pageUrl, 'whereSql' => $whereSql, 'orderSql' => $orderSql, 'iswrite' => true, 'pageTpl' => 9)); //获得符合条件的库存总量 $db = Db_AndyouYun::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_Yun_Product::getProductCatePairs(); //获得所有的种类 $output->proCtype = ZOL_Config::get("GLOBAL", "PRO_CTYPE"); $output->setTemplate('Product'); }
/** * 同步所有日志 */ public function doUpData(ZOL_Request $input, ZOL_Response $output) { set_time_limit(0); $token = $input->get("token"); //token的验证 // if ($token != md5("c=Rsync_Item&a=UpData" . "AAFDFDF&RE3")) { echo "001"; exit; } $db = Db_AndyouYun::instance(); $data = $input->post("data"); $table = $input->post("table"); if ($data) { $data = base64_decode($data); $data = api_json_decode($data); if ($data) { if (in_array($table, array("staff", "product", "membercate", "productcate", "staffcate", "options", "billsitem"))) { //log_cardchange $okIdArr = array(); foreach ($data as $d) { $site = $d['site']; $objId = $d['objId']; $subSql = "site = '{$site}' and objId = '{$objId}'"; $sql = "select 'x' from {$table} where {$subSql} limit 1 "; $has = $db->getOne($sql); $okIdArr[] = $objId; unset($d['id']); unset($d['rsync']); unset($d['rowTm']); $item = $d; if (!$has) { //如果不存在就插入到本地 Helper_Dao::insertItem(array('addItem' => $item, 'dbName' => "Db_AndyouYun", 'tblName' => $table)); } else { Helper_Dao::updateItem(array('addItem' => $item, 'dbName' => "Db_AndyouYun", 'tblName' => $table, 'where' => $subSql)); } } echo json_encode($okIdArr); } } } exit; }
/** * 获得最新的数据 */ public function doGetNew(ZOL_Request $input, ZOL_Response $output) { $token = $input->get("token"); $tm = (int) $input->get("tm"); //token的验证 // if ($token != md5("c=Rsync_Member&a=GetNew&tm={$tm}" . "AAFDFDF&RE3")) { echo "001"; exit; } $db = Db_AndyouYun::instance(); $sql = "select name,phone,cardno,cateId,byear,bmonth,bday,addTm,remark,introducer,introducerId,allsum,upTm,score,balance,site,siteObjId " . " from member where (addTm > {$tm} or upTm > {$tm})"; $data = $db->getAll($sql); $jsonstr = api_json_encode($data); echo $jsonstr; exit; }
/** * 记录会员获得会员卡余额历史 */ public static function getOtherPros($params) { $options = array('id' => false, 'phone' => false, 'cardno' => false); if (is_array($params)) { $options = array_merge($options, $params); } extract($options); $whereSql = ''; if (!$id && !$phone && !$name && !$phoneOrCardno) { return false; } if ($id) { $whereSql .= "and m.id = '{$id}' "; } if ($phone) { $whereSql .= "and m.phone = '{$phone}' "; } if ($cardno) { $whereSql .= "and m.cardno = '{$cardno}' "; } if ($phoneOrCardno) { $whereSql .= "and (m.cardno = '{$phoneOrCardno}' or m.phone = '{$phoneOrCardno}') "; } $db = Db_AndyouYun::instance(); $sql = "select p.id,p.proId,p.name,p.proName,p.num,p.ctype,p.buytm from member m left join memeberotherpro p on m.id = p.memberId where p.num > 0 " . $whereSql; $data = $db->getAll($sql); return $data; }
/** * 获得会员分类管理列表 */ public static function getProductCatePairs() { $db = Db_AndyouYun::instance(); return $db->getPairs("select id,name from productcate ", "id", "name"); }
/** * 更新用户会员卡余额 */ public function doUpCard(ZOL_Request $input, ZOL_Response $output) { $mid = (int) $input->post("mid"); $card = (int) $input->post("card"); $direction = (int) $input->post("direction"); $remark = $input->post("remark"); $staffid = (int) $input->post('staffid'); $urlStr = "?c={$output->ctlName}"; if ($mid == 0) { echo "<script>alert('Error!');document.location='{$urlStr}';</script>"; exit; } if ($card < 0) { $card = -$card; } //生成一个单号 $output->bno = Helper_Bill::getCommonMaxBno(); #获得会员信息 $minfo = Helper_Member::getMemberInfo(array("id" => $mid)); if (!$minfo) { echo "<script>alert('Member Error!');document.location='{$urlStr}';</script>"; exit; } if ($direction == 1) { //减分的时候判断用户是否有这么多 if ($minfo["balance"] < $card) { echo "<script>alert('Balance Error!');document.location='{$urlStr}';</script>"; exit; } } $db = Db_AndyouYun::instance(); $op = $direction == 1 ? "-" : "+"; $sql = "update member set balance = balance {$op} {$card} where id = {$mid}"; $db->query($sql); $logItem = array("memberId" => $mid, "direction" => $direction, "card" => $card, "dateTm" => SYSTEM_TIME, "adminer" => $output->admin, "remark" => $remark, "orgCard" => $minfo["balance"], "staffid" => $staffid, "bno" => $output->bno); $data = Helper_Dao::insertItem(array('addItem' => $logItem, 'dbName' => 'Db_AndyouYun', 'tblName' => 'log_cardchange')); if ($direction != 1) { //充值大小票 $output->money = $card; #充值的钱 $output->nowBalance = $card + $minfo["balance"]; $output->memberInfo = $minfo; $staffArr = Helper_Staff::getStaffPairs(); $output->staffName = $staffArr[$staffid]; Helper_Bill::createOneCommonBno(); //生成一个通用订单号 $output->setTemplate("CardPrint"); } else { echo "<script>document.location='{$urlStr}';</script>"; exit; } }