include "cgi-bin/myclass.php";
$databaseobject = new MyDataBase();
mysql_query("SET time_zone = '+7:00'");
$id = mysql_real_escape_string($_GET["id"]);
$_SESSION["prefix"]="";
$prefix="";
cekPertamaKali();
receiveSendMail();
if ($_GET["posisi"]!=""){
$_SESSION["noindex"] = mysql_real_escape_string($_GET["posisi"]);
} else {
$_SESSION["noindex"] = "";
}
if ($_POST["simpan"]!="" ){
$nama = mysql_real_escape_string($_POST["editnama"]);
$alamat = mysql_real_escape_string($_POST["editalamat"]);
$telepon = mysql_real_escape_string($_POST["edittelepon"]);
$email = mysql_real_escape_string($_POST["editemail"]);
$keterangan = mysql_real_escape_string($_POST["editketerangan"]);
if (strlen($nama)<=1 || strlen($alamat)<=1 || strlen($telepon)<=1){
$_SESSION["pesankesalahan"]="Field yang penting Kurang Panjang";
} else {
$q=" SELECT ifnull(
concat(SUBSTRING(YEAR(now()),3,2),LPAD(MONTH(NOW()),2,'0'),LPAD( max(right(idorderdisplay,6))+1,6,'0' )) ,
concat(SUBSTRING(YEAR(now()),3,2),LPAD(MONTH(NOW()),2,'0'),'000121') ) f1
FROM md_hpemesanan
WHERE month(tanggal)=month(now()) and year(tanggal)=year(now())
";
$result= $databaseobject->executequery($q);
echo mysql_error();
$mid = substr($nama,0,2).mysql_result($result,0,"f1");
$idh=$_SESSION["idhpemesanan"];
$q="update md_hpemesanan
set sudahdicekout=1,
nama= '$nama',
alamat='$alamat',
telepon = '$telepon',
email= '$email',
keterangan= '$keterangan',
tanggalcekout = now(),
idorderdisplay= '$mid'
where idhpemesanan='$idh' ";
$result= $databaseobject->executequery($q);
echo mysql_error();
$_SESSION["pesankesalahan"]=" Nomor Invoice : '$mid'
BatikOmega akan menghubungi Yth pelanggan $nama atau pelanggan bisa mengontak
lewat Yahoo Messengger ";
$q="insert into md_hpemesanan (tanggal)
values (now())
";
$result= $databaseobject->executequery($q);
if (!$result) {throw new Exception(mysql_error());}
$q=" SELECT LAST_INSERT_ID() f1;";
$result= $databaseobject->executequery($q);
if (!$result) {throw new Exception(mysql_error());}
$_SESSION["idhpemesanan"] = mysql_result($result,0,"f1");
$pesan = " Terima kasih Telah melakukan pembelian dan mendukung batikomega.com, CS dan Segenap BatikOemga akan menghubungi sebelum 1 x 12 Jam ";
}
}
?>
topManagementTalks(2);
?>
|
|