public function actionGetMember()
{
$card = Yii::app()->request->getParam('card', 0);
$criteria = new CDbCriteria();
$criteria->addCondition('dpid=:dpid and delete_flag=0');
if ($card) {
$criteria->addCondition('rfid=:card');
$criteria->addCondition('selfcode=:card', 'OR');
$criteria->addCondition('name=:card', 'OR');
$criteria->addCondition('mobile=:card', 'OR');
$criteria->params[':card'] = $card;
}
$criteria->order = ' lid desc ';
$criteria->params[':dpid'] = $this->companyId;
$model = MemberCard::model()->find($criteria);
if ($model) {
$res = array('rfid' => $model->rfid, 'selfcode' => $model->selfcode, 'all_money' => $model->all_money, 'name' => $model->name, 'mobile' => $model->mobile, 'email' => $model->email);
Yii::app()->end(json_encode(array('status' => true, 'msg' => $res)));
} else {
Yii::app()->end(json_encode(array('status' => false, 'msg' => '没有查询到该会员信息')));
}
}
public function actionOrderAccount()
{
$companyId = Yii::app()->request->getParam('companyId', "0");
$orderid = Yii::app()->request->getParam('orderid', "0");
$orderstatus = Yii::app()->request->getParam('orderstatus', "0");
$paycashaccount = floatval(str_replace(",", "", Yii::app()->request->getPost('paycashaccount', "0")));
$payothers = floatval(str_replace(",", "", Yii::app()->request->getPost('payothers', "0")));
$paymemberaccount = floatval(str_replace(",", "", Yii::app()->request->getPost('paymemberaccount', "0")));
$payunionaccount = floatval(str_replace(",", "", Yii::app()->request->getPost('payunionaccount', "0")));
$payshouldaccount = floatval(str_replace(",", "", Yii::app()->request->getPost('payshouldaccount', "0")));
$payoriginaccount = floatval(str_replace(",", "", Yii::app()->request->getPost('payoriginaccount', "0")));
$cardno = Yii::app()->request->getParam('cardno', "0000000000");
$ordermemo = Yii::app()->request->getPost('ordermemo', "0");
//存数order order_pay 0现金，4会员卡，5银联
//写入会员卡消费记录，会员卡总额减少
$ret;
$time = date('Y-m-d H:i:s', time());
$db = Yii::app()->db;
if (!Until::validOperateJson($companyId, $this)) {
Yii::app()->end(json_encode(array('status' => false, 'msg' => "云端不能操作本地数据")));
}
$transaction = $db->beginTransaction();
try {
$order = Order::model()->with("company")->find(" t.lid=:lid and t.dpid=:dpid", array(":lid" => $orderid, ":dpid" => $companyId));
if ($order->order_status > "3") {
$transaction->rollback();
$ret = json_encode(array('status' => false, 'msg' => "已经结单"));
Yii::app()->end($ret);
}
$order->should_total = $payoriginaccount;
$order->reality_total = $payshouldaccount;
$order->update_at = $time;
$order->order_status = $orderstatus;
$order->remark = $order->remark + $ordermemo;
$order->save();
// $criteria = new CDbCriteria;
// $criteria->condition = 't.dpid='.$companyId.' and t.site_id='.$order->site_id.' and t.is_temp='.$order->is_temp ;
// $criteria->order = ' t.lid desc ';
// $siteNo = SiteNo::model()->find($criteria);
// $siteNo->status=$orderstatus;
// $siteNo->save();
//为了删除脏数据，这里用全部的update
$sitenosql = "update nb_site_no set status=" . $orderstatus . " where dpid=" . $companyId . " and site_id=" . $order->site_id . " and is_temp=" . $order->is_temp;
$db->createCommand($sitenosql)->execute();
//order site 和 siteno都需要更新状态 所以要取出来
if ($order->is_temp == "0") {
$criteria2 = new CDbCriteria();
$criteria2->condition = 't.dpid=' . $companyId . ' and t.lid=' . $order->site_id;
$criteria2->order = ' t.lid desc ';
$site = Site::model()->with("siteType")->find($criteria2);
$site->status = $orderstatus;
$site->save();
}
$se = new Sequence("order_pay");
//Yii::app()->end(json_encode(array('status'=>false,'msg'=>"测试啊")));
if ($paycashaccount > 0) {
$orderPayId = $se->nextval();
//插入一条
$orderPayData = array('lid' => $orderPayId, 'dpid' => $companyId, 'create_at' => $time, 'order_id' => $orderid, 'update_at' => $time, 'pay_amount' => $paycashaccount, 'paytype' => "0", 'payment_method_id' => "0000000000", 'remark' => '现金付款');
$db->createCommand()->insert('nb_order_pay', $orderPayData);
}
if ($paymemberaccount > 0) {
$membercard = MemberCard::model()->find(' dpid=:dpid and (rfid =:rfid or selfcode =:selfcode) and delete_flag =0', array(":dpid" => $companyId, ":rfid" => $cardno, ":selfcode" => $cardno));
// $ret=json_encode(array('status'=>false,'msg'=>$paymemberaccount ));
// Yii::app()->end($ret);
if ($membercard->all_money >= $paymemberaccount) {
$membercard->all_money = $membercard->all_money - $paymemberaccount;
$membercard->save();
} else {
$transaction->rollback();
$ret = json_encode(array('status' => false, 'msg' => "会员卡余额不足"));
Yii::app()->end($ret);
}
$orderPayId = $se->nextval();
//插入一条
$orderPayData = array('lid' => $orderPayId, 'dpid' => $companyId, 'create_at' => $time, 'order_id' => $orderid, 'update_at' => $time, 'pay_amount' => $paymemberaccount, 'paytype' => "4", 'payment_method_id' => $cardno, 'remark' => '会员卡付款');
$db->createCommand()->insert('nb_order_pay', $orderPayData);
}
if ($payunionaccount > 0) {
$orderPayId = $se->nextval();
//插入一条
$orderPayData = array('lid' => $orderPayId, 'dpid' => $companyId, 'create_at' => $time, 'order_id' => $orderid, 'update_at' => $time, 'pay_amount' => $payunionaccount, 'paytype' => "5", 'payment_method_id' => "0000000000", 'remark' => '银联卡付款');
$db->createCommand()->insert('nb_order_pay', $orderPayData);
}
if ($payothers > 0) {
$orderPayId = $se->nextval();
//插入一条
$orderPayData = array('lid' => $orderPayId, 'dpid' => $companyId, 'create_at' => $time, 'order_id' => $orderid, 'update_at' => $time, 'pay_amount' => $payothers, 'paytype' => "3", 'payment_method_id' => "3990000000", 'remark' => '大众点评临时');
$db->createCommand()->insert('nb_order_pay', $orderPayData);
}
$transaction->commit();
$ret = json_encode(array('status' => true, 'msg' => "结单成功"));
} catch (Exception $ex) {
$transaction->rollback();
$ret = json_encode(array('status' => false, 'msg' => "结单失败"));
}
Yii::app()->end($ret);
}