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);