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));
}
