01.
$Generate_Job
=
""
;
02.
$Sql_genSLC
=
"SELECT * FROM order_messenger WHERE Job_Date = '"
.
$dateInput
.
"' AND Job_Time = '"
.
$JobTime
."'
03.
AND Job_Area =
'".$JobArea."'
";
04.
$Qr_genSLC
= mysql_query(
$Sql_genSLC
)
or
die
(mysql_error());
05.
$Qr_rows
= mysql_num_rows(
$Qr_genSLC
);
06.
$fetch_rs
= mysql_fetch_array(
$Qr_genSLC
);
07.
08.
$Row_plus
=
$Qr_rows
+1;
09.
$Genval
=
$fetch_rs
[
"Job_Date"
].
$fetch_rs
[
"Job_Time"
].
$fetch_rs
[
"Job_Area"
];
10.
$Getval
=
$dateInput
.
$JobTime
.
$JobArea
;
11.
$Msn_Date
= Msn_Date(
$dateInput
);
12.
if
(
$Genval
==
$Getval
){
13.
$Order_num
=
substr
(
"0"
.
$Row_plus
,-2,2);
14.
$Generate_Job
=
$Msn_Date
.
$JobTime
.
$JobArea
.
$Order_num
;
15.
}
else
{
16.
$Order_num
=
substr
(
"01"
,-2,2);
17.
$Generate_Job
=
$Msn_Date
.
$JobTime
.
$JobArea
.
$Order_num
;
18.
}
19.
return
$Generate_Job
;
20.
mysql_close(
$dbConn
);
21.
}