function UsrSav()
{
//$md = $_REQUEST['md']+0;
if ($_REQUEST['LevelID'] == 'Dosen') {
$lvlid = '2';
}
if ($_REQUEST['LevelID'] == 'Mahasiswa') {
$lvlid = '4';
}
$_REQUEST['lid'] = $lvlid;
$TabelUser = GetFields('level', 'LevelID', $_REQUEST['lid'], 'Nama, TabelAntrianID');
$Login = $_REQUEST['Login'];
$Nama = sqling($_REQUEST['Nama']);
$Password = $_REQUEST['Password'];
$b = array();
$b['Telephone'] = '0123456789012';
$b['Handphone'] = '0123456789012';
$b['Email'] = '*****@*****.**';
$b['Alamat'] = 'Jl. Contoh Alamat No.1';
$b['Kota'] = 'Bandung';
$b['Propinsi'] = 'Jawa Barat';
$b['Negara'] = 'Indonesia';
$b['ProdiID'] = 'PTE';
$b['NA'] = 'N';
if ($_REQUEST['lid'] == '2') {
$ada = GetFields($TabelUser['TabelAntrianID'], 'Login', $Login, 'Login, Nama');
if (empty($ada)) {
$s = "insert into {$TabelUser['TabelAntrianID']} (Login, KodeID, LevelID, Nama, Password, Telephone, Handphone, Email, \n Alamat, Kota, Propinsi, Negara, ProdiID, NA)\n values('{$Login}', '{$_SESSION['KodeID']}', '{$_REQUEST['lid']}', '{$Nama}', PASSWORD('{$Password}'), '{$b['Telephone']}', '{$b['Handphone']}', '{$b['Email']}',\n '{$b['Alamat']}', '{$b['Kota']}', '{$b['Propinsi']}', '{$b['Negara']}', '{$b['ProdiID']}', '{$b['NA']}')";
_query($s);
selesai();
} else {
echo ErrorMsg('Gagal Simpan', "Kode Login: <b>{$Login}</b> telah dipakai oleh user: <b>{$ada['Nama']}</b>.<br>\n Gunakan Kode Login yang lain.") . '<br>';
}
}
if ($_REQUEST['lid'] == '4') {
$ada = GetFields($TabelUser['TabelAntrianID'], 'Login', $Login, 'Login, Nama');
if (empty($ada)) {
$s = "insert into {$TabelUser['TabelAntrianID']} (MhswID, NIM, Login, KodeID, LevelID, Nama, Password, Telephone, Handphone, Email, \n Alamat, Kota, Propinsi, Negara, ProdiID, NA)\n values('{$Login}', '{$Login}', '{$Login}', '{$_SESSION['KodeID']}', '{$_REQUEST['lid']}', '{$Nama}', PASSWORD('{$Password}'), '{$b['Telephone']}', '{$b['Handphone']}', '{$b['Email']}',\n '{$b['Alamat']}', '{$b['Kota']}', '{$b['Propinsi']}', '{$b['Negara']}', '{$b['ProdiID']}', '{$b['NA']}')";
_query($s);
selesai();
} else {
echo ErrorMsg('Gagal Simpan', "Kode Login: <b>{$Login}</b> telah dipakai oleh user: <b>{$ada['Nama']}</b>.<br>\n Gunakan Kode Login yang lain.") . '<br>';
}
}
}
function UsrSav()
{
if (isset($_POST['Simpan'])) {
//$md = $_REQUEST['md']+0;
$TabelUser = GetFields('level', 'LevelID', $_REQUEST['LevelID'], 'Nama, TabelUser');
$Login = $_POST['Login'];
$Nama = $_POST['Nama'];
$Password = $_POST['Password'];
$Level = $_POST['Level'];
// ---------------------------------------------
//$OldPwd = $_REQUEST['OldPwd'];
$b = array();
$b['Telephone'] = '012345678912';
$b['Handphone'] = '012345678912';
$b['Email'] = '*****@*****.**';
$b['Alamat'] = 'Jl. Contoh Alamat No.1';
$b['Kota'] = 'Bandung';
$b['Propinsi'] = 'Jawa Barat';
$b['Negarai'] = 'Indonesia';
//$arrProdiID = array();
//$arrProdiID = $_POST['ProdiID'];
//$ProdiID = $arrProdiID;
//
$b['ProdiID'] = 'PTE';
$b['NA'] = 'N';
$b['cod'] = "E0451";
if ($Level == 'Dosen') {
$LevelID = '2';
}
if ($Level == 'Mahasiswa') {
$LevelID = '4';
}
$_REQUEST['lvl'] = $LevelID;
$lvl = $_REQUEST['lvl'];
$ada = GetFields($TabelUser['TabelUser'], 'Login', $Login, 'Login, Nama');
if (empty($ada)) {
$s = "insert into {$TabelUser['TabelUser']} (MhswID, NIM, Login, KodeID, LevelID, Nama, Password, Telephone, Handphone, Email, \n Alamat, Kota, Propinsi, Negara, ProdiID, NA)\n values('{$Login}', '{$Login}', '{$Login}', '{$b['cod']}', '{$lvl}', '{$Nama}', PASSWORD('{$Password}'), '{$b['Telephone']}', '{$b['Handphone']}', '{$b['Email']}',\n '{$b['Alamat']}', '{$b['Kota']}', '{$b['Propinsi']}', '{$b['Negarai']}', '{$b['ProdiID']}', '{$b['NA']}')";
_query($s);
} else {
echo ErrorMsg('Gagal Simpan', "Kode Login: <b>{$Login}</b> telah dipakai oleh user: <b>{$ada['Nama']}</b>.<br>\n Gunakan Kode Login yang lain.") . '<br>';
}
selesai();
}
}
mysql_close();
$link = mysqli_connect($server, $username, $password) or die("Koneksi gagal");
mysqli_select_db($link, $database) or die("Database tidak bisa dibuka");
$clientIP = $_SERVER['REMOTE_ADDR'];
if ($_POST['tambah']) {
$barcode = $_POST['barcode'];
tambahBarang($link, $clientIP, $barcode);
} elseif ($_POST['hapus']) {
$barcode = $_POST['barcode'];
hapusBarang($link, $clientIP, $barcode);
} elseif ($_GET['refresh']) {
refreshDetail($link, $clientIP);
} elseif ($_GET['gettotal']) {
getTotal($link, $clientIP);
} elseif ($_POST['selesai']) {
selesai($link, $clientIP);
} elseif ($_POST['cekharga']) {
cekHarga($link, $_POST['barcode']);
}
/**
* Tambah barang self checkout, qty selalu 1, karena tidak ada input qty di user interface :)
* @param mysqli $link myqli link
* @param string $clientIP ip address v4 dari client ybs
* @param string $barcode barcode barang
*/
function tambahBarang($link, $clientIP, $barcode)
{
if ($barcode != '') {
$qty = 1;
/**
* Cek apa barang sudah ada
// else {
// selesai();
// }
if ($major == 2 && $dbmajor == 2) {
// ------- eksekusi semua patch versi 2.x
echo "Checking database version 2.x.x \n <br />";
check_minor_major2($dbminor, $minor, $dbrevision, $revision);
} else {
selesai();
}
if ($major >= 3 && $dbmajor <= $major) {
// ------- eksekusi semua patch versi 3.x
echo "Checking database version 3.x.x \n <br />";
check_minor_major3($dbminor, $minor, $dbrevision, $revision);
} else {
selesai();
}
exit;
}
// =================================== PATCH VERSI 1.x.x ==========================================
function check_minor_major1($dbminor, $minor, $dbrevision, $revision)
{
if ($dbminor == 2) {
// ------- eksekusi semua patch versi 1.2.x
echo "Upgrading database to version 1.2.x \n <br />";
check_revision_minor2_major1($dbminor, $minor, $dbrevision, $revision);
}
if ($dbminor < 5) {
// ------- eksekusi semua patch versi 1.5.x
echo "Upgrading database to version 1.5.x \n <br />";
check_revision_minor5_major1($dbminor, $minor, $dbrevision, $revision);
