/**
* 保存审核结果
*/
public function saveAuditResult()
{
$id = $_POST['id'];
$status = $_POST['status'];
$note = $_POST['note'];
if (empty($id) || empty($status)) {
$arr = array('code' => '2', 'msg' => '参数有误');
return json_encode($arr);
}
$where = "id='{$id}'";
$row = SuperorderAuditModel::getOne('id,status', $where);
if (empty($row) || $row['status'] == 1) {
$arr = array('code' => '3', 'msg' => '已经审核');
return json_encode($arr);
}
$data = array();
$data['status'] = $status;
$data['auditUserId'] = $_SESSION['sysUserId'];
$data['auditNote'] = $note;
$data['auditTime'] = time();
$isOk = SuperorderAuditModel::update($data, $where);
if ($isOk) {
$arr = array('code' => '1', 'msg' => 'success');
} else {
$arr = array('code' => '2', 'msg' => '更新出错');
}
return json_encode($arr);
}
function process_message($msg)
{
$dataStr = $msg->body;
print_r($dataStr);
//print
// $filename = '/data/web/purchase.valsun.cn/log/superorder.txt';
// file_put_contents($filename, date("Y-m-d H:i:s")."\t".$dataStr."\r\n", FILE_APPEND);
if (empty($dataStr)) {
return;
}
$dataArr = json_decode($dataStr, true);
if (!isset($dataArr['omOrderId'], $dataArr['omOrderdetailId'], $dataArr['sku'], $dataArr['amount'])) {
return;
}
reconnect();
//mysql 重新连接
$where = "omOrderdetailId='{$dataArr['omOrderdetailId']}' and omOrderId='{$dataArr['omOrderId']}' and sku='{$dataArr['sku']}' and is_delete=0 ";
try {
$row = SuperorderAuditModel::getOne('id, amount', $where);
} catch (Exception $e) {
print_r(array($e->getMessage(), $e->getTraceAsString()));
return;
}
$data_array = array();
$data_array['omOrderId'] = $dataArr['omOrderId'];
$data_array['omOrderdetailId'] = $dataArr['omOrderdetailId'];
$data_array['sku'] = $dataArr['sku'];
$data_array['amount'] = $dataArr['amount'];
if (!empty($row)) {
if ($row['amount'] != $dataArr['amount'] && $dataArr['amount'] != 0) {
$where = " id='{$row['id']}'";
$isOk = SuperorderAuditModel::update(array('is_delete' => 1), $where);
if ($isOk) {
$data_array['addTime'] = time();
$isOk = SuperorderAuditModel::add($data_array);
}
}
// echo '111'."\n";
// var_dump($isOk);
} else {
$data_array['addTime'] = time();
$isOk = SuperorderAuditModel::add($data_array);
// echo '222'."\n";
// var_dump($isOk);
}
if ($isOk) {
$msg->delivery_info['channel']->basic_ack($msg->delivery_info['delivery_tag']);
}
}
/**
* 将审核超大订单的结果更新到订单系统
*/
public static function pushBigOrder()
{
$id = $_POST['id'];
$status = $_POST['status'];
$note = $_POST['note'];
if (empty($id) || empty($status)) {
$arr = array('code' => '2', 'msg' => '参数有误');
return json_encode($arr);
}
$where = "id='{$id}'";
$row = SuperorderAuditModel::getOne('*', $where);
if (empty($row) || $row['status'] == 1) {
$arr = array('code' => '3', 'msg' => '已经审核');
return json_encode($arr);
}
$paramArr = array('method' => 'order.updateOrderAuditFromPh', 'format' => 'json', 'v' => '1.0', 'username' => C('OPEN_SYS_USER'));
/* API应用级输入参数 Start*/
$paramArr['omOrderId'] = $row['omOrderId'];
$paramArr['omOrderdetailId'] = $row['omOrderdetailId'];
$paramArr['sku'] = $row['sku'];
$paramArr['auditStatus'] = $status;
$paramArr['auditUser'] = $_SESSION['sysUserId'];
$paramArr['note'] = $note;
/* API应用级输入参数 End*/
$result = callOpenSystem($paramArr, 'local');
$result = json_decode($result, true);
//add log
//$filename = C("LOG_PATH").'/pushbigorder.txt';
//write_log($filename, $result);
if ($result['data'] == true) {
$res['code'] = '1';
$res['msg'] = 'success';
} else {
$res['code'] = '2';
$res['msg'] = $result['errMsg'];
}
return json_encode($res);
}
/**
* 方法功能：修改
* 说明：传递过来的$data_array必须是关联数组，例如：array('key'=>'value'),
* 其中key是要修改的表的字段名称,value是要给字段重新赋的值；$where参数是条件
* @param unknown $data_array
* @param unknown $where
* @return boolean
*/
public static function update($data_array, $where)
{
self::initDB();
if (empty($data_array) || !is_array($data_array)) {
//判断是否是数组
self::$errCode = '004';
self::$errMsg = "SuperorderAuditModel update error1";
return false;
}
$setting = '';
foreach ($data_array as $key => $value) {
$setting .= ',`' . $key . '` = \'' . $value . '\'';
//把数组内容转换为字符串格式，例如：`dept_name`='it',`dept_principal`='admin'
}
$setting = ltrim($setting, ',');
//去除最左边的逗号
$sql = 'UPDATE `' . self::$table_name . '` SET ' . $setting . ' WHERE ' . $where;
//echo $sql."\n";
return self::$dbConn->query($sql);
}
