function register_service_exten() { if (!User::is_login()) { echo "not_login"; exit; } if (User::is_block()) { echo "no_permission"; exit; } //get user $user = User::$current->data; $user_name = $user['user_name']; //Kieu thanh toan $payment_types = (int) Url::get('payment_types'); //Thong tin gia han $order_service_id = (int) Url::get('order_service_id', 0); //id order service $time_exten = (int) Url::get('time_exten', 0); //thoi gian gia han (thang) $aryOrderService = array(); if ($order_service_id) { $aryOrderService = DB::select("order_services", "id={$order_service_id}"); } if ($aryOrderService) { //kiểm tra thông tin đầu vào if ($aryOrderService['user_use'] != $user_name) { echo "error"; exit; } if ($aryOrderService['active'] != 1) { echo "error"; exit; } $price = $aryOrderService['price'] / $aryOrderService['time_use'] * $time_exten; } else { echo "error"; exit; } if ($payment_types == 1) { $full_name = Url::get("full_name"); $mobile = Url::get("mobile"); if (!$full_name || !$mobile) { echo "error"; exit; } $price = $aryOrderService['price'] / $aryOrderService['time_use'] * $time_exten; $orderInfo = array("user_use" => $user_name, "type_scs" => $aryOrderService['type_scs'], "date_reg" => TIME_NOW, "up_count" => $aryOrderService['up_count'], "cpc_count" => $aryOrderService['cpc_count'], "item_count" => $aryOrderService['item_count'], "take_care" => $aryOrderService['take_care'], "price" => $price, "payment_types" => $payment_types, "time_use" => $time_exten, "active" => -4, "reg_exten_stt" => 1); //insert $id = DB::insert('order_services', $orderInfo); if ($id) { $order_code = "GH_{$order_service_id}_{$id}"; $return_url = WEB_ROOT . "payment_scs.html?cmd=complete_exten&exten_order_id={$id}&payment_types=1&order_service_id={$order_service_id}&time_exten={$time_exten}"; $transaction_info = "Thanh toán DV gia hạn Siêu Chăm Sóc {$aryOrderService['type_scs']} cho {$full_name} [ {$user['user_name']} ], số ĐT liên hệ: {$mobile}"; $order_email = $user['email']; //insert payment_scs exten $pay_info = $full_name . "," . $user['email'] . "," . $mobile . "," . $aryOrderService['type_scs']; $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_type_soha" => 0, "payment_info" => $pay_info, "order_code" => $order_code, "price" => $price, "time" => time(), "error_text" => "Đang chờ thanh toán", "payment_status" => -1, "reg_exten_stt" => 1); //insert DB::insert('payment_scs', $paymentInfo); //Tạo link thanh toán đến Soha Payment $url = SohaPay::buildCheckoutUrl($return_url, $transaction_info, $order_code, $price, $order_email, SCS_MERCHANT_SITE_CODE, SCS_SECURE_CODE); echo $url; exit; } else { echo "error_connect"; exit; } } else { if ($payment_types == 2) { global $display; if ($aryOrderService) { $orderInfo = array("user_use" => $user_name, "type_scs" => $aryOrderService['type_scs'], "date_reg" => TIME_NOW, "up_count" => $aryOrderService['up_count'], "cpc_count" => $aryOrderService['cpc_count'], "item_count" => $aryOrderService['item_count'], "take_care" => $aryOrderService['take_care'], "price" => $price, "payment_types" => $payment_types, "time_use" => $time_exten, "active" => -3, "reg_exten_stt" => 1); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $payment_info = ""; $full_name = AZLib::getParam('ho_ten'); $dienthoai = AZLib::getParam('dien_thoai'); $dia_chi = AZLib::getParam('dia_chi'); $thanh_pho = AZLib::getParam('thanh_pho'); $ngay = AZLib::getParam('ngay'); $time = AZLib::getParam('time'); $payment_info .= $full_name . "," . $dienthoai . "," . $dia_chi . "," . $thanh_pho . "," . $ngay . "," . $time; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('full_name', $full_name); $display->add('dia_chi', $dia_chi); $display->add('thanh_pho', SohaPay::infoForUser($thanh_pho, 'tp')); $display->add('ngay', $ngay); $display->add('time', SohaPay::infoForUser($time, 'time')); $display->add('service_name', $aryOrderService['type_scs']); $display->add('price', number_format($price)); $display->add('time_exten', $time_exten); $content_email = $display->output('payment_online_exten_2', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[AzNetGroup] Gia hạn thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho bang payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $price, "payment_status" => 0, "send_mail_stt" => $send_mail_stt, "reg_exten_stt" => 1); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}&exten=1"; echo $url; exit; } } else { if ($payment_types == 3) { global $display; if ($aryOrderService) { $orderInfo = array("user_use" => $user_name, "type_scs" => $aryOrderService['type_scs'], "date_reg" => TIME_NOW, "up_count" => $aryOrderService['up_count'], "cpc_count" => $aryOrderService['cpc_count'], "item_count" => $aryOrderService['item_count'], "take_care" => $aryOrderService['take_care'], "price" => $price, "payment_types" => $payment_types, "time_use" => $time_exten, "active" => -3, "reg_exten_stt" => 1); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $payment_info = ""; if ($user['mobile_phone'] == "") { $phone = $user['home_phone']; } else { $phone = $user['mobile_phone']; } $payment_info .= $user['email'] . "," . $phone; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('service_name', $aryOrderService['type_scs']); $display->add('price', number_format($price)); $display->add('time_exten', $time_exten); $content_email = $display->output('payment_online_reg_3', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[AzNetGroup] Gia hạn thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho bang payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $price, "payment_status" => 0, "send_mail_stt" => $send_mail_stt, "reg_exten_stt" => 1); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}&exten=1"; echo $url; exit; } } else { if ($payment_types == 4) { global $display; if ($aryOrderService) { $orderInfo = array("user_use" => $user_name, "type_scs" => $aryOrderService['type_scs'], "date_reg" => TIME_NOW, "up_count" => $aryOrderService['up_count'], "cpc_count" => $aryOrderService['cpc_count'], "item_count" => $aryOrderService['item_count'], "take_care" => $aryOrderService['take_care'], "price" => $price, "payment_types" => $payment_types, "time_use" => $time_exten, "active" => -3, "reg_exten_stt" => 1); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $banking_type = Url::get('banking_type'); $banking_code = SohaPay::listBankCode($banking_type); $payment_info = ""; if ($user['mobile_phone'] == "") { $phone = $user['home_phone']; } else { $phone = $user['mobile_phone']; } $payment_info .= $user['email'] . "," . $phone . "," . $banking_code; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('service_name', $aryOrderService['type_scs']); $display->add('price', number_format($price)); $display->add('banking_type', $banking_type); $display->add('accNumber', SohaPay::listAccountNumber($banking_code)); $display->add('banking_name', SohaPay::listBanking($banking_code)); $display->add('banking_note', SohaPay::listBanking($banking_code, true)); $display->add('time_exten', $time_exten); $content_email = $display->output('payment_online_reg_4', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[AzNetGroup] Gia hạn thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho ban payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $price, "payment_status" => 0, "send_mail_stt" => $send_mail_stt, "reg_exten_stt" => 1); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}&exten=1"; echo $url; exit; } } } } } }
function payment_bill() { if (!User::is_login()) { echo "not_login"; exit; } if (User::is_block()) { echo "no_perm"; exit; } $bill_id = Url::get("bill_id"); $full_name = Url::get('full_name'); $mobile = Url::get('mobile'); $user = User::$current->data; if ($bill_id) { if (!$full_name || !$mobile) { echo "error_info"; exit; } $arr = explode(",", $bill_id); $id_arr = array(); foreach ($arr as $payid) { $id_arr[$payid] = $payid; } $p_premium = array(); ################################################################################# #Lấy ra bản các bản ghi và kiểm tra $re = DB::query("SELECT * FROM payment_premium WHERE id IN({$bill_id})"); $price = 0; if ($re) { while ($row = mysql_fetch_assoc($re)) { if ($row['user_id'] == User::id() && $row['status'] == 0) { if (isset($id_arr[$row['id']])) { unset($id_arr[$row['id']]); } $price += $row['price']; $p_premium[$row['id']] = $row; } } } if ($id_arr || $price == 0) { echo 'error_service'; exit; } //$order_code = "{$service_code}_{$user['user_name']}_".TIME_NOW; $return_url = WEB_ROOT . "personal.html?cmd=bill_payment&bill_id={$bill_id}"; $transaction_info = "Thanh toán hóa đơn trả sau cho các GD trả sau có mã {$bill_id}, trị giá " . number_format($price, 0, '', '.') . " VNĐ) cho {$full_name} ({$user['user_name']}), số ĐT liên hệ: {$mobile}"; $payment_ebp = array("item_id" => 0, "log_id" => $bill_id, "user_id" => User::id(), "user_name" => User::user_name(), "service_type" => 2, "service_code" => "Bill", "payment_info" => $transaction_info, "order_code" => '', "price" => $price, "time" => TIME_NOW, "payment_time" => 0, "error_text" => '', "payment_status" => 0, "sent_mail" => 0, "mobile" => $this->check_mobile($mobile)); $payid = DB::insert("payment_ebp", $payment_ebp); if ($payid) { $order_code = "Bill_{$payid}"; if (DB::update("payment_ebp", array("order_code" => $order_code), "id={$payid}")) { //Tạo link thanh toán đến Soha Payment $url = SohaPay::buildCheckoutUrl($return_url, $transaction_info, $order_code, $price, $user['email'], EBP_MERCHANT_SITE_CODE, EBP_SECURE_CODE); echo $url; exit; } } } echo "error_service"; exit; }
function register_service() { if (!User::is_login()) { echo "not_login"; exit; } if (User::is_block()) { echo "no_permission"; exit; } $soha = new SohaPay(); $user = User::$current->data; $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { echo "over_reg_scs"; exit; } $payment_types = (int) Url::get('payment_types'); $type_service = (int) Url::get('type_service'); if ($type_service <= 0 || $type_service > 5) { echo "error_service"; exit; } else { $service = DB::select("services_group", "id={$type_service}"); if (!$service || $service && $service['price'] <= 0) { echo "error"; exit; } } if ($payment_types == 1) { //check submit nhieu lan $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { exit; } //tao mang du lieu cho bang services_group $aryServiceGroup = DB::select('services_group', 'id=' . $type_service); if ($aryServiceGroup) { $orderInfo = array("user_use" => $user['user_name'], "type_scs" => $aryServiceGroup['service_name'], "date_reg" => TIME_NOW, "up_count" => $aryServiceGroup['up_count'], "cpc_count" => $aryServiceGroup['cpc_count'], "item_count" => $aryServiceGroup['item_count'], "take_care" => $aryServiceGroup['take_care'], "price" => $aryServiceGroup['price'], "payment_types" => $payment_types, "active" => -4); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $full_name = Url::get("full_name"); $mobile = Url::get("mobile"); if (!$full_name || !$mobile) { echo "error"; exit; } $order_code = $type_service . "_" . $id; $return_url = WEB_ROOT . "payment_scs.html?cmd=complete&order_id={$id}&payment_types=1&type_service={$type_service}"; $transaction_info = "Thanh toán DV Siêu Chăm Sóc {$service['service_name']} cho {$full_name} [ {$user['user_name']} ], số ĐT liên hệ: {$mobile}"; $order_email = $user['email']; $price = (int) $service['price']; //insert vao payment_scs $pay_info = $full_name . "," . $user['email'] . "," . $mobile . "," . $service['service_name']; $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_type_soha" => 0, "payment_info" => $pay_info, "order_code" => $order_code, "price" => $price, "time" => time(), "error_text" => "Đang chờ thanh toán", "payment_status" => -1); //insert DB::insert('payment_scs', $paymentInfo); //end //Tạo link thanh toán đến Soha Payment /*$url= SohaPay::buildCheckoutUrl($return_url, $transaction_info, $order_code, $price, $order_email,SCS_MERCHANT_SITE_CODE,SCS_SECURE_CODE);*/ /*note_soha #4*/ $url = $soha->buildCheckoutUrl($return_url, $transaction_info, $order_code, $price, $order_email, $mobile); echo $url; exit; } else { echo "error_connect"; exit; } } else { if ($payment_types == 2) { global $display; //check submit nhieu lan $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { exit; } //tao mang du lieu cho bang services_group $aryServiceGroup = DB::select('services_group', 'id=' . $type_service); if ($aryServiceGroup) { $orderInfo = array("user_use" => $user['user_name'], "type_scs" => $aryServiceGroup['service_name'], "date_reg" => TIME_NOW, "up_count" => $aryServiceGroup['up_count'], "cpc_count" => $aryServiceGroup['cpc_count'], "item_count" => $aryServiceGroup['item_count'], "take_care" => $aryServiceGroup['take_care'], "price" => $aryServiceGroup['price'], "payment_types" => $payment_types, "active" => 0); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $payment_info = ""; $full_name = EClassApi::getParam('ho_ten'); $dienthoai = EClassApi::getParam('dien_thoai'); $dia_chi = EClassApi::getParam('dia_chi'); $thanh_pho = EClassApi::getParam('thanh_pho'); $ngay = EClassApi::getParam('ngay'); $time = EClassApi::getParam('time'); $payment_info .= $full_name . "," . $dienthoai . "," . $dia_chi . "," . $thanh_pho . "," . $ngay . "," . $time; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('full_name', $full_name); $display->add('dia_chi', $dia_chi); $display->add('thanh_pho', SohaPay::infoForUser($thanh_pho, 'tp')); $display->add('ngay', $ngay); $display->add('time', SohaPay::infoForUser($time, 'time')); $display->add('service_name', $aryServiceGroup['service_name']); $display->add('price', number_format($aryServiceGroup['price'])); $content_email = $display->output('payment_online_reg_2', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[ChọnMón.vn] Đăng ký thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho ban payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $aryServiceGroup['price'], "payment_status" => 0, "send_mail_stt" => $send_mail_stt); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}"; echo $url; exit; } } else { if ($payment_types == 3) { global $display; //check submit nhieu lan $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { exit; } //tao mang du lieu cho bang services_group $aryServiceGroup = DB::select('services_group', 'id=' . $type_service); if ($aryServiceGroup) { $orderInfo = array("user_use" => $user['user_name'], "type_scs" => $aryServiceGroup['service_name'], "date_reg" => TIME_NOW, "up_count" => $aryServiceGroup['up_count'], "cpc_count" => $aryServiceGroup['cpc_count'], "item_count" => $aryServiceGroup['item_count'], "take_care" => $aryServiceGroup['take_care'], "price" => $aryServiceGroup['price'], "payment_types" => $payment_types, "active" => 0); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $payment_info = ""; if ($user['mobile_phone'] == "") { $phone = $user['home_phone']; } else { $phone = $user['mobile_phone']; } $payment_info .= $user['email'] . "," . $phone; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('service_name', $aryServiceGroup['service_name']); $display->add('price', number_format($aryServiceGroup['price'])); $content_email = $display->output('payment_online_reg_3', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[ChọnMón.vn] Đăng ký thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho ban payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $aryServiceGroup['price'], "payment_status" => 0, "send_mail_stt" => $send_mail_stt); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}"; echo $url; exit; } } else { if ($payment_types == 4) { global $display; //check submit nhieu lan $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { exit; } //tao mang du lieu cho bang services_group $aryServiceGroup = DB::select('services_group', 'id=' . $type_service); if ($aryServiceGroup) { $orderInfo = array("user_use" => $user['user_name'], "type_scs" => $aryServiceGroup['service_name'], "date_reg" => TIME_NOW, "up_count" => $aryServiceGroup['up_count'], "cpc_count" => $aryServiceGroup['cpc_count'], "item_count" => $aryServiceGroup['item_count'], "take_care" => $aryServiceGroup['take_care'], "price" => $aryServiceGroup['price'], "payment_types" => $payment_types, "active" => 0); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $banking_type = Url::get('banking_type'); $banking_code = SohaPay::listBankCode($banking_type); $payment_info = ""; if ($user['mobile_phone'] == "") { $phone = $user['home_phone']; } else { $phone = $user['mobile_phone']; } $payment_info .= $user['email'] . "," . $phone . "," . $banking_code; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('service_name', $aryServiceGroup['service_name']); $display->add('price', number_format($aryServiceGroup['price'])); $display->add('banking_type', $banking_type); $display->add('accNumber', SohaPay::listAccountNumber($banking_code)); $display->add('banking_name', SohaPay::listBanking($banking_code)); $display->add('banking_note', SohaPay::listBanking($banking_code, true)); $content_email = $display->output('payment_online_reg_4', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[ChọnMón.vn] Đăng ký thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho ban payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $aryServiceGroup['price'], "payment_status" => 0, "send_mail_stt" => $send_mail_stt); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}"; echo $url; exit; } } else { if ($payment_types == 5) { //hinh thuc mua tra sau global $display; //check submit nhieu lan $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { exit; } //tao mang du lieu cho bang services_group $aryServiceGroup = DB::select('services_group', 'id=' . $type_service); if ($aryServiceGroup) { //check xem user co the tiep tuc mua hay khong $user_onDB = DB::select('account', "id={$user['id']}"); if ($user_onDB['money_quota'] * 1000 < $user_onDB['money_used'] * 1000 + $aryServiceGroup['price']) { echo "over_money"; exit; } //luu lai so tien da su dung $last_money_used = $user_onDB['money_used'] + $aryServiceGroup['price'] / 1000; DB::update('account', array('money_used' => $last_money_used), "user_name='{$user_name}'"); if (MEMCACHE_ON) { $user['money_used'] = $last_money_used; eb_memcache::do_put("user:{$user['id']}", $user); } $orderInfo = array("user_use" => $user['user_name'], "type_scs" => $aryServiceGroup['service_name'], "date_reg" => TIME_NOW, "up_count" => $aryServiceGroup['up_count'], "cpc_count" => $aryServiceGroup['cpc_count'], "item_count" => $aryServiceGroup['item_count'], "take_care" => $aryServiceGroup['take_care'], "price" => $aryServiceGroup['price'], "payment_types" => $payment_types, "active" => 0); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $payment_info = ""; if ($user['mobile_phone'] == "") { $phone = $user['home_phone']; } else { $phone = $user['mobile_phone']; } $payment_info .= $user['email'] . "," . $phone . "," . $user['address']; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('service_name', $aryServiceGroup['service_name']); $display->add('price', number_format($aryServiceGroup['price'])); $content_email = $display->output('payment_online_reg_5', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[ChọnMón.vn] Đăng ký thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //insert vao bang payment_premium $premium_scs = array("log_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "type" => 3, "pay_info" => "Mua SCS gói [{$aryServiceGroup['service_name']}]", "price" => $aryServiceGroup['price'], "time" => TIME_NOW, "status" => 0); //insert DB::insert('payment_premium', $premium_scs); //tao mang du lieu cho ban payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $aryServiceGroup['price'], "payment_status" => 0, "send_mail_stt" => $send_mail_stt); //insert DB::insert('payment_scs', $paymentInfo); $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}"; echo $url; exit; } } else { if ($payment_types == 8) { global $display; //check submit nhieu lan $user_name = $user['user_name']; $whereOrderCheck = "user_use='" . $user_name . "' AND (active = 1 OR active = 0)"; $countItemOrder = DB::count('order_services', $whereOrderCheck); if ($countItemOrder > 0 && !User::is_root()) { exit; } //lay thong tin goi dich vu $aryServiceGroup = DB::select('services_group', 'id=' . $type_service); //check gold $user = DB::select("account", "id=" . User::id()); $gold_used = $aryServiceGroup['price']; if ($gold_used > $user['gold']) { echo 'over_price'; exit; } //tao mang du lieu cho bang services_group if ($aryServiceGroup) { $orderInfo = array("user_use" => $user['user_name'], "type_scs" => $aryServiceGroup['service_name'], "date_reg" => TIME_NOW, "up_count" => $aryServiceGroup['up_count'], "cpc_count" => $aryServiceGroup['cpc_count'], "item_count" => $aryServiceGroup['item_count'], "take_care" => $aryServiceGroup['take_care'], "price" => $aryServiceGroup['price'], "payment_types" => $payment_types, "payment_status" => 1, "active" => 0); //insert $id = DB::insert('order_services', $orderInfo); } if ($id) { $payment_info = ""; if ($user['mobile_phone'] == "") { $phone = $user['home_phone']; } else { $phone = $user['mobile_phone']; } $payment_info .= $user['email'] . "," . $phone; //Send email here; $display->add('eb_url', WEB_ROOT); $display->add('user_id', $user['id']); $display->add('user_name', $user['user_name']); $display->add('service_name', $aryServiceGroup['service_name']); $display->add('up_count', $aryServiceGroup['up_count']); $display->add('cpc_count', $aryServiceGroup['cpc_count']); $display->add('item_count', $aryServiceGroup['item_count']); $display->add('take_care', $aryServiceGroup['take_care']); $display->add('price', number_format($aryServiceGroup['price'])); $content_email = $display->output('payment_online_success', 1, 'PaymentScs'); $send_mail_stt = "-1"; if (System::sendEBEmail($user['email'], '[ChọnMón.vn] Đăng ký thành công dịch vụ Siêu Chăm Sóc!', $content_email)) { $send_mail_stt = "1"; } //tao mang du lieu cho bang payment scs $paymentInfo = array("order_service_id" => $id, "user_id" => $user['id'], "user_name" => $user['user_name'], "payment_types" => $payment_types, "payment_info" => $payment_info, "price" => $aryServiceGroup['price'], "payment_status" => 1, "send_mail_stt" => $send_mail_stt); //insert DB::insert('payment_scs', $paymentInfo); //Trừ gold trong tài khoản và ghi vào bảo gold_log $order_info = "Sử dụng " . number_format($gold_used, 0, ',', '.') . " GOLD mua dịch vụ SCS: {$aryServiceGroup['service_name']}"; if (DB::query("UPDATE account SET gold = gold - {$gold_used} WHERE id={$user['id']}")) { User::getUser($user['id'], 0, 1); $gold_log = array('log_id' => $id, 'user_id_buy' => User::id(), 'user_name_buy' => User::user_name(), 'user_id' => User::id(), 'user_name' => User::user_name(), 'admin_id' => 0, 'admin_name' => '', 'time' => TIME_NOW, 'gold' => 0 - $gold_used, 'gold_before' => $user['gold'], 'gold_after' => $user['gold'] - $gold_used, 'price' => 1000 * ceil($gold_used / 1000), 'type' => 0, 'type_use' => 4, 'type_gold' => 3, 'note' => "{$order_info}"); //insert $log_id = DB::insert("gold_log", $gold_log); $data['log_id'] = $log_id; } $url = WEB_ROOT . "payment_scs.html?cmd=payment_finish&id={$id}"; echo $url; exit; } } } } } } } //end gold }