1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
|
<?php
$page_settings = array(
'formid' => 'Tutor_search', // for permission
'section' => 'Master', // parent/page title
'subsection' => 'Course Search', // page title
'domain' => 'tutor_search', // table/model name
'access' => 'GNr', // for permission
);
require_once "check_login.php";
$message = "";
//print_r($cms_user_info);
if($_POST["id"]){
$row = get_studentpostjob((int)$_POST["id"]);
$id = $row['id'];
}
if (!$_POST['id']) {
$message .= _lang("Please Select Job.") . "\\n\\n";
}
if (!empty($message)) {
echo "<script>alert('" . $message . "'); history.back();</script>";
exit;
}
$nowdate = date("Y-m-d H:i:s");
if($_POST['id']){ // 有沒有ID
$sql = "select * from tutor_postjob as tb where id = ? and deleted = ? and (NOW() BETWEEN start_date and end_date)";
$parameters = array($_POST['id'],0);
$row = bind_pdo($sql, $parameters, "selectone");
if($row['id']){ //是否有postjob id
$sql = "select profile_id,(select id from `student_main` where cmsloginid = tb.user_id LIMIT 1) as id
from `profile_user` as tb where user_id = ? and deleted = ? LIMIT 1";
$parameters = array($_SESSION['cmsloginid'],0);
$row_profile = bind_pdo($sql, $parameters, "selectone");
$student_id = $row_profile['id'];
$tutor_id = $row['tutormain_id'];
$job_id = $row['id'];
$sql = "select count(*) as count
from `order` where tutormain_id = ? and studentmain_id = ? and job_id = ? and order_type = ? and (status = 'paid' or status = 'process') and deleted = 0";
$parameters = array($tutor_id, $student_id , $job_id, 'course');
$row_order = bind_pdo($sql, $parameters, "selectone");
if($row_order['count'] == 0){
$sql = "SELECT * FROM tutor_postjob_date WHERE postjob_refid = ?";
$parameters99 = array(intval($row['id']));
$rows_postjob_date = bind_pdo($sql, $parameters99, "selectall");
//
$sql = "select max(id)+1 as maxcount from `order`";
$parameters = array();
$row_orderno = bind_pdo($sql, $parameters, "selectone");
$order_data['id'] = $row_orderno['maxcount'];
$order_data['studentmain_id']= $student_id;
$order_data['tutormain_id'] = $tutor_id;
$order_data['job_id'] = $job_id;
$order_data['level'] = $row["level"];
$order_data['order_type'] = 'course';
$order_data['order_no'] = 'OC' . date('ymd') . sprintf("%06d", $row_orderno['maxcount']);
$order_data['extra_fee'] = 0;
$order_data['fee'] = 0;
$order_data['total_fee'] = $row['fee'];
$order_data['status'] = 'process';
$order_data['lastupdate'] = $nowdate;
$order_data['createdate'] = $nowdate;
$order_data['deleted'] = 0;
$sql = mysql_install($order_data,'order','add');
$arraykey=array_keys($order_data);
unset($parameters);
for($i=0;$i<count($arraykey);$i++){
$parameters[$i]=$order_data[$arraykey[$i]];
}
bind_pdo($sql, $parameters);
foreach($rows_postjob_date as $row_postjob_date){
unset($order_data);
$order_data['order_id'] = $row_orderno['maxcount'];
$order_data['datetime'] = $row_postjob_date['date'];
$order_data['tutor_status'] = 0;
$order_data['student_status'] = 0;
$sql = mysql_install($order_data,'order_detail','add');
$arraykey=array_keys($order_data);
unset($parameters);
for($i=0;$i<count($arraykey);$i++){
$parameters[$i]=$order_data[$arraykey[$i]];
}
bind_pdo($sql, $parameters);
}
insert_approval_list('COURSE', 'tutor_postjob', $id);
}
}
}
/*
if($_POST['type']=='fontend'){
header("Location: ../course_detail.php?id=".$id);
}else{
header("Location: order_form.php?id=".$row_orderno['maxcount']);
}*/
header("Location: order_form.php?id=".$row_orderno['maxcount']);
?>
|