function init() { $tmsql = new phpMysql_h(); $tmsql->init(); $str = "SELECT * FROM {$tmsql->system} "; $tmsql->query($str); list($tserial, $tgomark, $tpictext1, $tpictext2, $tpictext3) = mysql_fetch_row($tmsql->listmysql); $tmsql->close_mysql(); $this->tn_serial = $tserial; $this->tn_gomark = $tgomark; $this->tn_pictext1 = $tpictext1; $this->tn_pictext2 = $tpictext2; $this->tn_pictext3 = $tpictext3; }
exit; } elseif ($act == "doSpeedMatch") { $ps = " WHERE id={$aid} "; $row = loaddata_row($dbTable['application'][$cateid], $ps); // $year = substr($row['deadline'],0,4); // $month = substr($row['deadline'],5,2); // $day = substr($row['deadline'],8,2); // $hour = substr($row['deadline'],11,2); // $min = substr($row['deadline'],14,2); // $sec = substr($row['deadline'],17,2); // $deadline2 = date("Y-m-d H:i:s",mktime($hour, $min, $sec, $month, $day+7, $year)); $msql = new phpMysql_h(); $msql->init(); $sql = "UPDATE " . $dbTable['application'][$cateid] . " SET status='2' , isSpeedMatch='1' , speedmatchTime=NOW() WHERE id={$aid} "; // $sql = "UPDATE ".$dbTable['application'][$cateid]." SET isSpeedMatch='1' , speedmatchTime=NOW() WHERE id=$aid "; $msql->query($sql); $ps = " WHERE isSpeedMatch='1' AND speedmatchTime!='' AND id=" . $aid; $row = loaddata_row($dbTable['application'][$cateid], $ps); if ($row) { echo "OK"; //已完成快速服務設定 } else { echo "NOT"; //快速服務設定失敗 } exit; } elseif ($act == "getLastDesc") { $ps = " WHERE id={$aid} "; $row = loaddata_row($dbTable['application'][$cateid], $ps); } elseif ($act == "setSession") { if (!$_SESSION[$name]) {
if (!$_SESSION) { session_start(); } // ini_set('default_charset', 'utf-8'); //--- 讀入基本設定 include "function/function.php"; require 'libs/Smarty.class.php'; include "base_config.php"; // include ADMINROOT."/getfile.php"; $msql = new phpMysql_h(); $tool = new tools_h(); $sql = "SELECT id FROM `wwd_application_speedmatch` WHERE applyid='" . $aid . "' AND cateid='" . $cateid . "' "; // echo "<br>sql=".$sql; exit; $msql->init(); $msql->query($sql); if (list($id) = mysql_fetch_row($msql->listmysql)) { $tool->showmessage("此需求單已送過快速服務申請,請勿重複操作或聯繫客服人員確認!"); $tool->goURL2("parent", "member_client_myneeds01.php"); exit; } $hash = uniqid(mt_srand((double) microtime() * 1000000)); $sql = "INSERT INTO `wwd_application_speedmatch` (`hash`,`cateid` ,`applyid` ,`serial` ,`firstname` ,`sex` ,`mobile` ,`contactable` ,`office_city` ,\n\t\t`office_area` ,`isSeen` ,`SheetBuyPlace` ,`buySelf` ,`creator` ,`createdtime`) VALUES ('{$hash}', '{$cateid}', '{$aid}', '{$serial}', '{$firstname}', \n\t\t'{$sex}', '{$mobile}', '{$contactable}', '{$office_city}', '{$office_area}', '{$isSeen}', '{$SheetBuyPlace}', '{$buySelf}', '" . $_COOKIE[user_id] . "', \n\t\tNOW());"; // error_log($sql."\r\n\r\n",3,"log_fast_do_sql.log"); $msql->init(); $msql->query($sql); $sql2 = "SELECT id FROM `wwd_application_speedmatch` WHERE hash='" . $hash . "' "; $msql->init(); $msql->query($sql2); if (list($id2) = mysql_fetch_row($msql->listmysql)) { if ($_COOKIE[user_email] != "*****@*****.**") {