function _class_inbox_($var_pesanno = "", $var_nohp = "", $var_tanggal = "") { $var_criteria = ""; if (_is_not_null_($var_pesanno)) { $var_criteria = "pesanno = " . _set_input_string_($var_pesanno); } if (_is_not_null_($var_nohp)) { if (_is_not_null_($var_criteria)) { $var_criteria .= " AND "; } $var_criteria .= "nohp LIKE '%" . _set_input_string_($var_nohp) . "%'"; } if (_is_not_null_($var_tanggal)) { if (_is_not_null_($var_criteria)) { $var_criteria .= " AND "; } $var_criteria .= "tanggal = '" . _set_input_string_($var_tanggal) . "'"; } if (_is_not_null_($var_criteria)) { $var_criteria = " WHERE " . $var_criteria; } $this->var_array_inbox = array(); $var_query_link = _set_query_("SELECT * FROM " . def_table_inbox . $var_criteria . " ORDER BY tanggal DESC"); while ($var_array_inbox = _set_fetch_array_($var_query_link)) { $this->var_array_inbox[$var_array_inbox['pesanno']] = array('nohp' => $var_array_inbox['nohp'], 'pesan' => $var_array_inbox['pesan'], 'tanggal' => $var_array_inbox['tanggal'], 'statusyn' => $var_array_inbox['statusyn']); } }
function _set_field_value($var_table_name, $var_field_name, $var_criteria, $var_global_link = "db_link") { global ${$var_global_link}; $var_query_link = _set_query_("SELECT " . $var_field_name . " FROM " . $var_table_name . " WHERE " . $var_criteria); if (_get_num_rows_($var_query_link) > 0) { $var_array_link = _set_fetch_array_($var_query_link); return $var_array_link[$var_field_name]; } }
function _set_data_($var_kode) { $var_query_link = _set_query_("SELECT * FROM " . def_table_daftarharga . " WHERE kode='" . _set_input_string_($var_kode) . "'"); while ($var_array_daftarharga = _set_fetch_array_($var_query_link)) { $this->var_kode = $var_array_daftarharga['kode']; $this->var_menuid = $var_array_daftarharga['menuid']; $this->var_tanggal = $var_array_daftarharga['tanggal']; $this->var_harga = $var_array_daftarharga['harga']; } }
function _set_data_($var_handphoneno) { $var_query_link = _set_query_("SELECT * FROM " . def_table_handphone . " WHERE handphoneno=" . _set_input_string_($var_handphoneno)); while ($var_array_handphone = _set_fetch_array_($var_query_link)) { $this->var_model = $var_array_handphone['model']; $this->var_port = $var_array_handphone['port']; $this->var_connection = $var_array_handphone['connection']; $this->var_activeyn = $var_array_handphone['activeyn']; } }
function _set_data_($var_contactusid) { $var_query_link = _set_query_("SELECT * FROM " . def_table_contactus . " WHERE contactusid='" . _set_input_string_($var_contactusid) . "'"); while ($var_array_contactus = _set_fetch_array_($var_query_link)) { $this->var_contactusid = $var_array_contactus['contactusid']; $this->var_email = $var_array_contactus['email']; $this->var_nama = $var_array_contactus['nama']; $this->var_tanggal = $var_array_contactus['tanggal']; $this->var_pesan = $var_array_contactus['pesan']; } }
function _session_write_($var_sessionid, $var_value) { global $SESS_LIFE; $var_expiry = time() + $SESS_LIFE; $var_query_link = _set_query_("SELECT count(*) AS total FROM " . def_table_session . " WHERE sessionid='" . _set_input_string_($var_sessionid) . "'"); $var_array_value = _set_fetch_array_($var_query_link); if ($var_array_value["total"] > 0) { return _set_query_("UPDATE " . def_table_session . " set expiry='" . _set_input_string_($var_expiry) . "', value='" . _set_input_string_($var_value) . "' WHERE sessionid='" . _set_input_string_($var_sessionid) . "'"); } else { return _set_query_("INSERT INTO " . def_table_session . " VALUES ('" . _set_input_string_($var_sessionid) . "', '" . _set_input_string_($var_expiry) . "', '" . _set_input_string_($var_value) . "')"); } }
function _is_autoreply_() { $var_query_link = _set_query_("SELECT * FROM " . def_table_setting . " WHERE name='auto reply'"); if (_get_num_rows_($var_query_link) > 0) { $var_objsetting = _set_fetch_array_($var_query_link); if (trim($var_objsetting["value"]) == "1") { return true; } else { return false; } } else { return true; } }
function _get_voucher_($var_userid) { if (!_is_not_null_($var_userid)) { return 0; } $var_query_link = _set_query_("SELECT jumlah FROM " . def_table_voucher . " WHERE userid='" . _set_input_string_($var_userid) . "'"); $var_jumlah = 0; while ($var_array_voucher = _set_fetch_array_($var_query_link)) { $var_jumlah += _set_double_($var_array_voucher['jumlah'], 0); } $var_query_link = _set_query_("SELECT jumlah FROM " . def_table_output . " WHERE userid='" . _set_input_string_($var_userid) . "'"); while ($var_array_output = _set_fetch_array_($var_query_link)) { $var_jumlah -= _set_double_($var_array_output['jumlah'], 0); } return $var_jumlah; }
function _is_status_($var_userid) { if (!_is_not_null_($var_userid)) { return false; } $var_query_link = _set_query_("SELECT statusyn FROM " . def_table_pemakai . " WHERE userid='" . _set_input_string_($var_userid) . "'"); if (_get_num_rows_($var_query_link) > 0) { $var_array_user = _set_fetch_array_($var_query_link); if ($var_array_user["statusyn"] == def_yes) { return true; } else { return false; } } else { return false; } }
function _delete_data_($var_jenisid) { if (!_is_not_null_($var_jenisid)) { return false; } if ($this->_is_primary_exist_($var_jenisid)) { _set_query_("DELETE FROM " . def_table_jenis . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'"); $var_query_link = _set_query_("SELECT menuid FROM " . def_table_menu . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'"); while ($var_array_menu = _set_fetch_array_($var_query_link)) { _set_query_("DELETE FROM " . def_table_pesan_detil . " WHERE menuid='" . _set_input_string_($var_array_menu['menuid']) . "'"); _set_query_("DELETE FROM " . def_table_keranjang . " WHERE menuid='" . _set_input_string_($var_array_menu['menuid']) . "'"); _set_query_("DELETE FROM " . def_table_daftarharga . " WHERE menuid='" . _set_input_string_($var_array_menu['menuid']) . "'"); } _set_query_("DELETE FROM " . def_table_menu . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'"); } else { return false; } }
function _check_it_($var_userid, $var_menuid, $var_qty, &$var_subtotal, &$var_total) { require_once def_directory_classes . "class_keranjang.php"; $var_class_keranjang = new _class_keranjang_(); $var_subtotal = 0; $var_total = 0; $var_query_link = _set_query_("SELECT menuid, qty FROM " . def_table_keranjang . " WHERE userid='" . _set_input_string_($var_userid) . "' AND menuid='" . _set_input_string_($var_menuid) . "'"); while ($var_menu = _set_fetch_array_($var_query_link)) { $var_subtotal += (int) $var_qty * _set_double_($var_class_keranjang->_set_harga_($var_menu['menuid']), 0); } $var_query_link = _set_query_("SELECT menuid, qty FROM " . def_table_keranjang . " WHERE userid='" . _set_input_string_($var_userid) . "'"); while ($var_menu = _set_fetch_array_($var_query_link)) { if ($var_menu['menuid'] == $var_menuid) { $var_total += (int) $var_qty * _set_double_($var_class_keranjang->_set_harga_($var_menu['menuid']), 0); } else { $var_total += (int) $var_menu['qty'] * _set_double_($var_class_keranjang->_set_harga_($var_menu['menuid']), 0); } } }
function _set_harga_($var_menuid) { $var_query_link = _set_query_("SELECT * FROM " . def_table_daftarharga . " WHERE menuid='" . _set_input_string_($var_menuid) . "' ORDER BY tanggal DESC"); if (_get_num_rows_($var_query_link) > 0) { $var_array_daftarharga = _set_fetch_array_($var_query_link); return _set_double_($var_array_daftarharga['harga'], 0); } else { return 0; } }
echo _set_label_("", "Menu"); ?> </td> <td><?php echo _set_label_("", "Restoran"); ?> </td> <td><?php echo _set_label_("", "Qty"); ?> </td> <td> </td> </tr> <?php $var_query_link = _set_query_("SELECT * FROM " . def_table_pesan_detil . " WHERE notransaksi='" . _set_input_string_($var_class_pesan->var_notransaksi) . "'"); while ($var_array_pesan = _set_fetch_array_($var_query_link)) { ?> <tr> <td> <?php echo _set_label_("", $var_array_pesan['menuid'] . ' - ' . _set_field_value(def_table_menu, "nama", "menuid='" . _set_input_string_($var_array_pesan['menuid']) . "'")); ?> </td> <td> <?php echo _set_label_("", _set_field_value(def_table_restoran, "nama", "restoranid='" . _set_input_string_(_set_field_value(def_table_menu, "restoranid", "menuid='" . _set_input_string_($var_array_pesan['menuid']) . "'")) . "'")); ?> </td> <td> <?php echo _set_label_("", $var_array_pesan['qty']);
function _delete_data_($var_userid) { if (!_is_not_null_($var_userid)) { return false; } if ($this->_is_primary_exist_($var_userid)) { _set_query_("DELETE FROM " . def_table_pemakai . " WHERE userid='" . _set_input_string_($var_userid) . "'"); _set_query_("DELETE FROM " . def_table_voucher . " WHERE userid='" . _set_input_string_($var_userid) . "'"); $var_query_link = _set_query_("SELECT notransaksi FROM " . def_table_pesan_header . " WHERE userid='" . _set_input_string_($var_userid) . "'"); while ($var_array_pesan_header = _set_fetch_array_($var_query_link)) { _set_query_("DELETE FROM " . def_table_pesan_detil . " WHERE notransaksi='" . _set_input_string_($var_array_pesan_header['notransaksi']) . "'"); } _set_query_("DELETE FROM " . def_table_pesan_header . " WHERE userid='" . _set_input_string_($var_userid) . "'"); _set_query_("DELETE FROM " . def_table_output . " WHERE userid='" . _set_input_string_($var_userid) . "'"); _set_query_("DELETE FROM " . def_table_login . " WHERE userid='" . _set_input_string_($var_userid) . "'"); _set_query_("DELETE FROM " . def_table_keranjang . " WHERE userid='" . _set_input_string_($var_userid) . "'"); } else { return false; } }