function create_transaction($conn, $commodity_ary)
{
include_once 'class/DBadder.php';
include_once 'class/Config_transaction.php';
include_once 'class/Config_commodity.php';
include_once 'class/commodity/Transaction_state_config.php';
include_once 'class/commodity/Commodity_type_Config.php';
$buyer = -1;
$holder = -1;
$commodity_acceptor_id = $_SESSION['CURRENT_LOGIN_ID'];
if ($commodity_ary[Config_commodity::course_or_reward] == Commodity_type_Config::course) {
$holder = $commodity_ary[Config_commodity::publisher];
$buyer = $commodity_acceptor_id;
} else {
$buyer = $commodity_ary[Config_commodity::publisher];
$holder = $commodity_acceptor_id;
}
$transaction_ary = array(Config_transaction::choosed_id => $commodity_ary[Config_commodity::id], Config_transaction::state => Transaction_state_config::one_want_accept, Config_transaction::commodity_buyer_id => $buyer, Config_transaction::commodity_holder_id => $holder, Config_transaction::price => $commodity_ary[Config_commodity::price], Config_transaction::date_choose => date('Y-m-d H:i:s', time()), Config_transaction::date_confirm => date('Y-m-d H:i:s', 0), Config_transaction::pay_id => substr(md5(time()), 0, 8), Config_transaction::course_or_reward => $commodity_ary[Config_commodity::course_or_reward]);
$adder = new DBadder(Config_transaction::table_name, $transaction_ary);
$adder->excute($conn);
require_once 'class/Config_budget.php';
$budget_ary = array(Config_budget::pay_date => date('Y-m-d H:i:s', time()), Config_budget::transaction_id => mysqli_insert_id($conn));
$adder = new DBadder(Config_budget::table_name, $budget_ary);
$adder->excute($conn);
}
/**
*
*/
function register()
{
include_once 'class/DBadder.php';
$myDBadder = new DBadder(Config_user::table_name, $this->ary);
if ($myDBadder->excute_without_conn()) {
return false;
} else {
return true;
}
}
/**
* 前置： 必须满足已经判断确定用户已经登陆
* @param unknown $conn 数据库连接
*/
function add_message_to_DB($conn, $commodity_id)
{
require_once 'class/DBadder.php';
require_once 'class/Config_leave_message.php';
require_once 'class/Config.php';
require_once 'class/Injection.php';
$talker_id = $_SESSION['CURRENT_LOGIN_ID'];
$talker_content = Injection::excute('content');
$array = array(Config_leave_message::commodity_id => $commodity_id, Config_leave_message::content => $talker_content, Config_leave_message::talker => $talker_id, Config_leave_message::time => date('Y-m-d H:i:s', time()));
$DBadder = new DBadder(Config_leave_message::tbl_name, $array);
return $DBadder->excute($conn);
}
/**
* 不区分商品类别， 悬赏还是课程
*/
public function excute()
{
$path = dirname(dirname(__FILE__));
include_once $path . '/DBadder.php';
include_once $path . '/Config_commodity.php';
$myDBadder = new DBadder(Config_commodity::table_name, $this->ary);
if ($myDBadder->excuteWithoutConn()) {
return true;
} else {
return false;
}
}
/**
*
*/
public function register()
{
$path = dirname(dirname(__FILE__));
include_once $path . '/DBadder.php';
include_once $path . '/Config_user.php';
include_once 'ResultReturn.php';
$myDBadder = new DBadder(Config_user::table_name, $this->ary);
if ($myDBadder->excute_without_conn()) {
return ResultReturn::register_pass;
} else {
return ResultReturn::register_failed;
}
}
private function add_transaction_in_DB()
{
$path = dirname(dirname(__FILE__));
include_once $path . '/DBadder.php';
include_once $path . '/Config_transaction.php';
include_once $path . '/Config_commodity.php';
include_once 'Transaction_state_config.php';
include_once 'Commodity_type_Config.php';
$buyer = -1;
$holder = -1;
if ($this->commodity_ary[Config_commodity::type] == Commodity_type_Config::course) {
$holder = $this->commodity_ary[Config_commodity::publisher];
$buyer = $this->commodity_acceptor_id;
} else {
$buyer = $this->commodity_ary[Config_commodity::publisher];
$holder = $this->commodity_acceptor_id;
}
$myary = array(Config_transaction::choosed_id => $this->commodity_ary[Config_commodity::id], Config_transaction::state => Transaction_state_config::acceptor_comfirmed, Config_transaction::commodity_buyer_id => $buyer, Config_transaction::commodity_holder_id => $holder, Config_transaction::price => $this->commodity_ary[Config_commodity::price], Config_transaction::date_choose => date('Y-m-d H:i:s', time()), Config_transaction::date_confirm => date('Y-m-d H:i:s', 0), Config_transaction::pay_id => $this->generate_pay_id());
$adder = new DBadder(Config_transaction::table_name, $myary);
$adder->excute_without_conn();
}
function create_transaction($conn, $commodity_ary)
{
include_once 'class/DBadder.php';
include_once 'class/Config_transaction.php';
include_once 'class/Config_commodity.php';
include_once 'class/commodity/Transaction_state_config.php';
include_once 'class/commodity/Commodity_type_Config.php';
$buyer = -1;
$holder = -1;
$commodity_acceptor_id = Injection::excute('commodity_acceptor_id');
if ($commodity_ary[Config_commodity::course_or_reward] == Commodity_type_Config::course) {
$holder = $commodity_ary[Config_commodity::publisher];
$buyer = $commodity_acceptor_id;
} else {
$buyer = $commodity_ary[Config_commodity::publisher];
$holder = $commodity_acceptor_id;
}
$myary = array(Config_transaction::choosed_id => $commodity_ary[Config_commodity::id], Config_transaction::state => Transaction_state_config::acceptor_comfirmed, Config_transaction::commodity_buyer_id => $buyer, Config_transaction::commodity_holder_id => $holder, Config_transaction::price => $this->commodity_ary[Config_commodity::price], Config_transaction::date_choose => date('Y-m-d H:i:s', time()), Config_transaction::date_confirm => date('Y-m-d H:i:s', 0), Config_transaction::pay_id => substr(md5(time()), 0, 8), Config_transaction::course_or_reward => $commodity_ary[Config_commodity::course_or_reward]);
$adder = new DBadder(Config_transaction::table_name, $myary);
return $adder->excute($conn);
}
function evaluate()
{
require_once 'class/Injection.php';
require_once 'class/Config_evaluation.php';
require_once 'class/DBtraverser.php';
require_once 'class/Config.php';
require_once 'class/Config_transaction.php';
include 'smarty_init.php';
$content = '';
// $content = Injection::excute('content'); //评价内容
$transaction_id = (int) $_REQUEST['transaction_id'];
//评价交易单
$evaluater_id = $_SESSION['CURRENT_LOGIN_ID'];
//评价人ID
$score1 = $_REQUEST['score1'];
$score2 = $_REQUEST['score2'];
$score3 = $_REQUEST['score3'];
$score = 10;
$conn = Config::connect();
//判断订单是否已经存在
$trasaction_DBtraveser = new DBtraverser(Config_transaction::table_name, ' where ' . Config_transaction::id . ' = ' . "'" . $transaction_id . "'");
$transaction_retval = $trasaction_DBtraveser->excute($conn);
$transaction_array = mysqli_fetch_array($transaction_retval, MYSQLI_ASSOC);
if ($transaction_array) {
$is_payer = $transaction_array[Config_transaction::commodity_buyer_id] == $evaluater_id ? 1 : 0;
require_once 'class/Config_transaction.php';
$evaluation_DBtraveser = new DBtraverser(Config_evaluation::tbl_name, ' where ' . Config_evaluation::commodity_id . ' = ' . "'" . $transaction_array[Config_transaction::choosed_id] . "'" . 'AND' . Config_evaluation::is_payer . ' = ' . "'" . $is_payer . "'");
if (!mysqli_fetch_array($evaluation_DBtraveser->excute($conn))) {
$evaluated = $transaction_array[Config_transaction::commodity_buyer_id] == $evaluater_id ? $transaction_array[Config_transaction::commodity_holder_id] : $transaction_array[Config_transaction::commodity_buyer_id];
$ary = array(Config_evaluation::evaluate_time => date('Y-m-d H:i:s', time()), Config_evaluation::evaluation => $content, Config_evaluation::is_payer => $is_payer, Config_evaluation::score1 => $score1, Config_evaluation::score2 => $score2, Config_evaluation::score3 => $score3, Config_evaluation::score => $score, Config_evaluation::commodity_id => $transaction_array[Config_transaction::choosed_id], Config_evaluation::valuator => $evaluater_id, Config_evaluation::valuated => $evaluated);
$DBadder = new DBadder(Config_evaluation::tbl_name, $ary);
$DBadder->excute($conn);
echo "<script language='javascript'> alert('done!');\r\n window.history.go(-1);\r\n </script>";
} else {
}
} else {
}
mysqli_free_result($transaction_retval);
mysqli_close($conn);
}
session_start();
//$_SESSION['CURRENT_LOGIN_ID'] =1;
if (isset($_SESSION['CURRENT_LOGIN_ID'])) {
require_once 'class/Config.php';
$commodity_id = (int) $_GET['id'];
$conn = Config::connect();
//判断是否已赞
require_once 'Inlcude_is_praised.php';
if (!is_praised($conn, $commodity_id, $_SESSION['CURRENT_LOGIN_ID'])) {
require_once 'class/DBincrement.php';
require_once 'class/Config_commodity.php';
require_once 'class/DBadder.php';
require_once 'class/Config_praise.php';
//在数据库里面加
$ary = array(Config_praise::commodity_id => $commodity_id, Config_praise::praiser_id => $_SESSION['CURRENT_LOGIN_ID']);
$DBadder = new DBadder(Config_praise::tbl_name, $ary);
$DBadder->excute($conn);
//更新商品被赞数
$DBincrement = new DBincrement(Config_commodity::table_name, Config_commodity::praise, ' where ' . Config_commodity::id . ' = ' . "'" . $commodity_id . "'");
$DBincrement->excute($conn);
header("Location:Commodity_details.php?id={$commodity_id}");
} else {
echo "<script language='javascript'> alert('praised!');\r\n window.history.go(-1);\r\n </script>";
}
} else {
include 'Login.php';
}
/* function add_praise($conn,$commodity_id)
{
$ary = array(
Config_praise::commodity_id => $commodity_id,
* @param string $username
*/
function is_username_exist($username)
{
include_once 'class/DBtraverser.php';
include_once 'class/Config.php';
include_once 'class/Config_user.php';
include_once 'class/DBcount.php';
$ary = ' where ' . Config_user::log_name . " = '{$username}' ";
$myDBcount = new DBcount(Config_user::table_name, $ary);
$retval = $myDBcount->excute_without_conn();
$row = mysqli_fetch_array($retval, MYSQLI_NUM);
return $row ? $row[0] : 0;
}
if (isset($_POST['reg'])) {
require_once 'class/Injection.php';
$name = Injection::excute('username');
$pwd = Injection::excute('pwd');
$phone = Injection::excute('phone');
$register_user = array(Config_user::is_seller => 1, Config_user::create_time => date('Y-m-d H:i:s', time()), Config_user::last_log => date('Y-m-d H:i:s', time()), Config_user::phone_number => $phone, Config_user::seller_credit => 5, Config_user::payer_credit => 5, Config_user::log_name => $name, Config_user::password => $pwd, Config_user::pic_path => 'avatar.jpg');
if (is_username_exist($name)) {
} else {
include_once 'class/DBadder.php';
$myDBadder = new DBadder(Config_user::table_name, $register_user);
if ($myDBadder->excute_without_conn()) {
$smarty->display("Login&Register/Login.html");
}
}
} else {
$smarty->display("Login&Register/Register.html");
}
