public function getPubSiteInfo($verificodeb, $siteID, $language, $site_type) { $siteInfo = null; /*if(!$this->validateParam($siteID,$verificodeb)) { return 'array()'; }*/ $siteStmt = new SiteClass($siteID); $snc = new SiteNavigateClass($siteID); if ($site_type == 1) { $siteInfo = $siteStmt->getStartPageInfoBySiteId($siteID, $language == 0 ? -1 : $language); } else { if ($site_type == 3) { $siteInfo = $siteStmt->getStartPageInfoWapBySiteId($siteID, $language == 0 ? -1 : $language); // 不存在时返回false } } if ((empty($siteInfo) || $siteInfo == null) && $site_type != 2) { //未设置站点起始页 return 'array()'; } if ($site_type == 1) { $navi = $snc->select($siteInfo->navi_id); $htmlUrl = GlobalClass::getPageUrl(GlobalClass::HTMLMODE, $siteInfo->language, $navi->navi_type_id, $navi->navi_id, $navi->navi_url, $navi->inner_link_id, $siteInfo->page_id); } else { if ($site_type == 3) { $navi = $snc->select($siteInfo->navi_id); $htmlUrl = GlobalClass::getPageUrl(GlobalClass::WAPMODE, $siteInfo->language, $navi->navi_type_id, $navi->navi_id, $navi->navi_url, $navi->inner_link_id, $siteInfo->page_id); } else { $htmlUrl = ""; } } $isHtml = GlobalClass::checkHasOpenMemberSys($siteID, $siteInfo->language) ? 0 : 1; return 'array(\'isHTML\'=>' . $isHtml . ',\'htmlUrl\'=>\'' . $htmlUrl . '\',\'dynamicUrl\'=>\'\')'; }
public static function openTempSite($companyId = 0, $istemp = 1, $siteNumber = 1) { $db = Yii::app()->db; $transaction = $db->beginTransaction(); try { $se = new Sequence("site_no"); $lid = $se->nextval(); $se = new Sequence("temp_site"); $site_id = $se->nextval(); $code = SiteClass::getCode($companyId); $data = array('lid' => $lid, 'dpid' => $companyId, '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' => '1', 'code' => $code, 'number' => $siteNumber, 'delete_flag' => '0'); $db->createCommand()->insert('nb_site_no', $data); $sef = new Sequence("order_feedback"); $lidf = $sef->nextval(); $dataf = array('lid' => $lidf, 'dpid' => $companyId, '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' => yii::t('app', '开台'), 'delete_flag' => '0'); $db->createCommand()->insert('nb_order_feedback', $dataf); $transaction->commit(); return $code; } catch (Exception $e) { $transaction->rollback(); //如果操作失败, 数据回滚 return false; } }
/** * * setting the companyId and padId */ public function actionGetSitePersonsAll() { $companyId = Yii::app()->request->getParam('companyid', '0'); $sitePersons = SiteClass::getSitePersonsAll($companyId); Yii::app()->end(json_encode($sitePersons)); }
public static function getFeedbackSite($companyId, $siteId, $istemp, $orderId, $isOrder) { if ($siteId !== '0000000000') { return SiteClass::getSiteNmae($companyId, $siteId, $istemp); } if ($orderId !== '0000000000') { if ($isOrder == '1') { $order = Order::model()->find(" dpid=:dpid and lid=:orderid", array(':dpid' => $companyId, ':orderid' => $orderId)); return SiteClass::getSiteNmae($companyId, $order->site_id, $order->istemp); } else { $orderProduct = OrderProduct::model()->with("order")->find(" dpid=:dpid and lid=:orderid", array(':dpid' => $companyId, ':orderid' => $orderId)); return SiteClass::getSiteNmae($companyId, $orderProduct->order->site_id, $orderProduct->order->istemp); } } }
public function actionAccountManul() { $orderId = Yii::app()->request->getParam('orderId', '0'); $companyId = Yii::app()->request->getParam('companyId', '0'); $typeId = Yii::app()->request->getParam('typeId', '0'); $callId = Yii::app()->request->getParam('callId', '0'); $padId = Yii::app()->request->getParam('padId', '0000000000'); $totaldata = Yii::app()->request->getParam('total', '0'); ///*************print $criteria = new CDbCriteria(); $criteria->condition = 't.dpid=' . $companyId . ' and t.lid=' . $orderId; $criteria->order = ' t.lid desc '; $order = Order::model()->find($criteria); $order->should_total = $totaldata; $orderpay = new OrderPay(); $orderpay->dpid = $order->dpid; $orderpay->order_id = $order->lid; $orderpay->paytype = "0"; $orderpay->remark = "现金支付"; $orderpay->create_at = date('Y-m-d H:i:s', time()); $paymentMethods = PaymentClass::getPaymentMethodList($companyId); //var_dump($paymentMethods);exit; if (Yii::app()->request->isPostRequest) { Until::validOperate($companyId, $this); //var_dump(Yii::app()->request->getPost('Order'));exit; $order->attributes = Yii::app()->request->getPost('Order'); $order->pay_time = date('Y-m-d H:i:s', time()); $orderpay->attributes = Yii::app()->request->getPost('OrderPay'); $order->paytype = $orderpay->paytype; //$order->payment_method_id=$orderpay->payment_method_id; $order->reality_total += $orderpay->pay_amount; $order->remark .= $orderpay->remark; $se = new Sequence("order_pay"); $orderpay->lid = $se->nextval(); //var_dump($order);exit; $memo = ""; if ($order->order_status == "3") { $memo = yii::t('app', '收款') . ":" . $orderpay->pay_amount; } else { if ($order->order_status == "4") { $memo = yii::t('app', '结单') . ":" . $orderpay->pay_amount; } } $transaction = Yii::app()->db->beginTransaction(); try { $criteria2 = new CDbCriteria(); $criteria2->condition = 't.status in ("1","2","3") and t.dpid=' . $order->dpid . ' and t.site_id=' . $order->site_id . ' and t.is_temp=' . $order->is_temp; $criteria2->order = ' t.lid desc '; $siteNo = SiteNo::model()->find($criteria2); if ($siteNo->is_temp == '0') { $site = Site::model()->with('siteType')->find('t.lid=:lid and t.dpid=:dpid', array(':lid' => $order->site_id, ':dpid' => $order->dpid)); $site->status = $order->order_status; $site->save(); } else { $site = array(); } //$order->order_status=$tempstatus; $order->save(); $orderpay->save(); $siteNo->status = $order->order_status; $siteNo->save(); if ($order->order_status == '4') { SiteClass::deleteCode($this->companyId, $siteNo->code); //FeedBackClass::cancelAllOrderMsg("0000000000","0",$order->lid,$companyId); $sqlfeedback = "update nb_order_feedback set is_deal='1' where dpid=:companyId and site_id=:siteId and is_temp=:istemp"; $commandfeedback = Yii::app()->db->createCommand($sqlfeedback); $commandfeedback->bindValue(":companyId", $companyId); $commandfeedback->bindValue(":siteId", $order->site_id); $commandfeedback->bindValue(":istemp", $order->is_temp); //var_dump($sqlsite);exit; $commandfeedback->execute(); $sqlall = "update nb_order_feedback set is_deal='1'where dpid=:dpid and order_id=:orderId and is_order='1'"; $connorder = Yii::app()->db->createCommand($sqlall); $connorder->bindValue(':dpid', $companyId); $connorder->bindValue(':orderId', $orderId); $connorder->execute(); $sql = 'update nb_order_feedback set is_deal=1 where dpid=:dpid and order_id in (select lid from nb_order_product where dpid=:sdpid and order_id=:sorderId) and is_order=0'; $connorderproduct = Yii::app()->db->createCommand($sql); $connorderproduct->bindValue(':dpid', $companyId); $connorderproduct->bindValue(':sdpid', $companyId); $connorderproduct->bindValue(':sorderId', $orderId); $connorderproduct->execute(); } $transaction->commit(); $pad = Pad::model()->find(' dpid=:dpid and lid=:lid', array(':dpid' => $order->dpid, 'lid' => $padId)); if (!empty($pad)) { $precode = "1B70001EFF00"; //开钱箱 $printserver = "1"; //$orderProducts= //传递要打印的菜品,这里是已经下单的 $orderProducts = OrderProduct::getHasOrderProducts($order->lid, $order->dpid); $ret = Helper::printList($order, $orderProducts, $pad, $precode, $printserver, $memo); } //$ret=array('status'=>false,'dpid'=>"0000000011",'jobid'=>"0",'type'=>'none','msg'=>yii::t('app','没有要打印的菜品!')); $this->redirect(array('default/index', 'companyId' => $this->companyId, 'typeId' => $typeId)); } catch (Exception $e) { $transaction->rollback(); } // $this->renderPartial('printlist' , array( // 'orderId'=>$orderId, // //'companyId'=>$companyId, // 'ret'=>$ret, // // 'typeId'=>$typeId // )); // exit; } //var_dump($order);exit; $this->renderPartial('accountmanul', array('order' => $order, 'orderpay' => $orderpay, 'typeId' => $typeId, 'callid' => $callId, 'padId' => $padId, 'paymentMethods' => $paymentMethods)); }
public function actionMsglist() { $companyId = Yii::app()->request->getParam('companyId'); $site_id = Yii::app()->request->getParam('site_id'); $is_temp = Yii::app()->request->getParam('is_temp'); $criteria = new CDbCriteria(); $criteria->addCondition(' dpid=:dpid and site_id=:siteid and is_temp=:istemp and is_deal=0 and delete_flag=0'); $criteria->order = ' create_at '; $criteria->params[':dpid'] = $companyId; $criteria->params[':siteid'] = $site_id; $criteria->params[':istemp'] = $is_temp; $pages = new CPagination(OrderFeedback::model()->count($criteria)); $pages->applyLimit($criteria); $msgs = OrderFeedback::model()->findAll($criteria); $siteName = SiteClass::getSiteNmae($companyId, $site_id, $is_temp); //$msgs[$i]['name']= SiteClass::getSiteNmae($companyId, $msgs[$i]['site_id'], $msgs[$i]['is_temp']); $this->renderPartial('msglist', array('siteName' => $siteName, 'models' => $msgs, 'pages' => $pages)); }
<?php // example2.php require_once "../../../autoload.php"; $_site = array('siteDomain' => "localhost", 'siteName' => "Example2", 'copyright' => "2016 Barton L. Phillips", 'memberTable' => "members", 'noTrack' => true, 'dbinfo' => array('database' => 'test.sdb', 'engine' => 'sqlite3'), 'count' => false); ErrorClass::setNoEmailErrs(true); ErrorClass::setDevelopment(true); $_site = arraytoobjectdeep($_site); $S = new SiteClass($_site); list($top, $footer) = $S->getPageTopBottom(); // Do some database operations $S->query("select fname, lname from {$S->memberTable}"); $names = ''; while (list($fname, $lname) = $S->fetchrow('num')) { $names .= "{$fname} {$lname}<br>"; } echo <<<EOF {$top} <h1>Example 2</h1> <p>{$names}</p> <hr> {$footer} EOF ;
<?php // example1.php require_once "../../../autoload.php"; $siteinfo = array('siteDomain' => "localhost", 'siteName' => "Example1", 'copyright' => "2016 Barton L. Phillips"); $S = new SiteClass($siteinfo); list($top, $footer) = $S->getPageTopBottom(); echo <<<EOF {$top} <h1>Example 1</h1> <p>Hello World</p> <hr> {$footer} EOF ;
public function actionClosesite() { if (Yii::app()->request->isPostRequest) { $sid = Yii::app()->request->getPost('sid'); $companyId = Yii::app()->request->getPost('companyId'); $istemp = Yii::app()->request->getPost('istemp', '0'); Until::validOperate($companyId, $this); $db = Yii::app()->db; $transaction = $db->beginTransaction(); try { if ($istemp == "0") { $sqlsite = "update nb_site set status='7' where lid=:sid and dpid=:companyId"; $commandsite = $db->createCommand($sqlsite); $commandsite->bindValue(":sid", $sid); $commandsite->bindValue(":companyId", $companyId); $commandsite->execute(); } $sqlsiteno = "update nb_site_no set status='7' where site_id=:sid and is_temp=:istemp and dpid=:companyId and status in ('1','2')"; $commandsiteno = $db->createCommand($sqlsiteno); $commandsiteno->bindValue(":sid", $sid); $commandsiteno->bindValue(":istemp", $istemp); $commandsiteno->bindValue(":companyId", $companyId); $commandsiteno->execute(); $sqlorder = "update nb_order set order_status='7' where site_id=:sid and is_temp=:istemp and dpid=:companyId and order_status in ('1','2')"; $commandorder = $db->createCommand($sqlorder); $commandorder->bindValue(":sid", $sid); $commandorder->bindValue(":istemp", $istemp); $commandorder->bindValue(":companyId", $companyId); $commandorder->execute(); $sqlfeedback = "update nb_order_feedback set is_deal='1' where dpid=:companyId and site_id=:siteId and is_temp=:istemp"; $commandfeedback = $db->createCommand($sqlfeedback); $commandfeedback->bindValue(":companyId", $companyId); $commandfeedback->bindValue(":siteId", $sid); $commandfeedback->bindValue(":istemp", $istemp); //var_dump($sqlsite);exit; $commandfeedback->execute(); //FeedBackClass::cancelAllOrderMsg($sid,$istemp,"0000000000",$companyId); $transaction->commit(); //提交事务会真正的执行数据库操作 // $criteria = new CDbCriteria(); $criteria->condition = 't.dpid=' . $companyId . ' and t.site_id=' . $sid . ' and t.is_temp=' . $istemp; $criteria->order = ' t.lid desc '; $siteNo = SiteNo::model()->find($criteria); SiteClass::deleteCode($siteNo->dpid, $siteNo->code); //var_dump($sid);exit; //apc_delete($siteNo->dpid.$siteNo->code); echo json_encode(array('status' => 1, 'message' => yii::t('app', '撤台成功'))); return true; } catch (Exception $e) { $transaction->rollback(); //如果操作失败, 数据回滚 echo json_encode(array('status' => 0, 'message' => yii::t('app', '撤台失败'))); return false; } } }
public function actionOpensite() { //Yii::app()->language = 'zh_cn'; $sid = Yii::app()->request->getParam('sid'); $siteNumber = Yii::app()->request->getParam('siteNumber'); $companyId = Yii::app()->request->getParam('companyId'); $istemp = Yii::app()->request->getParam('istemp', '0'); //var_dump($sid,$siteNumber,$companyId,$istemp);exit; //$ret= array('status'=>0,'msg'=>yii::t('app','开台失败11'),'siteid'=>"111"); $ret = SiteClass::openSite($companyId, $siteNumber, $istemp, $sid); Yii::app()->end(json_encode($ret)); }