function ingredient($id = 0)
{
$this->table = 'ingreds';
$this->id = $id;
$this->fields_names = array('id' => ucphr('ID'), 'name' => ucphr('NAME'), 'category' => ucphr('CATEGORY'), 'price' => ucphr('PRICE'), 'quantity' => ucphr('QUANTITY'), 'unit_type' => '', 'value' => ucphr('UNITARY_VALUE') . ' [' . country_conf_currency(true) . ']', 'override_autocalc', 'visible' => ucphr('VISIBLE'), 'sell_price' => ucphr('SELL_PRICE'));
$this->fields_boolean = array('override_autocalc', 'visible');
$this->fields_width = array('name' => '100%');
$this->allow_single_update = array('override_autocalc', 'visible');
$this->title = ucphr('INGREDIENTS');
$this->file = ROOTDIR . '/admin/admin.php';
$this->flag_delete = true;
$this->show_category_list = true;
$this->fetch_data();
}
function stock_object($id = 0)
{
$this->db = 'common';
$this->table = 'stock_objects';
$this->id = $id;
$this->title = ucphr('STOCK');
$this->referring_name = true;
$this->flag_delete = true;
$this->fields_names = array('id' => ucphr('ID'), 'name' => ucphr('NAME'), 'ref_type' => ucphr('TYPE'), 'ref_id' => ucphr('INGREDIENT'), 'unit_type' => '', 'quantity' => ucphr('QUANTITY'), 'value' => ucphr('VALUE') . ' [' . country_conf_currency(true) . ']');
$this->fields_width = array('name' => '75%');
$this->hide = array('ref_id');
$this->file = ROOTDIR . '/include/stock/index.php';
$this->disable_new = true;
$this->fetch_data();
}
function stock_movement($id = 0)
{
$this->db = 'common';
$this->table = 'stock_movements';
$this->id = $id;
$this->title = ucphr('STOCK_MOVEMENTS');
$this->no_name = true;
$this->disable_new = true;
$this->file = ROOTDIR . '/include/stock/index.php';
$this->main_list_item = 'obj_id';
$this->hide = array('obj_id', 'dish_id');
$this->default_orderby = 'timestamp';
$this->default_sort = 'desc';
$this->fields_width = array('name' => '40%', 'dish_name' => '40%', 'timestamp' => '20%');
$this->fields_names = array('id' => ucphr('ID'), 'timestamp' => ucphr('TIME'), 'user_name' => ucphr('WHO'), 'name' => ucphr('NAME'), 'obj_id' => ucphr('OBJECT'), 'dish_name' => ucphr('DISH'), 'dish_quantity' => ucphr('DISH_QUANTITY'), 'quantity' => ucphr('QUANTITY'), 'unit_type' => '', 'value' => ucphr('VALUE') . ' [' . country_conf_currency(true) . ']', 'user' => ucphr('USER'));
$this->fetch_data();
}
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 discount_form_javascript($sourceid)
{
$output = '';
if (isset($_SESSION['discount'])) {
$percent = $_SESSION['discount']['percent'];
$amount = -1 * $_SESSION['discount']['amount'];
} else {
$percent = 0;
$amount = 0;
}
if (!isset($_SESSION['discount']) || !isset($_SESSION['discount']['type'])) {
$_SESSION['discount']['type'] = '';
}
switch ($_SESSION['discount']['type']) {
case "percent":
$dis[1] = "";
$dis[2] = "disabled";
$chk[0] = "";
$chk[1] = "checked";
$chk[2] = "";
break;
case "amount":
$dis[1] = "disabled";
$dis[2] = "";
$chk[0] = "";
$chk[1] = "";
$chk[2] = "checked";
break;
default:
$dis[1] = "disabled";
$dis[2] = "disabled";
$chk[0] = "checked";
$chk[1] = "";
$chk[2] = "";
break;
}
// Next is a micro-form to set a discount in percent value
$output .= '
<FIELDSET>
<LEGEND>' . ucfirst(phr('DISCOUNT')) . '</LEGEND>
<FORM ACTION="orders.php" NAME="form_discount" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="command" VALUE="bill_discount">
<INPUT TYPE="HIDDEN" NAME="keep_separated" VALUE="1">
<input type="radio" name="discount_type" value="none" onclick="JavaScript:discount_switch();" ' . $chk[0] . '>' . ucfirst(phr('NONE')) . '<br />
<input type="radio" name="discount_type" value="percent" onclick="JavaScript:discount_switch();" ' . $chk[1] . '>
' . ucfirst(phr('PERCENTUAL')) . ' <INPUT TYPE="text" name="percent" size="2" maxlength="2" value="' . $percent . '" ' . $dis[1] . '>% <br />
<input type="radio" name="discount_type" value="amount" onclick="JavaScript:discount_switch();" ' . $chk[2] . '>' . ucfirst(phr('VALUE')) . '
<INPUT TYPE="text" name="amount" size="4" maxlength="4" value="' . $amount . '" ' . $dis[2] . '>' . country_conf_currency(true) . '<br />
<INPUT TYPE="button" onClick="applyDiscount(\'form_discount\')" value="' . ucfirst(phr('APPLY_DISCOUNT')) . '"><br />
</FORM>
</FIELDSET>
';
return $output;
}
function bill_print_taxes($receipt_id, $destid)
{
$msg = "";
$dest_language = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'dests', "language", $destid);
$table = 'account_mgmt_main';
$query = "SELECT * FROM {$table} WHERE `id`='{$receipt_id}'";
$res = common_query($query, __FILE__, __LINE__);
if (!$res) {
return 0;
}
$arr = mysql_fetch_array($res);
$taxable = $arr['cash_taxable_amount'];
$vat_total = $arr['cash_vat_amount'];
$msg .= "\t\t" . ucfirst(lang_get($dest_language, 'PRINTS_TAXABLE')) . " \t" . country_conf_currency() . " {$taxable}";
for (reset($_SESSION['vat']); list($key, $value) = each($_SESSION['vat']);) {
$vat_rate_name = $_SESSION['vat'][$key]['name'];
$vat_rate = $_SESSION['vat'][$key]['rate'] * 100;
$vat_local = $_SESSION['vat'][$key]['tax'];
$vat_local = sprintf("%0.2f", $vat_local);
$msg .= "\n\t\t" . ucfirst(lang_get($dest_language, 'PRINTS_TAX')) . " " . $vat_rate_name . " (" . $vat_rate . "%) \t" . country_conf_currency() . " {$vat_local}";
}
$msg .= "\n\t\t" . ucfirst(lang_get($dest_language, 'PRINTS_TAX_TOTAL')) . " \t" . country_conf_currency() . " {$vat_total}";
return $msg;
}
function table_closed_interface_pos()
{
global $tpl;
date_default_timezone_set(get_conf(__FILE__, __LINE__, "default_timezone"));
if (bill_orders_to_print($_SESSION['sourceid'])) {
$_SESSION['select_all'] = 1;
$err = bill_select_pos();
if ($err) {
error_display($err);
}
return 0;
}
$tpl->set_waiter_template_file('closed_table_pos');
$paid = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'sources', "paid", $_SESSION['sourceid']);
$total = table_total($_SESSION['sourceid']);
$discount = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'sources', 'discount', $_SESSION['sourceid']);
if ($total == 0 && $paid == 0) {
$err = table_pay(1);
status_report('PAYMENT', $err);
$paid = get_db_data(__FILE__, __LINE__, $_SESSION['common_db'], 'sources', "paid", $_SESSION['sourceid']);
}
$tmp = navbar_tables_only_pos();
$user = new user($_SESSION['userid']);
if ($user->level[USER_BIT_CASHIER]) {
$tmp = navbar_empty_pos();
}
$tpl->assign('navbar', $tmp);
$tmp = '
' . ucfirst(phr('TABLE_TOTAL_DISCOUNTED')) . ': <b>' . country_conf_currency(true) . ' ' . $total . '</b>
';
if ($discount != 0) {
$discount = sprintf("%01.2f", abs($discount));
$tmp .= '
(' . ucfirst(phr('DISCOUNT')) . ': ' . country_conf_currency(true) . ' ' . $discount . ')';
}
$tmp .= '<br />' . "\n";
$tpl->assign('total', $tmp);
if ($paid) {
$tmp = '
<FORM ACTION="orders.php" METHOD=POST>
<INPUT TYPE="HIDDEN" NAME="command" VALUE="clear">
' . ucfirst(phr('PAID_ALREADY')) . '<br/>
' . ucfirst(phr('EMPTY_TABLE_EXPLAIN')) . '
<INPUT TYPE="submit" value="' . ucfirst(phr('EMPTY_TABLE_BUTTON')) . '">
</FORM>
';
$tmp .= '<br />' . "\n";
$tpl->assign('clear', $tmp);
}
// user is not allowed to pay, so don't display the button
if (!access_allowed(USER_BIT_MONEY)) {
return 0;
}
$tmp = '
<FORM ACTION="orders.php" METHOD=POST>
<INPUT TYPE="HIDDEN" NAME="command" VALUE="pay">
' . ucfirst(phr('PAID_ASK')) . '<br/>
';
if ($paid) {
$tmp .= '
<INPUT TYPE="hidden" name="data[paid]" value="0">
<INPUT TYPE="submit" value="' . ucfirst(phr('NOT_PAID_BUTTON')) . '">
<br/><br/>';
} else {
$tmp .= '
<INPUT TYPE="hidden" name="data[paid]" value="1">
<INPUT TYPE="submit" value="' . ucfirst(phr('PAID_BUTTON')) . '">
<br/><br/>';
}
$tmp .= '
</FORM>';
$tmp .= '<br />' . "\n";
$tpl->assign('pay', $tmp);
return 0;
}
