/**
* Execute the job.
*
* @return void
*/
public function handle()
{
$msgStart = msgSend($this->msgText, $this->phone);
$massMess = new MassMessage();
$massMess->user_id = $this->user->id;
$massMess->phone = $this->phone;
$massMess->txt = $this->msgText;
$massMess->start = $msgStart;
$massMess->save();
/* file_put_contents("text.txt", $this->user->id."\n", FILE_APPEND);*/
}
$msgEvent = $weObj->getRevEvent();
// 关注自动回复
if (strtolower($msgEvent['event']) === 'subscribe') {
msgSend('welcome');
} elseif (strtolower($msgEvent['event']) === 'click') {
msgSend($msgEvent['key']);
}
break;
// 收到文本消息
// 收到文本消息
case Wechat::MSGTYPE_TEXT:
$msgKey = $weObj->getRevContent();
if (strlen($msgKey) > 20) {
exit;
}
msgSend($msgKey);
break;
// 收到图片消息
// 收到图片消息
case Wechat::MSGTYPE_IMAGE:
$msgImage = $weObj->getRevPic();
// 下载图片
$fileData = xcurl($msgImage['picurl']);
if (is_string($fileData) && substr($fileData, 0, 10) === 'curl_error') {
exit;
}
// 写入图片
$fileFolder = 'wechat-photo/';
$fileName = date('Ymd-His') . '-' . $weObj->getRevID();
file_put_contents($fileFolder . $fileName, $fileData);
$fileInfo = getimagesize($fileFolder . $fileName);
/**
* handles a new purchase response
*
* @param string $key
* @param clsMailMsg $oMSG
* @param array $config
* @return bool
*/
function response_order($key, $oMSG, $config)
{
if (($stds = msg_std($oMSG)) === false) {
return false;
}
list($compname, $ipaddr, $bustel, $fromwho, $email) = $stds;
/* other side key */
if (($yourkey = getfrommmsg(REGEX_YOURKEY, $oMSG)) === false) {
return false;
}
/* purchase id in my database */
if (($purid = getfrommmsg(REGEX_PURID, $oMSG)) === false) {
return false;
}
/* purchase accepted/invoices/denied */
if (($purstatus = getfrommmsg(REGEX_PURSTATUS, $oMSG)) === false) {
return false;
}
/* validate keys */
if (($keyinfo = trhKeyPair($key, $yourkey)) === false) {
return false;
}
$userinfo = qryUsers($keyinfo["userid"]);
require_lib("validate");
$v = new validate();
if (!$v->isOk($purid, "num", 1, 20, "")) {
return false;
}
$sql = "SELECT * FROM cubit.purchases WHERE purid = '{$purid}'";
if (!($purRslt = db_exec($sql))) {
return false;
}
if (pg_num_rows($purRslt) < 1) {
return false;
}
$pur = pg_fetch_array($purRslt);
if ($purstatus == "d") {
print "Denying purchase: {$purid}\n";
if ($pur['received'] == "y") {
return false;
}
$sql = "SELECT * FROM cubit.pur_items WHERE purid = '{$purid}'";
if (!($stktRslt = db_exec($sql))) {
return false;
}
while ($stkt = pg_fetch_array($stktRslt)) {
print "\tRemoving Item: {$stkt['stkid']}\n";
$sql = "UPDATE cubit.stock SET ordered = (ordered - '{$stkt['qty']}') WHERE stkid = '{$stkt['stkid']}'";
if (!db_exec($sql)) {
return false;
}
$sql = "INSERT INTO cubit.pur_canc_items (purid, whid, stkid, qty, ddate, div, qpack, upack, ppack, svat, rqty, tqty, unitcost, amt, iqty, vatcode, description, account)\n\t\t\t\t\tVALUES ('{$stkt['purid']}', '{$stkt['whid']}', '{$stkt['stkid']}', '{$stkt['qty']}', '{$stkt['ddate']}', '{$stkt['div']}', '{$stkt['qpack']}', '{$stkt['upack']}', '{$stkt['ppack']}', '{$stkt['svat']}', '{$stkt['rqty']}', '{$stkt['tqty']}', '{$stkt['unitcost']}', '{$stkt['amt']}', '{$stkt['iqty']}', '{$stkt['vatcode']}', '{$stkt['description']}', '{$stkt['account']}')";
if (!db_exec($sql)) {
return false;
}
}
$sql = "DELETE FROM cubit.purchases WHERE purid='{$purid}'";
if (!db_exec($sql)) {
return false;
}
$sql = "INSERT INTO cubit.cancelled_purch(purid, deptid, supid, supaddr, terms, pdate, ddate, remarks, received, refno, vatinc, prd, ordernum, part, div, purnum, edit, supname, supno, shipchrg, subtot, total, balance, vat, supinv, apprv, appname, rvat, rshipchrg, rsubtot, rtotal, jobid, jobnum, toggle, cash, shipping, invcd, rshipping, noted, returned, iamount, ivat, delvat, username) VALUES('{$pur['purid']}', '{$pur['deptid']}', '{$pur['supid']}', '{$pur['supaddr']}', '{$pur['terms']}', '{$pur['pdate']}', '{$pur['ddate']}', '{$pur['remarks']}', '{$pur['received']}', '{$pur['refno']}', '{$pur['vatinc']}', '{$pur['prd']}', '{$pur['ordernum']}', '{$pur['part']}', '{$pur['div']}', '{$pur['purnum']}', '{$pur['edit']}', '{$pur['supname']}', '{$pur['supno']}', '{$pur['shipchrg']}', '{$pur['subtot']}', '{$pur['total']}', '{$pur['balance']}', '{$pur['vat']}', '{$pur['supinv']}', '{$pur['apprv']}', '{$pur['appname']}', '{$pur['rvat']}', '{$pur['rshipchrg']}', '{$pur['rsubtot']}', '{$pur['rtotal']}', '{$pur['jobid']}', '{$pur['jobnum']}', '{$pur['toggle']}', '{$pur['cash']}', '{$pur['shipping']}', '{$pur['invcd']}', '{$pur['rshipping']}', '{$pur['noted']}', '{$pur['returned']}', '{$pur['iamount']}', '{$pur['ivat']}', '{$pur['delvat']}', '{$userinfo['username']}')";
if (!db_exec($sql)) {
return false;
}
$msg = "Purchase nr. {$pur['purnum']} denied.";
print "Purchase denied\n";
} else {
if ($purstatus == "a") {
$msg = "Purchase nr. {$pur['purnum']} accepted. You should receive further information from supplier.";
} else {
if ($purstatus == "i") {
$msg = "Purchase nr. {$pur['purnum']} accepted and invoiced. You should receive further information/an invoice from supplier.";
}
}
}
print "Sending msg: {$msg} to user: {$userinfo['username']}\n";
msgSend($userinfo["username"], $msg);
}
