$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(); }