$query = "SELECT dh.*, unix_timestamp(dh.insertt) as insertt, unix_timestamp(dh.modifyt) as modifyt, dri.amount, dri.spoint\n\tFROM `{$config['db'][1]['dbname']}`.`{$config['default_prefix']}deposit_history` dh \n\tLEFT OUTER JOIN `{$config['db'][1]['dbname']}`.`{$config['default_prefix']}deposit_rule_item` dri ON \n\t dh.prefixid = dri.prefixid\n\t AND dh.driid = dri.driid \n\t AND dri.switch = 'Y'\n\tWHERE \n\t\tdh.prefixid = '{$config['default_prefix_id']}' \n\t\tAND dh.dhid = '{$ordernumber}'\n\t\tAND dh.status = 'order'\n\t\tAND dh.switch = 'Y'\n\t";
$table = $db->getQueryRecord($query);
if (empty($table['table']['record'])) {
die;
}
$spoint = (int) $table['table']['record'][0]['spoint'];
//S碼贈點活動
$query = "SELECT spr . * , sp.name spname\n\tFROM `{$config['db'][1]['dbname']}`.`{$config['default_prefix']}scode_promote_rt` spr \n\tLEFT OUTER JOIN `{$config['db'][1]['dbname']}`.`{$config['default_prefix']}scode_promote` sp ON \n\t spr.prefixid = sp.prefixid \n\t\tAND spr.spid = sp.spid \n\t\tAND unix_timestamp( sp.offtime ) >0 \n\t\tAND unix_timestamp() >= unix_timestamp( sp.ontime ) \n\t\tAND unix_timestamp() <= unix_timestamp( sp.offtime ) \n\t\tAND sp.switch = 'Y' \n\tWHERE \n\t\tspr.prefixid = '{$config['default_prefix_id']}' \n\t\tAND spr.behav = 'c' \n\t\tAND spr.amount = '{$spoint}' \n\t\tAND spr.switch = 'Y' \n\t\tAND sp.spid IS NOT NULL \n\t";
$row = $db->getQueryRecord($query);
if (empty($row['table']['record'])) {
$row_scode = '';
} else {
$row_scode = $row['table']['record'][0];
}
//查驗藍新支付寶銷帳狀態
$order = queryOrder($config, $table['table']['record']);
if (empty($order) || $order['status'] != 1 || $order['merchantnumber'] != $config['alipay']['merchantnumber'] || $order['ordernumber'] != $table['table']['record'][0]['dhid']) {
die;
} else {
if ($row_scode) {
//會員充值滿額送S碼
$scodeModel = new ScodeModel();
$scode_promote['spid'] = $row_scode['spid'];
$scode_promote['behav'] = 'c';
$scode_promote['promote_amount'] = $row_scode['num'];
$scode_promote['num'] = $row_scode['amount'];
//插入S碼收取記錄
$scodeModel->insert_scode($scode_promote, $table['table']['record'][0]['userid'], $row_scode['spname']);
}
$query = "INSERT INTO `{$config['db'][1]['dbname']}`.`{$config['default_prefix']}deposit`\n\t\tSET\n\t\t\t `prefixid`='{$config['default_prefix_id']}',\n\t\t\t `userid`='{$table['table']['record'][0]['userid']}', \n\t\t\t `countryid`='{$config['country']}', \n\t\t\t `behav`='user_deposit', \n\t\t\t `currency`='{$currency}',\n\t\t\t `amount`='{$table['table']['record'][0]['amount']}', \n\t\t\t `insertt`=NOW()\n\t\t";
$db->query($query);
exit(0);
}
foreach ($options as $opt => $value) {
switch ($opt) {
case 'l':
listNRENs();
exit(0);
case 'n':
$nren = $value;
break;
case 'o':
$orderNumber = $value;
break;
case 'e':
$extended = true;
break;
/* fallthrough */
/* fallthrough */
case 'h':
default:
show_help();
exit(0);
}
}
/* end foreach */
if (isset($nren) && isset($orderNumber)) {
queryOrder($nren, $orderNumber);
} else {
echo "Some errors with params, please provide proper input\n";
show_help();
}
