function write_log_discount($discount_value, $receipt_id) { $log_table = "account_log"; $log["waiter"] = $_SESSION['userid']; $log["destination"] = 0; $log["dish"] = DISCOUNT_ID; $log["category"] = 0; $log["quantity"] = 1; $log["price"] = -1 * abs($discount_value); $log["payment"] = $receipt_id; $query = "INSERT INTO `{$log_table}` ("; for (reset($log); list($key, $value) = each($log);) { $value = str_replace("'", "\\'", $value); $query .= "`" . $key . "`,"; } // strips the last comma that has been put $query = substr($query, 0, strlen($query) - 1); $query .= ") VALUES ("; for (reset($log); list($key, $value) = each($log);) { $value = str_replace("'", "\\'", $value); $query .= "'" . $value . "',"; } // strips the last comma that has been put $query = substr($query, 0, strlen($query) - 1); $query .= ")"; // CRYPTO $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } return 0; }
function list_rates() { $ret = array(); $query = "SELECT * FROM `" . $this->table . "`"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } while ($arr = mysql_fetch_array($res)) { $ret[] = $arr['id']; } return $ret; }
function find($obj_id, $dish_id) { $query = "SELECT `id` FROM `" . $this->table . "`\n\t\t\t\tWHERE `obj_id`='" . $obj_id . "'\n\t\t\t\tAND `dish_id`='" . $dish_id . "'"; if ($this->db == 'common') { $res = common_query($query, __FILE__, __LINE__); } else { $res = accounting_query($query, __FILE__, __LINE__); } if (!$res) { return 0; } if ($arr = mysql_fetch_assoc($res)) { return $arr['id']; } return 0; }
function set_print_template_file($destination, $type) { $query = "SELECT * FROM `dests` WHERE `id`='{$destination}'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } if (!($arr = mysql_fetch_array($res))) { $error_msg = 'Printer not found id: ' . $destination; error_msg(__FILE__, __LINE__, $error_msg); echo $error_msg; return ERR_PRINTER_NOT_FOUND; } $this->filename = ROOTDIR . '/templates/' . $arr['template'] . '/prints/' . $type . '.tpl'; return 0; }
function max_quantity() { $query = "SELECT * FROM `autocalc`"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } if (mysql_num_rows($res) == 0) { return -1; } while ($arr = mysql_fetch_array($res)) { $autocalc[$arr['quantity']] = $arr['price']; } // quantity not found, we look for the highest quantiy available, // then add the remaining price (based on the 0 quantity record) $keys = array_keys($autocalc); $maxquantity = max($keys); return $maxquantity; }
function sync_external($obj_type) { if ($obj_type == TYPE_DISH) { $query = "SELECT * FROM dishes WHERE `deleted`='0'"; } elseif ($obj_type == TYPE_INGREDIENT) { $query = "SELECT * FROM ingreds WHERE `deleted`='0'"; } $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } while ($arr = mysql_fetch_array($res)) { $err = $this->create_from_external($arr['id'], $obj_type); if ($err && $err != ERR_OBJECT_ALREADY_EXISTS) { return $err; } } return 0; }
/** * My Handy Restaurant * * http://www.myhandyrestaurant.org * * My Handy Restaurant is a restaurant complete management tool. * Visit {@link http://www.myhandyrestaurant.org} for more info. * Copyright (C) 2003-2005 Fabio De Pascale * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @author Fabio 'Kilyerd' De Pascale <*****@*****.**> * @package MyHandyRestaurant * @copyright Copyright 2003-2005, Fabio De Pascale * @copyright Copyright 2006-2012, Gjergj Sheldija */ function common_allowed_ip($host) { // next is an IP-based access control // reads IPs from the allowed_clients table // and only allows IPs present in that table to go on // if the table is empty, any host is allowed $query = "SELECT * FROM `allowed_clients`"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } // table is empty, everyone is allowed if (mysql_num_rows($res) == 0) { return true; } $host = sprintf("%u", ip2long($host)); $query = "SELECT * FROM `allowed_clients` WHERE `host`='" . $host . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } return mysql_num_rows($res); }
function dishes_list_search($data) { $output = ''; $search = strtolower(trim($data['search'])); if (empty($search)) { return ''; } $query = "SELECT dishes.*\n\tFROM `dishes`\n\tWHERE (LCASE(`name`) LIKE '" . $search . "%'\n\t\tOR LCASE(`name`) LIKE '% " . $search . "%'\n\t\t)"; if (!get_conf(__FILE__, __LINE__, "invisible_show")) { $query .= "AND `visible`='1'"; } $query .= "\n\tAND dishes.deleted='0'\n\tORDER BY name ASC"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ''; } $output .= '<table bgcolor="' . COLOR_TABLE_GENERAL . '"> <tr> <th scope=col>' . ucfirst(phr('ID')) . '</th> <th scope=col>' . ucfirst(phr('NAME')) . '</th> <th scope=col>' . country_conf_currency(true) . '</th> </tr> '; // ascii letter A $i = 65; unset($GLOBALS['key_binds_letters']); while ($arr = mysql_fetch_array($res)) { $class = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], "categories", "htmlcolor", $arr['category']); $dishcat = $arr['category']; $dishid = $arr['id']; $dishobj = new dish($arr['id']); $dishname = $dishobj->name($_SESSION['language']); if ($dishname == null || strlen(trim($dishname)) == 0) { $dishname = $arr['name']; } $dishprice = $arr['price']; if ($dishcat > 0) { // letters array follows if ($i < 91) { $GLOBALS['key_binds_letters'][$i] = $dishid; $local_letter = chr($i); $i++; } else { $local_letter = ''; } $output .= '<tr> <td bgcolor="' . $class . '">' . $local_letter . '</td>'; $output .= '<td bgcolor="' . $class . '" onclick="order_select(' . $dishid . ',\'order_form\'); return false;"><a href="#" onclick="JavaScript:order_select(' . $dishid . ',\'order_form\'); return false;">' . $dishname . '</a></td>'; $output .= '<td bgcolor="' . $class . '">' . $dishprice . '</td> </tr>'; } } $output .= ' </table>'; return $output; }
function receipt_update_amounts($accountdb, $total, $receipt_id) { $total_total = $total['total']; $taxable = $total['taxable']; $vat = $total['tax']; $table = 'account_mgmt_main'; $query = "UPDATE {$table} SET `waiter_income` = '1',`cash_amount` = '{$total_total}',`cash_taxable_amount` = '{$taxable}',`cash_vat_amount` = '{$vat}' WHERE `id` = '{$receipt_id}'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } return 0; }
function letters_list_creator() { $invisible_show = get_conf(__FILE__, __LINE__, "invisible_show"); if ($invisible_show) { $query = "SELECT `name` FROM `dishes`\n\t\t\tWHERE dishes.deleted='0'"; } else { $query = "SELECT `name` FROM `dishes`\n\t\t\tWHERE `visible`='1'\n\t\t\tAND dishes.deleted='0'"; } $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } $dishes_letters = array(); while ($arr = mysql_fetch_array($res)) { $name = trim($arr['name']); if ($name == null || strlen($name) == 0) { $name = trim($arr['name']); } //if no name in the fixed lang, use the main name array_push($dishes_letters, substr($name, 0, 1)); } return $dishes_letters; }
$remaining_time = 1; } $error_msg = common_header('Tavolina ne perdorim'); $error_msg .= navbar_lock_retry_pos(''); $error_msg .= ucfirst(phr('TABLE_ALREADY_IN_USE_ERROR')) . ' ' . '.<br><br>' . "\n"; $error_msg .= ucfirst(phr('IF_YOU_ARE_NOT_DISCONNECT_0')) . ' <b>' . $user->data['name'] . '</b> ' . ucfirst(phr('IF_YOU_ARE_NOT_DISCONNECT_1')) . '<br>' . "\n"; $error_msg .= common_bottom(); die($error_msg); } } /* We get the printed categories flag, and write to $_SESSION['catprinted'][] */ if (isset($_SESSION['sourceid'])) { $query = "SELECT * FROM `sources` WHERE `id`='" . $_SESSION['sourceid'] . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } $arr = mysql_fetch_array($res); $catprinted_total = $arr['catprinted']; $catprinted_total = explode(" ", $catprinted_total); for ($i = 1; $i <= 3; $i++) { if (in_array("{$i}", $catprinted_total)) { $_SESSION['catprinted'][$i] = true; } else { $_SESSION['catprinted'][$i] = false; } } unset($res); unset($arr);
function admin_page($class, $command, $start_data) { global $tpl; if (defined('SECURITY_STOP')) { $command = 'access_denied'; } switch ($command) { case 'access_denied': if (!$this->silent) { $tmp = access_denied_admin(); $tpl->append("messages", $tmp); } break; case 'new': $tpl->set_admin_template_file('standard'); $obj = new $class(); $tmp = $obj->form(); $tpl->assign("content", $tmp); break; case 'insert': $obj = new $class(); if (!$obj->insert($start_data)) { if (method_exists($obj, 'post_insert_page')) { $obj->post_insert_page($class); } else { $obj->admin_list_page($class); } } break; case 'edit': if (!isset($this->templates['edit'])) { $this->templates['edit'] = 'menu'; } $tpl->set_admin_template_file($this->templates['edit']); $obj = new $class($start_data['id']); $tmp = $obj->form(); $tpl->assign("content", $tmp); if (method_exists($obj, 'post_edit_page')) { $obj->post_edit_page($class); } break; case 'update': $obj = new $class($start_data['id']); if ($err = $obj->update($start_data)) { if (!$this->silent) { $tmp = '<span class="error_msg">Error updating: ' . $err . '</span><br>'; $tpl->append("messages", $tmp); } } if (method_exists($obj, 'post_update_page')) { $obj->post_update_page($class); } else { $obj->admin_list_page($class); } break; case 'update_field': $obj = new $class($start_data['id']); if (method_exists($obj, 'update_field')) { if ($err = $obj->update_field($start_data['field'])) { if (!$this->silent) { $tmp = '<span class="error_msg">Error updating: ' . $err . '</span><br>'; $tpl->append("messages", $tmp); } } } $obj->admin_list_page($class); break; case "delete": if (isset($_GET['deleteconfirm'])) { $deleteconfirm = $_GET['deleteconfirm']; } elseif (isset($_POST['deleteconfirm'])) { $deleteconfirm = $_POST['deleteconfirm']; } if ($deleteconfirm) { $tpl->set_admin_template_file('menu'); $delete = $_SESSION["delete"]; unset($_SESSION["delete"]); if (is_array($delete)) { for (reset($delete); list($key, $value) = each($delete);) { $obj = new $class($value); if ($err = $obj->delete($start_data)) { if (!$this->silent) { $tmp = '<span class="error_msg">Error deleting: ' . $err . '</span><br>'; $tpl->append("messages", $tmp); } } unset($rate); } } if (count($delete) == 1) { if (method_exists($obj, 'post_delete_page')) { $obj->post_delete_page($class); } else { $obj->admin_list_page($class); } } else { $obj = new $class(); $obj->admin_list_page($class); } } else { $tpl->set_admin_template_file('standard'); if (isset($_REQUEST['delete'])) { $delete = $_REQUEST['delete']; } if (is_array($delete) || $delete == 'all') { if ($delete == 'all') { $query = "SELECT `id` FROM " . $this->table; if ($this->flag_delete) { $query .= " WHERE `deleted`=0"; } if ($this->db == 'common') { $res = common_query($query, __FILE__, __LINE__); } else { $res = accounting_query($query, __FILE__, __LINE__); } if (!$res) { return ERR_MYSQL; } $delete_all = true; unset($delete); while ($arr = mysql_fetch_array($res)) { $delete[] = $arr['id']; } } $tmp = '<div align=center>'; if ($delete_all) { $tmp .= ucphr('DELETE_ALL_CONFIRM'); } else { $tmp .= ucphr('DELETE_RECORD_CONFIRM'); } $tmp .= ' (' . count($delete) . ' ' . ucphr('RECORDS') . ')'; $tmp .= "<br>\n"; $tmp .= ucphr('ACTION_IS_DEFINITIVE') . ".<br><br>\n"; $_SESSION["delete"] = $delete; if (!$delete_all) { for (reset($delete); list($key, $value) = each($delete);) { $obj = new $class($value); if (!$obj->no_name) { $description = $obj->name($_SESSION['language']); unset($obj); $tmp .= "<LI>" . $description . "</LI>"; } } } $tmp .= ' <table> <tr> <td> <form action="' . $this->file . '?" method="GET"> <input type="hidden" name="class" value="' . $class . '"> <input type="hidden" name="command" value="delete"> <input type="hidden" name="deleteconfirm" value="1">'; foreach ($start_data as $key => $value) { $tmp .= ' <input type="hidden" name="data[' . $key . ']" value="' . $value . '">'; } $tmp .= ' <input type="submit" value="' . ucphr('YES') . '"> </form> </td> <td> <form action="' . $this->file . '?" method="GET"> <input type="hidden" name="class" value="' . $class . '"> <input type="submit" onclick="history.go(-1);return false;" value="' . ucphr('NO') . '"> </form> </td> </tr> </table>'; $tmp .= '</div>'; $tpl->assign("content", $tmp); } else { if (!$this->silent) { $tmp = '<span class="error_msg">' . ucphr('NO_RECORD_SELECTED') . '.</span><br>'; $tpl->append("messages", $tmp); } } } break; case 'stop': break; default: $obj = new $class(); $obj->admin_list_page($class); break; } if ($command != "delete") { unset($_SESSION["delete"]); } }
function toplist_delete($dishid, $quantity = 1) { if (!$dishid) { return 0; } $query = "DELETE FROM `last_orders` WHERE `dishid`='" . $dishid . "' LIMIT {$quantity}"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } return 0; }
function printDailyIncome($user) { $fillimi = date('Y-m-d') . " 00:00:01"; $fundi = date('Y-m-d') . " 23:59:00"; $userName = $user->data['name']; $table = 'account_mgmt_main'; $queryMoney = "SELECT date, who, description, cash_amount "; $queryMoney .= "FROM `account_mgmt_main`"; $queryMoney .= "WHERE who = '" . $userName . "' AND "; $queryMoney .= "date > '" . $fillimi . "' AND date < '" . $fundi . "'"; $resMoney = common_query($queryMoney, __FILE__, __LINE__); if (!$resMoney) { return ''; } $therearerecordsMoney = mysql_num_rows($resMoney); if ($therearerecordsMoney) { $output = ' <span class="style1">Xhiroja Ditore e ' . $userName . ' nga ' . $fillimi . ' ne ' . $fundi . '</span><br><br><br> <table> <tr> <td height="31" width="100"><strong>Data - Ora</strong></td> <td width="145"><div align="right"><strong>Nr i fatures</strong></div></td> <td width="80"><div align="right"><strong>Vlera lek</strong></div></td> </tr>'; while ($arr = mysql_fetch_array($resMoney)) { $output .= ' <tr> <td width="200"><div align="left">' . $arr['date'] . '</div></td> <td width="145"><div align="right">' . $arr['description'] . '</div></td> <td width="80"><div align="right">' . $arr['cash_amount'] . '</div></td> </tr>'; $totali += $arr['cash_amount']; } $output .= '</table> <br><br> ' . ucfirst(phr('CONNECTED_AS')) . ' ' . $userName . '<strong>' . $totali . ' LEK</strong>'; } return $output; }
function move($destination) { // copies old table info $query = "SELECT * FROM `sources` WHERE `id`='" . $this->id . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } $arr_old = mysql_fetch_array($res, MYSQL_ASSOC); //delete the info we don't want to copy unset($arr_old['id']); unset($arr_old['name']); unset($arr_old['takeaway']); $query = "SELECT * FROM `sources` WHERE `id`='" . $destination . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } $arr_new = mysql_fetch_array($res, MYSQL_ASSOC); // last check before begin: is the table really empty? if ($arr_new['userid'] != 0 || $arr_new['toclose'] != 0 || $arr_new['discount'] != 0 || $arr_new['paid'] != 0 || $arr_new['catprinted'] != '') { return 1; } // moves all the orders $query = "UPDATE `orders` SET `sourceid` = '" . $destination . "' WHERE `sourceid`='" . $this->id . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } // copies table properties $query = "UPDATE `sources` SET "; foreach ($arr_old as $key => $value) { $query .= "`" . $key . "`='" . $value . "',"; } // strips the last comma that has been put $query = substr($query, 0, strlen($query) - 1); $query .= " WHERE `id`='" . $destination . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } // empties the old table $query = "UPDATE `sources` SET `userid`='0',`toclose`='0',`discount` = '0.00',`paid` = '0',`catprinted` = '',`last_access_userid` = '0' WHERE `id` = '" . $this->id . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } return 0; }
function get_conf($file, $line, $name) { $cache = new cache(); $cache_out = $cache->get('conf', $name, 'value'); if ($cache_out != '') { return $cache_out; } $query = "SELECT * FROM `conf` WHERE `name`='{$name}'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } $arr = mysql_fetch_array($res); $ret = $arr['value']; $cache->set('conf', $name, 'value', $ret); return $ret; }
function bill_reset($sourceid) { $query = "UPDATE `orders` SET `paid` = '0' WHERE `sourceid` = '{$sourceid}'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } return 0; }
function access_allowed($level) { $query = "SELECT `value` FROM `system` WHERE `name`='upgrade_last_key'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return true; } $arr = mysql_fetch_array($res); // system version is before user zones -> disable access control if ($arr['value'] < 4) { return true; } $user = new user(); // no user found, auth ok anyway (to allow recovering from lost passwords) if (!$user->count_users()) { return true; } // not authenticated if (!isset($_SESSION['userid'])) { return false; } $user = new user($_SESSION['userid']); // disabled user, deny if ($user->data['disabled']) { return false; } //doesn't have the flag if (!$user->level[$level]) { return false; } // the flag is waiter or cashier or any other that doesn't need a password, ok if ($level == USER_BIT_WAITER || $level == USER_BIT_CASHIER || $level == USER_BIT_MONEY) { return true; } // other flags need password if (isset($_SESSION['passworded']) && $_SESSION['passworded']) { return true; } // password not set return false; }
function mods_list_delete($ord) { $linecounter = 0; $divider = 10; $output = ''; $ord->ingredients_arrays(); $output .= ' <table class="receipt-table"> <tbody> <tr> <td></td> <td><strong>' . ucfirst(phr('CONTAINED')) . '</strong></td> <td style="text-align:center"><img src="' . IMAGE_PLUS . '" width="16" border="0" height="16"></td> <td style="text-align:center"><img src="' . IMAGE_FIELD . '" width="16" border="0" height="16"></td> <td style="text-align:center"><img src="' . IMAGE_MINUS . '" width="16" border="0" height="16"></td> </tr> '; foreach ($ord->ingredients['contained'] as $name => $ingredid) { $ingr = new ingredient($ingredid); $price = $ingr->get('price'); $query = "SELECT `ingred_qty` FROM `orders` WHERE `associated_id`='" . $ord->id . "' AND `ingredid` = '" . $ingredid . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return mysql_errno(); } $arr = mysql_fetch_array($res); $qty = $arr['ingred_qty']; if ($qty == 1) { $checked_lot = ' checked'; $checked_normal = ''; $checked_few = ''; } elseif ($qty == -1) { $checked_lot = ''; $checked_normal = ''; $checked_few = ' checked'; } else { $checked_lot = ''; $checked_normal = ' checked'; $checked_few = ''; } $output .= ' <tr> <td> <input class="largerInput" type="checkbox" name="data[ingreds][' . $ingredid . ']" value="' . $ingredid . '" checked> </td> <td onClick="check_elem(\'form1\',\'data[ingreds]\',' . $ingredid . ');return false;"> ' . ucfirst($name) . ' ' . $price . ' </td> <td> <input class="largerInput" type="radio" name="data[ingred_qty][' . $ingredid . ']" value="1"' . $checked_lot . '> </td> <td> <input class="largerInput" type="radio" name="data[ingred_qty][' . $ingredid . ']" value="0"' . $checked_normal . '> </td> <td> <input class="largerInput" type="radio" name="data[ingred_qty][' . $ingredid . ']" value="-1"' . $checked_few . '> </td> </tr>'; $linecounter++; $modulo = $linecounter % $divider; if ($modulo == 0) { $output .= ' </tbody> </table>'; $output .= navbar_form('form1', 'orders.php?command=list'); $output .= ' <table> <tbody>'; } } $output .= ' </tbody> </table>'; return $output; }
function find_connected_dishes($show_deleted = false, $link = false) { $output = array(); $query = "SELECT dishes.id, dishes.table_id, dishes.table_name FROM `dishes`"; $query .= " JOIN `dishes` WHERE dishes.table_id=dishes.id"; $query .= " AND (`ingreds` LIKE '% " . $this->id . " %'"; $query .= " OR `ingreds` LIKE '" . $this->id . " %'"; $query .= " OR `ingreds` LIKE '" . $this->id . "'"; $query .= " OR `ingreds` LIKE '% " . $this->id . "')"; if (!$show_deleted) { $query .= " AND dishes.deleted='0'"; } $query .= " ORDER BY dishes.table_name ASC"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } while ($arr = mysql_fetch_array($res)) { $dish = new dish($arr['id']); $tmp = ''; if ($link) { $tmp .= '<a href="' . $this->file . '?class=dish&command=edit&data[id]=' . $dish->id . '">'; } $tmp .= $dish->name($_SESSION['language']); if ($link) { $tmp .= '</a>'; } $output['included'][$dish->id] = $tmp; } $query = "SELECT dishes.id, dishes.table_id, dishes.table_name FROM `dishes`"; $query .= " JOIN `dishes` WHERE table_id=dishes.id"; $query .= " AND (`dispingreds` LIKE '% " . $this->id . " %'"; $query .= " OR `dispingreds` LIKE '" . $this->id . " %'"; $query .= " OR `dispingreds` LIKE '" . $this->id . "'"; $query .= " OR `dispingreds` LIKE '% " . $this->id . "')"; if (!$show_deleted) { $query .= " AND dishes.deleted='0'"; } $query .= " ORDER BY dishes.table_name ASC"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } while ($arr = mysql_fetch_array($res)) { $dish = new dish($arr['id']); $ingreds = $dish->dispingredients($arr['dispingreds']); if (!empty($ingreds) && is_array($ingreds)) { if (in_array($this->id, $ingreds)) { $tmp = ''; if ($link) { $tmp .= '<a href="' . $this->file . '?class=dish&command=edit&data[id]=' . $dish->id . '">'; } $tmp .= $dish->name($_SESSION['language']); if ($link) { $tmp .= '</a>'; } $output['available'][$dish->id] = $tmp; } } } return $output; }
function price_zero() { $price = 0; $query = "UPDATE `orders` SET `price`='" . $price . "'\n\t\tWHERE `associated_id` = '" . $this->id . "'\n\t\tAND `deleted`='1'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } return 0; }
function possible_ingredients() { $all = array(); $ingreds = array(); $dispingreds = array(); $ingreds = $this->ingredients(); $dispingreds = $this->dispingredients(); $not_poss = array_merge($ingreds, $dispingreds); $query = "SELECT * FROM `ingreds`"; $query .= " WHERE `category` = '" . $this->data['category'] . "' OR `category` = '0'"; $query .= " AND `deleted` = '0'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } while ($arr = mysql_fetch_array($res)) { $all[] = $arr['id']; } $poss = array_diff($all, $not_poss); sort($poss); return $poss; }
function customer_edit_form($data) { global $tpl; $query = "SELECT * FROM `customers` WHERE `id`='" . $data['id'] . "'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } if (!mysql_num_rows($res)) { $msg = ucphr('ERR_NO_CUSTOMER_FOUND'); $msg = '<font color="Red">' . $msg . '</font>'; $tpl->append('messages', $msg); return ''; } $arr = mysql_fetch_array($res); $msg = ' <form action="orders.php" method="post" name="form1"> <input type="hidden" name="command" value="customer_edit"> <input type="hidden" name="data[id]" value="' . $arr['id'] . '"> '; $msg .= customer_form_data($arr); $msg .= '</form> '; return $msg; }
function table_there_are_orders($sourceid) { $query = "SELECT * FROM `orders` WHERE `sourceid`='{$sourceid}'"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return 0; } return mysql_num_rows($res); }
function takeaway_get_customer_data($sourceid) { $query = "SELECT * FROM `sources` WHERE `id`={$sourceid}"; $res = common_query($query, __FILE__, __LINE__); if (!$res) { return ERR_MYSQL; } $arr = mysql_fetch_array($res); if (!$arr) { return ERR_TABLE_NOT_FOUND; } $data['takeaway_surname'] = $arr['takeaway_surname']; $data['customer'] = $arr['customer']; $takeaway_time = $arr['takeaway_time']; if ($takeaway_time) { $data['takeaway_year'] = substr($takeaway_time, 0, 4); $data['takeaway_month'] = substr($takeaway_time, 4, 2); $data['takeaway_day'] = substr($takeaway_time, 6, 2); $data['takeaway_hour'] = substr($takeaway_time, 8, 2); $data['takeaway_minute'] = substr($takeaway_time, 10, 2); } // some data is found. we return it. if ($takeaway_time && !empty($data['takeaway_surname'])) { return $data; } // we create a dataset with the actual time $data['takeaway_day'] = date("d", time()); $data['takeaway_month'] = date("m", time()); $data['takeaway_year'] = date("Y", time()); $data['takeaway_hour'] = date("H", time()); $data['takeaway_minute'] = date("i", time()); return $data; }