01.
<?php
02.
$code
=
"-"
;
03.
$Short_name
=
""
;
04.
$yearMonth
=
substr
(
date
(
"Y"
)+543, -0).
'-'
.
date
(
"m"
);
05.
date_default_timezone_set(
'Asia/Bangkok'
);
06.
07.
$sql
=
"SELECT MAX(Job_ID) AS last_id FROM job_it"
;
08.
$qry
= mysql_query(
$sql
)
or
die
(mysql_error());
09.
$rs
= mysql_fetch_assoc(
$qry
);
10.
$maxId
=
substr
(
$rs
[
'last_id'
], -3);
11.
#
$maxId
= 00000;
12.
$maxId
= (
$maxId
+ 1);
13.
$Short_name
=
$_SESSION
[
'Short_name'
];
14.
$maxId
=
substr
(
"000"
.
$maxId
, -3);
15.
$nextId
=
$Short_name
.
$code
.
$yearMonth
.
"-"
.
$maxId
;
16.
17.
?>