/** * 保存审核结果 */ 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); }