function _set_data_($var_name, $var_value)
{
$var_query_link = _set_query_("SELECT * FROM " . def_table_setting . " WHERE name='" . $var_name . "'");
if (_get_num_rows_($var_query_link) > 0) {
_set_query_("UPDATE setting SET value='" . $var_value . "' WHERE name='" . $var_name . "'");
} else {
_set_query_("INSERT INTO setting VALUES ('', '" . $var_name . "', '" . $var_value . "')");
}
}
function _is_primary_exist_($var_jenisid)
{
if (!_is_not_null_($var_jenisid)) {
return false;
}
$var_query_link = _set_query_("SELECT jenisid FROM " . def_table_jenis . " WHERE jenisid='" . _set_input_string_($var_jenisid) . "'");
if (_get_num_rows_($var_query_link) > 0) {
return true;
} else {
return false;
}
}
function _is_primary_exist_($var_pesanno)
{
if (!_is_not_null_($var_pesanno)) {
return false;
}
$var_query_link = _set_query_("SELECT pesanno FROM " . def_table_inbox . " WHERE pesanno=" . _set_input_string_($var_pesanno));
if (_get_num_rows_($var_query_link) > 0) {
return true;
} else {
return false;
}
}
function _is_primary_exist2_($var_kode)
{
if (!_is_not_null_($var_kode)) {
return false;
}
$var_query_link = _set_query_("SELECT kode FROM " . def_table_daftarharga . " WHERE kode='" . _set_input_string_($var_kode) . "'");
if (_get_num_rows_($var_query_link) > 0) {
return true;
} else {
return false;
}
}
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 _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;
}
}
function _check_sms_format_($var_array_value, &$var_alamat)
{
if (count($var_array_value) == 2) {
$var_query_link = _set_query_("SELECT menuid FROM " . def_table_menu . " WHERE kodemenu='" . _set_input_string_($var_array_value[0]) . "'");
if (_get_num_rows_($var_query_link)) {
if (is_numeric($var_array_value[1])) {
return true;
} else {
return false;
}
} else {
return false;
}
} elseif (count($var_array_value) == 3) {
$var_query_link = _set_query_("SELECT menuid FROM " . def_table_menu . " WHERE kodemenu='" . _set_input_string_($var_array_value[0]) . "'");
if (_get_num_rows_($var_query_link)) {
if (is_numeric($var_array_value[1])) {
for ($var_counter = 0; $var_counter < count($this->var_array_alamat); $var_counter++) {
if (trim(strtoupper($var_array_value[2])) == $this->var_array_alamat[$var_counter]) {
$var_alamat = $this->var_array_alamat2[$var_counter];
return true;
}
}
} else {
return false;
}
} else {
return false;
}
} else {
return false;
}
}
function _set_increment_id_()
{
$var_query_link = _set_query_("SELECT restoranid FROM " . def_table_restoran);
if (_get_num_rows_($var_query_link) > 0) {
$var_hole = 0;
for ($var_counter = 1; $var_counter <= _get_num_rows_($var_query_link); $var_counter++) {
$var_check_link = _set_query_("SELECT restoranid FROM " . def_table_restoran . " WHERE restoranid='" . _set_input_string_(_set_padding_($var_counter, 3, "0", false)) . "'");
if (_get_num_rows_($var_check_link) <= 0) {
$var_hole = $var_counter;
break;
}
}
if ($var_hole == 0) {
$var_hole = _get_num_rows_($var_query_link) + 1;
}
return _set_padding_($var_hole, 3, "0", false);
} else {
return _set_padding_("1", 3, "0", false);
}
}
function _set_increment_output_id_($var_userid)
{
$var_query_link = _set_query_("SELECT outputid FROM " . def_table_output);
date_default_timezone_set('Asia/Krasnoyarsk');
if (_get_num_rows_($var_query_link) > 0) {
$var_hole = 0;
for ($var_counter = 1; $var_counter <= _get_num_rows_($var_query_link); $var_counter++) {
$var_check_link = _set_query_("SELECT outputid FROM " . def_table_output . " WHERE outputid='" . _set_input_string_(_set_padding_($var_userid, 15)) . _set_input_string_(date("dmY") . _set_padding_($var_counter, 2, "0", false)) . "'");
if (_get_num_rows_($var_check_link) <= 0) {
$var_hole = $var_counter;
break;
}
}
if ($var_hole == 0) {
$var_hole = _get_num_rows_($var_query_link) + 1;
}
return _set_input_string_(_set_padding_($var_userid, 15)) . date("dmY") . _set_padding_($var_hole, 2, "0", false);
} else {
return _set_input_string_(_set_padding_($var_userid, 15)) . date("dmY") . _set_padding_("1", 2, "0", false);
}
}
function _set_data2_($var_handphone)
{
$var_query_link = _set_query_("SELECT * FROM " . def_table_pemakai . " WHERE handphone='" . _set_input_string_($var_handphone) . "'");
if (_get_num_rows_($var_query_link) > 0) {
$var_array_pemakai = _set_fetch_array_($var_query_link);
$this->var_userid = $var_array_pemakai['userid'];
$this->var_username = $var_array_pemakai['username'];
$this->var_statusyn = $var_array_pemakai['statusyn'];
$this->var_activeyn = $var_array_pemakai['activeyn'];
$this->var_email = $var_array_pemakai['email'];
$this->var_address = $var_array_pemakai['address'];
$this->var_handphone = $var_array_pemakai['handphone'];
$this->var_phone = $var_array_pemakai['phone'];
$this->var_handphoneyn = $var_array_pemakai['handphoneyn'];
} else {
$this->var_userid = "";
$this->var_username = "";
$this->var_statusyn = def_no;
$this->var_activeyn = def_no;
$this->var_email = "";
$this->var_address = "";
$this->var_handphone = "";
$this->var_phone = "";
$this->var_handphoneyn = def_no;
}
}
function _set_num_rows_($var_table)
{
$var_query_link = _set_query_("SELECT * FROM " . $var_table);
return _get_num_rows_($var_query_link);
}
