public function actionGetSitePersons()
{
$companyid = Yii::app()->request->getParam('companyid', 0);
$padid = Yii::app()->request->getParam('padid', 0);
$stlid = Yii::app()->request->getParam('stlid', 0);
$splid = Yii::app()->request->getParam('splid', 0);
$ret = array();
$nowqueueno = "000";
$queueno = "A001";
$waitingno = 0;
if (empty($companyid) || empty($padid)) {
Yii::app()->end(json_encode(array('status' => false, 'msg' => '店铺或设备不存在！')));
}
$pad = Pad::model()->with("printer")->find(' t.dpid=:companyId and t.lid=:padid', array(':companyId' => $companyid, ':padid' => $padid));
//var_dump($pad);exit;
if (!empty($pad)) {
//生成新的排队号
$siteType = SiteType::model()->find(" dpid=:dpid and lid=:lid", array(":dpid" => $companyid, ":lid" => $stlid));
//var_dump($siteType);exit;
$criteria = new CDbCriteria();
$criteria->condition = " dpid=" . $companyid . " and stlid=" . $stlid . " and splid=" . $splid . " and create_at >='" . date('Y-m-d', time()) . " 00:00:00' and create_at <='" . date('Y-m-d', time()) . " 23:59:59'";
$criteria->order = ' lid ';
$queuePerson = QueuePersons::model()->findAll($criteria);
if (empty($siteType)) {
Yii::app()->end(json_encode(array('status' => false, 'msg' => '座位类型不存在！')));
}
//var_dump($queuePerson);exit;
if (!empty($queuePerson)) {
$countsp = count($queuePerson);
$queueno = $siteType->simplecode . substr("000" . (string) ($countsp + 1), -3);
for ($sti = $countsp - 1; $sti >= 0; $sti--) {
if ($queuePerson[$sti]->status == "0") {
$waitingno++;
} else {
break;
}
}
} else {
$queueno = $siteType->simplecode . "001";
$waitingno = 0;
}
$se = new Sequence("queue_persons");
$queuelid = $se->nextval();
$data = array('lid' => $queuelid, 'dpid' => $companyid, 'create_at' => date('Y-m-d H:i:s', time()), 'update_at' => date('Y-m-d H:i:s', time()), 'stlid' => $stlid, 'splid' => $splid, 'queue_no' => $queueno, 'status' => '0', 'slid' => "0000000000", 'delete_flag' => '0');
Yii::app()->db->createCommand()->insert('nb_queue_persons', $data);
$waitingno++;
//返回现有的等待人数
$precode = "";
$printserver = "0";
//
$memo = "排队号：" . $queueno . "，（还有" . $waitingno . "组在等待）";
$ret = Helper::printQueue($pad, $precode, $printserver, $memo);
if ($ret['status']) {
$ret['waitingnum'] = $waitingno;
}
} else {
$ret = array('status' => false, 'msg' => '没有找到PAD');
}
Yii::app()->end(json_encode($ret));
}
public function actionGetOnePad()
{
$companyid = Yii::app()->request->getParam('companyid', 0);
$padid = Yii::app()->request->getParam('padid', 0);
if (!$companyid) {
Yii::app()->end(json_encode(array('data' => array(), 'delay' => 400)));
}
$treeDataSource = array('data' => array(), 'delay' => 400);
$pads = Pad::model()->findAll('dpid=:companyId and lid=:lid and delete_flag=0 ', array(':companyId' => $companyid, ':lid' => $padid));
//var_dump($pads);exit;
foreach ($pads as $c) {
$tmp['name'] = $c['name'];
$tmp['id'] = $c['lid'];
$treeDataSource['data'][] = $tmp;
}
header('Content-type: application/Json');
$endjson = json_encode($treeDataSource);
Yii::app()->end("{$_GET['jsoncallback']}({$endjson});");
}
public function actionPrintList()
{
$orderId = Yii::app()->request->getParam('orderId', 0);
//$companyId = Yii::app()->request->getParam('companyId');
$padId = Yii::app()->request->getParam('padId');
$typeId = Yii::app()->request->getParam('typeId');
Until::validOperate($companyId, $this);
$order = Order::model()->with('company')->find('t.lid=:id and t.dpid=:dpid', array(':id' => $orderId, ':dpid' => $this->companyId));
$pad = Pad::model()->find(' dpid=:dpid and lid=:lid', array(':dpid' => $order->dpid, 'lid' => $padId));
//前面加 barcode
if (!empty($pad)) {
$precode = "";
//$precode="1D6B450B".strtoupper(implode('',unpack('H*', 'A'.$order->lid)))."0A".strtoupper(implode('',unpack('H*', 'A'.$order->lid)))."0A";
//Yii::app()->end(json_encode(Helper::printList($order , $padid)));
$printserver = "1";
$memo = "";
$ret = Helper::printList($order, $pad, $precode, $printserver, $memo);
} else {
$ret = array('status' => false, 'dpid' => $order->dpid, 'jobid' => "0", 'type' => 'none', 'msg' => yii::t('app', 'PAD不存在！'));
}
//exit;
$this->renderPartial('printlist', array('orderId' => $orderId, 'ret' => $ret, 'typeId' => $typeId));
}
/**
*
* 大pad下单并打印
*
*/
public static function createPadOrder($dpid, $goodsIds, $padId)
{
$isTemp = $goodsIds['client_is_temp'];
$site_id = $goodsIds['client_site_id'];
$siteName = $goodsIds['client_site_name'];
$reprint = $goodsIds['client_reprint'];
$waitorname = $goodsIds['client_waitor_name'];
//订单的状态，临时做下单时挂单状态，非临时做下单直接厨打
$orderStatus = "2";
$orderPorductStatus = "1";
if ($isTemp == "1") {
$orderStatus = "1";
$orderPorductStatus = "0";
}
unset($goodsIds['client_is_temp']);
unset($goodsIds['client_site_id']);
unset($goodsIds['client_site_name']);
unset($goodsIds['client_reprint']);
unset($goodsIds['client_waitor_name']);
$siteStatus = self::getSiteStatus($site_id, $dpid, $isTemp);
if (empty($siteStatus)) {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', '请先开台后下单！'))));
}
$sellOff = array();
$printOrderProducts = array();
$time = date('Y-m-d H:i:s', time());
$db = Yii::app()->db;
//return json_encode(array('status'=>false,'msg'=>$waitorname));
$transaction = $db->beginTransaction();
try {
if ($site_id == 0) {
//未开台的临时台
$se = new Sequence("site_no");
$lid = $se->nextval();
$code = rand(1000, 9999);
$se = new Sequence("temp_site");
$site_id = $se->nextval();
$data = array('lid' => $lid, 'dpid' => $dpid, 'create_at' => date('Y-m-d H:i:s', time()), 'update_at' => date('Y-m-d H:i:s', time()), 'is_temp' => $isTemp, 'site_id' => $site_id, 'status' => $orderStatus, 'code' => $code, 'number' => 1, 'delete_flag' => '0');
$db->createCommand()->insert('nb_site_no', $data);
$feedback_memo = '开台';
$se = new Sequence("order");
$orderId = $se->nextval();
$data = array('lid' => $orderId, 'dpid' => $dpid, 'site_id' => $site_id, 'create_at' => $time, 'username' => $waitorname, 'is_temp' => $isTemp, 'order_status' => $orderStatus, 'number' => 1, 'update_at' => $time, 'remark' => yii::t('app', '无'), 'taste_memo' => "");
$db->createCommand()->insert('nb_order', $data);
$sef = new Sequence("order_feedback");
$lidf = $sef->nextval();
$dataf = array('lid' => $lidf, 'dpid' => $dpid, 'create_at' => date('Y-m-d H:i:s', time()), 'update_at' => date('Y-m-d H:i:s', time()), 'is_temp' => $isTemp, 'site_id' => $site_id, 'is_deal' => '0', 'feedback_id' => 0, 'order_id' => 0, 'is_order' => '1', 'feedback_memo' => $feedback_memo, 'delete_flag' => '0');
$db->createCommand()->insert('nb_order_feedback', $dataf);
} else {
//已经开台的固定台或临时台，
//$feedback_memo = yii::t('app','点单');
// //查找site表
// $sql = 'select * from nb_site_no where site_id='.$site_id.' and dpid='.$dpid.' order by lid desc';
// $siteModel = $db->createCommand($sql)->queryRow();
// if(!$siteModel){
// throw new Exception(json_encode( array('status'=>false,'dpid'=>$dpid,'msg'=>yii::t('app','存在该座次号,请重新选座次下单!')),JSON_UNESCAPED_UNICODE));
// }
// //如果该座位 状态开台未下单
// if(0 < $siteModel['status'] && $siteModel['status'] < 4){
// //先查找是否已经存在订单
// $sql = 'select * from nb_order where site_id='.$site_id.' and dpid='.$dpid.' and is_temp='.$isTemp.' order by lid desc';
$criteria = new CDbCriteria();
$criteria->condition = ' t.order_status in ("1","2","3") and t.dpid=' . $dpid . ' and t.site_id=' . $site_id . ' and t.is_temp=' . $isTemp;
$criteria->order = ' t.lid desc ';
$orderModel = Order::model()->find($criteria);
$criteria->condition = ' t.status in ("1","2","3") and t.dpid=' . $dpid . ' and t.site_id=' . $site_id . ' and t.is_temp=' . $isTemp;
$criteria->order = ' t.lid desc ';
$siteNo = SiteNo::model()->find($criteria);
$siteNo->status = $orderStatus;
$siteNo->update_at = date('Y-m-d H:i:s', time());
$siteNo->save();
if ($isTemp == "0") {
$site = Site::model()->find(" t.dpid=:dpid and t.lid=:siteid", array(':dpid' => $siteNo->dpid, ':siteid' => $siteNo->site_id));
$site->status = $orderStatus;
$site->update_at = date('Y-m-d H:i:s', time());
$site->save();
}
if ($orderModel) {
$orderId = $orderModel['lid'];
} else {
//生成订单
$se = new Sequence("order");
$orderId = $se->nextval();
$data = array('lid' => $orderId, 'dpid' => $dpid, 'site_id' => $site_id, 'create_at' => $time, 'username' => $waitorname, 'is_temp' => $isTemp, 'order_status' => $orderStatus, 'number' => $siteNo->number, 'update_at' => $time, 'remark' => yii::t('app', '无'), 'taste_memo' => "");
$db->createCommand()->insert('nb_order', $data);
//更新site表状态
// $sql = 'update nb_site set status=1 where lid='.$site_id.' and dpid='.$dpid.' order by lid desc';
// $db->createCommand($sql)->execute();
// //更新site_no表状态
// $sql = 'update nb_site_no set status=1 where site_id='.$site_id.' and dpid='.$dpid.' and is_temp='.$isTemp.' order by lid desc';
// $db->createCommand($sql)->execute();
}
}
// return json_encode(array('status'=>false,'msg'=>"test"));
//订单产品 $goodsIds = array('goods_id'=>goods_num,'set_id,1'=>set_num);
$orderPrice = 0;
foreach ($goodsIds as $key => $num) {
$se = new Sequence("order_product");
$orderProductId = $se->nextval();
$goodsArr = explode(',', $key);
if (count($goodsArr) > 1) {
// 套餐
$sql = 'select * from nb_product_set where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$result = $db->createCommand($sql)->queryRow();
if ($result) {
if ($result['store_number'] == 0 || $result['store_number'] > 0 && $result['store_number'] < 1) {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', $result['set_name'] . '库存不足！'))));
}
} else {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', '没有找到该产品请清空后重新下单！'))));
}
//添加选择的套餐明细
foreach ($num as $setDetail) {
$detailId = key($setDetail);
$productSet = self::getSetProductId($dpid, $detailId);
$orderProductData = array('lid' => $orderProductId, 'dpid' => $dpid, 'create_at' => $time, 'order_id' => $orderId, 'set_id' => $goodsArr[0], 'product_id' => $productSet['product_id'], 'price' => $productSet['price'], 'update_at' => $time, 'amount' => $productSet['number'], 'taste_memo' => "", 'product_order_status' => $orderPorductStatus);
$db->createCommand()->insert('nb_order_product', $orderProductData);
$se = new Sequence("order_product");
$orderProductId = $se->nextval();
$orderPrice += $productSet['price'] * $productSet['number'];
array_push($printOrderProducts, array('amount' => $productSet['number'], 'price' => $productSet['price'], 'product_name' => ProductClass::getProductName($productSet['product_id'], $dpid)));
}
if ($result['store_number'] > 0) {
$sql = 'update nb_product_set set store_number=store_number-1 where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$db->createCommand($sql)->execute();
array_push($sellOff, array("product_id" => sprintf("%010d", $goodsArr[0]), "type" => "set", "num" => $result['store_number'] - 1));
}
} else {
//单品 如果有口味 num-eq =>array('taste_id1','taste_id2') num 是数量 eq是序号 $goodsArr[0] 产品id
if ($goodsArr[0] == 'quandan') {
//全单口味
foreach ($num as $tasteId => $taste) {
$se = new Sequence("order_taste");
$orderTasteId = $se->nextval();
$orderTasteData = array('lid' => $orderTasteId, 'dpid' => $dpid, 'create_at' => $time, 'order_id' => $orderId, 'taste_id' => $tasteId, 'is_order' => 1, 'update_at' => $time);
$db->createCommand()->insert('nb_order_taste', $orderTasteData);
}
} else {
$sql = 'select * from nb_product where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$result = $db->createCommand($sql)->queryRow();
$productPrice = self::getProductPrice($dpid, $key, 0);
if (is_array($num)) {
//有口味$num = num-eq 格式
foreach ($num as $k => $v) {
$numEq = explode('-', $k);
$amount = $numEq[0];
if ($result) {
if ($result['store_number'] == 0 || $result['store_number'] > 0 && $result['store_number'] < $amount) {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', $result['product_name'] . '库存不足！'))));
}
} else {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', '没有找到该产品请清空后重新下单！'))));
}
//每一个eq 生成一个订单
$orderProductData = array('lid' => $orderProductId, 'dpid' => $dpid, 'create_at' => $time, 'order_id' => $orderId, 'set_id' => 0, 'product_id' => $goodsArr[0], 'price' => $productPrice, 'update_at' => $time, 'amount' => $amount, 'taste_memo' => "", 'product_order_status' => $orderPorductStatus);
$db->createCommand()->insert('nb_order_product', $orderProductData);
$orderPrice += $productPrice * $amount;
array_push($printOrderProducts, array('amount' => $amount, 'price' => $productPrice, 'product_name' => ProductClass::getProductName($goodsArr[0], $dpid)));
//该订单对应的多个口味
foreach ($v as $tasteId => $val) {
if ($tasteId) {
$orderTastSe = new Sequence("order_taste");
$orderTasteId = $orderTastSe->nextval();
$orderTasteData = array('lid' => $orderTasteId, 'dpid' => $dpid, 'create_at' => $time, 'update_at' => $time, 'taste_id' => $tasteId, 'order_id' => $orderProductId, 'is_order' => 0);
$db->createCommand()->insert('nb_order_taste', $orderTasteData);
}
}
$se = new Sequence("order_product");
$orderProductId = $se->nextval();
if ($result['store_number'] > 0) {
$sql = 'update nb_product set store_number=store_number-' . $amount . ' where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$db->createCommand($sql)->execute();
array_push($sellOff, array("product_id" => sprintf("%010d", $goodsArr[0]), "type" => "product", "num" => $result['store_number'] - $amount));
}
$sqladd = 'update nb_product set order_number=order_number+' . $amount . ',favourite_number=favourite_number+' . $amount . ' where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$db->createCommand($sqladd)->execute();
}
} else {
if ($result) {
if ($result['store_number'] == 0 || $result['store_number'] > 0 && $result['store_number'] < $num) {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', $result['product_name'] . '库存不足！'))));
}
} else {
throw new Exception(json_encode(array('status' => false, 'dpid' => $dpid, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', '没有找到该产品请清空后重新下单！'))));
}
$orderProductData = array('lid' => $orderProductId, 'dpid' => $dpid, 'create_at' => $time, 'order_id' => $orderId, 'set_id' => 0, 'product_id' => $goodsArr[0], 'price' => $productPrice, 'update_at' => $time, 'amount' => $num, 'taste_memo' => "", 'product_order_status' => $orderPorductStatus);
$db->createCommand()->insert('nb_order_product', $orderProductData);
$orderPrice += $productPrice * $num;
array_push($printOrderProducts, array('amount' => $num, 'price' => $productPrice, 'product_name' => ProductClass::getProductName($goodsArr[0], $dpid)));
if ($result['store_number'] > 0) {
$sql = 'update nb_product set store_number=store_number-' . $num . ' where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$db->createCommand($sql)->execute();
array_push($sellOff, array("product_id" => sprintf("%010d", $goodsArr[0]), "type" => "product", "num" => $result['store_number'] - $num));
}
$sqladd = 'update nb_product set order_number=order_number+' . $num . ',favourite_number=favourite_number+' . $num . ' where dpid=' . $dpid . ' and lid=' . $goodsArr[0];
$db->createCommand($sqladd)->execute();
}
}
}
}
$sql = 'update nb_order set should_total=' . $orderPrice . ' where lid=' . $orderId . ' and dpid=' . $dpid;
$db->createCommand($sql)->execute();
// $sql = 'update nb_site_no set status='.$orderPrice.' where lid='.$orderId.' and dpid='.$dpid;
// $db->createCommand($sql)->execute();
// return json_encode(array('status'=>false,'msg'=>"test22"));
//厨打
if ($orderId != '0') {
$order = Order::model()->with('company')->find(' t.lid=:lid and t.dpid=:dpid and t.order_status in(1,2,3)', array(':lid' => $orderId, ':dpid' => $dpid));
//Yii::app()->end(json_encode(array('status'=>false,'msg'=>"234")));
if (empty($order)) {
return json_encode(array('status' => false, 'msg' => "该订单不存在"));
}
}
// return json_encode(array('status'=>false,'msg'=>"test2236"));
if ($order->is_temp == "0") {
// return json_encode(array('status'=>false,'msg'=>"test2235"));
$criteria = new CDbCriteria();
$criteria->condition = 't.dpid=' . $dpid . ' and t.site_id=' . $order->site_id . ' and t.is_temp=' . $order->is_temp;
$criteria->order = ' t.lid desc ';
$siteNo = SiteNo::model()->find($criteria);
//order site 和 siteno都需要更新状态 所以要取出来
$criteria2 = new CDbCriteria();
$criteria2->condition = 't.dpid=' . $dpid . ' and t.lid=' . $order->site_id;
$criteria2->order = ' t.lid desc ';
$site = Site::model()->with("siteType")->find($criteria2);
// return json_encode(array('status'=>false,'msg'=>"test8"));
$printList = Helper::printKitchenAll3($order, $site, $siteNo, false);
} else {
// return json_encode(array('status'=>false,'msg'=>"test223"));
$pad = Pad::model()->with('printer')->find(' t.dpid=:dpid and t.lid=:lid', array(':dpid' => $order->dpid, 'lid' => $padId));
//前面加 barcode
$precode = "1D6B450B" . strtoupper(implode('', unpack('H*', 'A' . $order->lid))) . "0A" . strtoupper(implode('', unpack('H*', 'A' . $order->lid))) . "0A";
$orderProducts = OrderProduct::getOrderProducts($order->lid, $order->dpid);
//var_dump($orderProducts);exit;
//return json_encode(array('status'=>false,'msg'=>"test2234"));
$memo = "清单";
$printList = Helper::printList($order, $orderProducts, $pad, $precode, "0", $memo);
}
if (!$printList['status']) {
throw new Exception(json_encode($printList));
}
//$printList2=array_merge($printList,array('sitenoid'=> $lid));
// }
$transaction->commit();
//估清产品通知
if (!empty($sellOff)) {
Gateway::getOnlineStatus();
$store = Store::instance('wymenu');
$pads = Pad::model()->findAll(" dpid = :dpid and delete_flag='0' and pad_type in ('0','1','2')", array(":dpid" => $dpid));
//var_dump($pads);exit;
$sendjsondata = json_encode(array("company_id" => $dpid, "do_id" => "sell_off", "do_data" => $sellOff));
//var_dump($sendjsondata);exit;
foreach ($pads as $pad) {
$clientId = $store->get("padclient_" . $dpid . $pad->lid);
//var_dump($clientId,$print_data);exit;
if (!empty($clientId)) {
Gateway::sendToClient($clientId, $sendjsondata);
}
}
}
return json_encode($printList);
} catch (Exception $e) {
$transaction->rollback();
//如果操作失败, 数据回滚
throw new Exception($e->getMessage());
//return $e->getMessage();
}
}
public function actionResetall()
{
$typeId = Yii::app()->request->getParam('typeId');
$db = Yii::app()->db;
$sql = '';
if ($typeId == 'product') {
$sql = 'update nb_product set store_number = -1 where dpid=' . $this->companyId;
} else {
$sql = 'update nb_product_set set store_number = -1 where dpid=' . $this->companyId;
}
//var_dump($sql);exit;
$command = $db->createCommand($sql);
if ($command->execute()) {
Gateway::getOnlineStatus();
$store = Store::instance('wymenu');
$pads = Pad::model()->findAll(" dpid = :dpid and delete_flag='0' and pad_type in ('1','2')", array(":dpid" => $this->companyId));
//var_dump($pads);exit;
$sendjsondata = json_encode(array("company_id" => $this->companyId, "do_id" => "sell_off", "do_data" => array(array("product_id" => $id, "type" => $typeId, "num" => $store_number))));
//var_dump($sendjsondata);exit;
foreach ($pads as $pad) {
$clientId = $store->get("padclient_" . $this->companyId . $pad->lid);
//var_dump($clientId,$print_data);exit;
if (!empty($clientId)) {
Gateway::sendToClient($clientId, $sendjsondata);
}
}
Yii::app()->end(json_encode(array("status" => "success")));
} else {
Yii::app()->end(json_encode(array("status" => "fail")));
}
}
public static function printPadList(Order $order, $padid)
{
$pad = Pad::model()->find(' dpid=:dpid and lid=:lid', array(':dpid' => $order->dpid, 'lid' => $padid));
$printer = Printer::model()->find('lid=:printerId and dpid=:dpid', array(':printerId' => $pad->printer_id, ':dpid' => $order->dpid));
if (empty($printer)) {
return array('status' => false, 'dpid' => $order->dpid, 'jobid' => "0", 'type' => 'none', 'msg' => yii::t('app', 'PAD还没有设置默认打印机'));
}
$hasData = false;
$orderProducts = OrderProduct::getOrderProducts($order->lid, $order->dpid);
///site error because tempsite and reserve**************
if ($order->is_temp == 0) {
$site = Site::model()->find('lid=:lid and dpid=:dpid', array(':lid' => $order->site_id, ':dpid' => $order->dpid));
$siteType = SiteType::model()->find('lid=:lid and dpid=:dpid', array(':lid' => $site->type_id, ':dpid' => $order->dpid));
$strSite = Helper::getPlaceholderLen(yii::t('app', '座号：') . $siteType->name . ' ' . $site->serial, 48);
} else {
$strSite = Helper::getPlaceholderLen(yii::t('app', '座号：临时座') . $order->site_id % 1000, 48);
}
///////$listKey = $order->dpid.'_'.$printer->ip_address;
//var_dump($list);exit;
//$listData = array(Helper::getPlaceholderLenBoth($order->company->company_name, 48));
$listData = array("22" . Helper::setPrinterTitle($order->company->company_name, 8));
array_push($listData, $strSite);
array_push($listData, str_pad('', 48, '-'));
foreach ($orderProducts as $product) {
//var_dump($product);exit;
$hasData = true;
if (Yii::app()->language == 'jp') {
array_push($listData, Helper::getPlaceholderLen($product['product_name'], 36) . Helper::getPlaceholderLen($product['amount'] . " X " . number_format($product['price'], 0), 12));
} else {
array_push($listData, Helper::getPlaceholderLen($product['product_name'], 24) . Helper::getPlaceholderLen($product['amount'] . $product['product_unit'], 12) . Helper::getPlaceholderLen(number_format($product['price'], 2), 12));
}
}
array_push($listData, str_pad('', 48, '-'));
array_push($listData, str_pad(yii::t('app', '合计：') . $order->reality_total, 24, ' ') . str_pad(yii::t('app', '时间：') . time(), 24, ' '));
array_push($listData, str_pad(yii::t('app', '服务员：') . $order->username, 48, ' '));
//前面加 barcode
$precode = "1D6B450B" . strtoupper(implode('', unpack('H*', 'A' . $order->lid))) . "0A" . strtoupper(implode('', unpack('H*', 'A' . $order->lid))) . "0A";
//后面加切纸
$sufcode = "0A0A0A0A0A0A1D5601";
if ($hasData) {
return Helper::printConetent($printer, $listData, $precode, $sufcode);
} else {
return array('status' => false, 'dpid' => $printer->dpid, 'jobid' => "0", 'type' => 'none', 'msg' => yii::t('app', '没有要打印的菜品'));
}
}
public function actionOpensiteprint()
{
if (Yii::app()->request->isPostRequest) {
$sid = Yii::app()->request->getPost('sid');
$siteNumber = Yii::app()->request->getPost('siteNumber');
$companyId = Yii::app()->request->getPost('companyId');
$padId = Yii::app()->request->getPost('padId', "0000000000");
if (!Until::validOperateJson($companyId, $this)) {
$ret = json_encode(array('status' => 0, 'msg' => yii::t('app', '云端不能操作本地数据'), 'siteid' => $sid));
Yii::app()->end($ret);
}
//$sid = Yii::app()->request->getPost('sid');
$istemp = Yii::app()->request->getPost('istemp', '0');
$ret = SiteClass::openSite($companyId, $siteNumber, $istemp, $sid);
if ($ret["status"] == 1) {
$siteno;
$site = new Site();
$siteid = $ret['siteid'];
$criteria = new CDbCriteria();
$criteria->condition = 't.dpid=' . $companyId . ' and t.site_id=' . $siteid . ' and t.is_temp=' . $istemp;
$criteria->order = ' t.lid desc ';
$siteno = SiteNo::model()->find($criteria);
//Yii::app()->end(json_encode(array('status'=>0,'msg'=>"222")));
//order site 和 siteno都需要更新状态 所以要取出来
if ($istemp == "0") {
$criteria2 = new CDbCriteria();
$criteria2->condition = 't.dpid=' . $companyId . ' and t.lid=' . $siteid;
$criteria2->order = ' t.lid desc ';
$site = Site::model()->with("siteType")->find($criteria2);
}
$pad = Pad::model()->find(' dpid=:dpid and lid=:lid', array(':dpid' => $companyId, 'lid' => $padId));
if (!empty($pad)) {
//$precode="1B70001EFF00";//开钱箱
$precode = "";
$printserver = "1";
$memo = "请等待叫号！";
$ret = Helper::printSite($siteno, $site, $pad, $precode, $printserver, $memo);
} else {
$ret = array('status' => 0, 'msg' => yii::t('app', '没有找到PAD'), 'siteid' => $siteid);
}
}
Yii::app()->end(json_encode($ret));
}
}
public function actionDelete()
{
$companyId = Helper::getCompanyId(Yii::app()->request->getParam('companyId'));
$ids = Yii::app()->request->getPost('ids');
Until::isUpdateValid($ids, $companyId, $this);
//0,表示企业任何时候都在云端更新。
//var_dump($ids);exit;
if (!empty($ids)) {
foreach ($ids as $id) {
$model = Pad::model()->find('lid=:id and dpid=:companyId', array(':id' => $id, ':companyId' => $companyId));
if ($model) {
$model->saveAttributes(array('delete_flag' => 1, 'update_at' => date('Y-m-d H:i:s', time())));
}
}
$this->redirect(array('pad/index', 'companyId' => $companyId));
} else {
Yii::app()->user->setFlash('error', yii::t('app', '请选择要删除的项目'));
$this->redirect(array('pad/index', 'companyId' => $companyId));
}
}
public function actionOrderDaliyCollectPrint()
{
$criteria = new CDbCriteria();
$begin_time = Yii::app()->request->getParam('begin_time', date('Y-m-d', time()));
$end_time = Yii::app()->request->getParam('end_time', date('Y-m-d', time()));
$padid = Yii::app()->request->getParam('padid');
$ret = array();
$criteria->select = 't.paytype, t.payment_method_id,t.dpid, t.update_at,sum(t.pay_amount) as should_all';
//利用Yii框架CDB语句时，聚合函数要在model的类里面进行公共变量定义，如：变量should_all在order的class里面定义为public $should_all;
//$criteria->select = 'sum(t.should_total) as should_all'; //代表了要查询的字段，默认select='*';
$criteria->with = array("order");
//连接表
$criteria->addCondition("t.dpid= " . $this->companyId);
$criteria->addCondition("order.update_at >='{$begin_time} 00:00:00'");
$criteria->addCondition("order.update_at <='{$end_time} 23:59:59'");
$criteria->group = "t.paytype";
$models = OrderPay::model()->findAll($criteria);
if (count($models) == 0) {
$ret = array('status' => false, 'msg' => "没有数据！");
Yii::app()->end(json_encode($ret));
}
//var_dump($model[0]->order);exit;
//Yii::app()->end(json_encode(array('status'=>false,'msg'=>"111")));
////////////////
$transaction = Yii::app()->db->beginTransaction();
try {
$userId = Yii::app()->user->userId;
// lid_dpid
$userIdArr = explode('_', $userId);
$se = new Sequence("close_account");
$clid = $se->nextval();
$closeA = new CloseAccount();
$closeAdata = array('lid' => $clid, 'dpid' => $this->companyId, 'create_at' => date('Y-m-d H:i:s', time()), 'update_at' => date('Y-m-d H:i:s', time()), 'user_id' => $userIdArr[0], 'begin_time' => $begin_time, 'end_time' => $end_time, 'close_day' => date('Y-m-d H:i:s', time()), 'all_money' => 0);
$closeA->attributes = $closeAdata;
$closeA->save();
$totalMoney = 0;
foreach ($models as $model) {
//插入明细表
$se = new Sequence("close_account_detail");
$lid = $se->nextval();
$closeADel = new CloseAccountDetail();
$closeADeldata = array('lid' => $lid, 'dpid' => $this->companyId, 'create_at' => date('Y-m-d H:i:s', time()), 'update_at' => date('Y-m-d H:i:s', time()), 'close_account_id' => $clid, 'paytype' => $model->paytype, 'payment_method_id' => $model->payment_method_id, 'all_money' => $model->should_all);
$closeADel->attributes = $closeADeldata;
$closeADel->save();
$totalMoney += $model->should_all;
}
//更改订单表状态
//Order::model()->updateAll(array('order_status'=>8),'update_at >=:begin_time and :end_time >=update_at and order_status in (3,4) and dpid=:dpid',array(':begin_time'=>$begin_time,':end_time'=>$end_time));
$sqlorderup = "update nb_order set order_status=8 where dpid={$this->companyId} and update_at >='{$begin_time} 00:00:00' and update_at<='{$end_time} 23:59:59' and order_status in (4)";
//var_dump($sqlorderup);exit;
Yii::app()->db->createCommand($sqlorderup)->execute();
$cmodel = CloseAccount::model()->find('lid=:lid and dpid=:dpid', array(':lid' => $clid, 'dpid' => $this->companyId));
$cmodel->all_money = $totalMoney;
$cmodel->update();
///////////////////////
$pad = Pad::model()->with('printer')->find(' t.dpid=:dpid and t.lid=:lid', array(':dpid' => $this->companyId, 'lid' => $padid));
//前面加 barcode
$precode = "";
$memo = "日结对账单";
$ret = Helper::printCloseAccount($this->companyId, $models, $pad, $precode, "0", $memo);
$transaction->commit();
//提交事务会真正的执行数据库操作
//echo 1;
} catch (Exception $e) {
$transaction->rollback();
//如果操作失败, 数据回滚
//echo 0;
$ret = array('status' => false, 'msg' => "请重试！");
}
Yii::app()->end(json_encode($ret));
}
public function actionPrintPadList()
{
$orderId = Yii::app()->request->getParam('orderId', 0);
$companyId = Yii::app()->request->getParam('companyId');
$padId = Yii::app()->request->getParam('padId');
$order = Order::model()->with('company')->find('t.lid=:id and t.dpid=:dpid', array(':id' => $orderId, ':dpid' => $companyId));
$pad = Pad::model()->with('printer')->find(' t.dpid=:dpid and t.lid=:lid', array(':dpid' => $order->dpid, 'lid' => $padId));
//要判断打印机类型错误，必须是local。
if ($pad->printer->printer_type != '1') {
Yii::app()->end(json_encode(array('status' => false, 'jobid' => "0", 'type' => 'local', 'msg' => yii::t('app', '必须是本地打印机！'))));
} else {
//前面加 barcode
$precode = "1D6B450B" . strtoupper(implode('', unpack('H*', 'A' . $order->lid))) . "0A" . strtoupper(implode('', unpack('H*', 'A' . $order->lid))) . "0A";
Yii::app()->end(json_encode(Helper::printList($order, $pad, $precode)));
}
}
