| .. | |||||
| SimpleImage-master | |||||
| abeautifulsite | |||||
| cache | |||||
| css | |||||
| images | |||||
| includes | |||||
| js | |||||
| jsupload | |||||
| pics | |||||
| .htaccess | |||||
| .project | |||||
| ajax.php | |||||
| autocomplete.php | |||||
| config.php | |||||
| index.php | |||||
| print.css | |||||
| print.html | |||||
| print.php | |||||
| temp.html | |||||
| templatemo_style.css |
| Server IP : 104.21.87.198 / Your IP : 162.158.108.59 Web Server : Apache/2.2.15 (CentOS) System : Linux GA 2.6.32-431.1.2.0.1.el6.x86_64 #1 SMP Fri Dec 13 13:06:13 UTC 2013 x86_64 User : apache ( 48) PHP Version : 5.6.38 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/html/quanly/single/ |
Upload File : |
<?php
include('config.php');
if (@$_SESSION['adm_id']<1){
die('500 - Internal Server Error');
} else{
$act=@$_GET['act'];
$tab=(int)@$_GET['tab'];
$nd='';
switch ($act){
case 'loadtab':
if ($tab>0){
$nd=loadtab($tab);
}
break;
case 'loaditem':
if ($tab>0){
$nd=loaditem($tab);
}
break;
case 'loaditems':
$nd=loaditems();
break;
case 'additem':
if ($tab>0){
$nd=additem($tab,(int)@$_GET['item']);
}
break;
case 'tablist':
$nd=loadtablist();
break;
case 'frmedit':
$nd=frmedit();
break;
case 'updatetab':
$nd=updatetab($tab);
break;
case 'canceltab':
$nd=canceltab($tab);
break;
case 'checkout':
$nd=checkout($tab);
break;
case 'frmadd':
$nd=frmadd();
break;
case 'reportlist':
$nd=reportlist();
break;
case 'reporttab':
$nd=reporttab();
break;
case 'detailtab':
$nd=detailtab($tab);
break;
case 'add':
$nd=add();
break;
case 'movetab':
$nd=movetab();
break;
case 'movetabto':
$nd=movetabto();
break;
}
echo $nd;
}
//------------------
function loadtab($tab){
global $cf;
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}tab
WHERE tab_id=$tab");
$r=$db->rows;
if ($r[0]['tab_id']<1){
$nd='Bàn không tồn tại';
} else{
if ($r[0]['tab_status']==1){
$nd="<form name='formVar' id='formVar'>
<input type='hidden' name='q[]' value='0' />
<a href='#' onclick='loadtablist();return false;'><img src='images/dialog_cancel.png' /></a><center><h3>Hoá đơn thanh toán</h3><b>{$r[0]['tab_name']}</b></center>
<br/>{timein}
<div class='CSSTableGenerator' ><table><tr><td width='10px'><b>#</b></td><td width='125px'><b>Món</b></td><td><b>SL</b></td>
<td><b>Đơn giá</b></td><td><b>Thành tiền</b></td></tr>
{item}
</table></div></form>
<br/><h3>Tổng tiền: {tong}</h3>
<!--
<b>Khấu trừ: </b> <input type='text' size='15' name='discount' value='{discount}' />
<h3>Thành tiền: {tong2}</h3>
-->
";
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE iv_table=$tab AND iv_status=0");
$r2=$db->rows;
$timein='Giờ vào: '.date('H:i',$r2[0]['iv_time']).' - Số phút: '.round(($cf['time']-$r2[0]['iv_time'])/60,0);
$discount=$r2[0]['iv_discount'];
$items=explode("|", $r2[0]['iv_items']);
$itlist=explode(",", $items[0]);
$vllist=explode(",", $items[1]);
$ivid=$r2[0]['iv_id'];
$l1="{$itlist[0]}";
$total=0;
for ($i=1;$i<count($itlist);$i++){
$l1.=",{$itlist[$i]}";
}
$itx="";
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_id in ($l1)");
$r3=$db->rows;
$k=1;
$dellist=array();
for ($j=0;$j<count($itlist);$j++){
for ($i=0;$i<count($r3);$i++){
if ($r3[$i]['it_id']==$itlist[$j]){
if ($vllist[$j]>0){
$totalx=$vllist[$j]*$r3[$i]['it_price'];
$total+=$vllist[$j]*$r3[$i]['it_price'];
$itx.="<tr><td>$k</td><td>{$r3[$i]['it_name']}</td><td><input onClick='this.select();' size='3' name='q[]' value='{$vllist[$j]}'></td>
<td>".number_format($r3[$i]['it_price'],0,",",'.')."</td><td>".number_format($totalx,0,",",'.')."</td></tr>";
$k++;
} else{
$dellist[]=$j;
}
}
}
}
for ($i=0;$i<count($itlist);$i++){
if (!in_array($i, $dellist)){
$arr2[]=$itlist[$i];
$arr3[]=$vllist[$i];
}
}
$itlist=$arr2;
$vllist=$arr3;
if (count($itlist)==1 && $itlist[0]==0){
unset($itlist);
unset($vllist);
$st='';
} else{
$l1="{$itlist[0]}";
$l2="{$vllist[0]}";
for ($i=1;$i<count($itlist);$i++){
if ($itlist[$i]>0){
$l1.=",{$itlist[$i]}";
$l2.=",{$vllist[$i]}";
}
}
$st="$l1|$l2";
}
$db->query("UPDATE {$cf['prefix']}invoice SET iv_items='$st' WHERE iv_id={$r2[0]['iv_id']}");
$nd.="<script>
function opend(){
var page = 'print.php?id=$ivid';
var dialog = $('<div></div>')
.html('<iframe style=\"border: 0px;\" src=\"' + page + '\" width=\"100%\" height=\"100%\"></iframe>')
.dialog({
autoOpen: false,
modal: true,
height: 625,
width: 500,
title: ''
});
dialog.dialog('open');
}
$('table tr').click(function() {
bgColor = $(this).css('background-color');
if (bgColor == '#fff' || bgColor == 'rgb(255, 255, 255)' || bgColor == 'rgb(212, 255, 170)'){
//$('table tr').css('background', '#fff');
$(this).css('background', '#faa');
} else{
$(this).css('background', '#fff');
}
//alert(bgColor);
});
</script>";
if (empty($itlist)){
$db->query("UPDATE {$cf['prefix']}invoice SET iv_items='', iv_total=0, iv_status=2 WHERE iv_id={$r2[0]['iv_id']}");
$db->query("UPDATE {$cf['prefix']}tab SET tab_status=0 WHERE tab_id={$tab}");
$nd="<a href='#' onclick='loadtablist();return false;'><img src='images/dialog_cancel.png' /></a><center><h3>Bàn trống</h3><b>Bàn {$r[0]['tab_name']}</b>
</center>
";
} else{
$nd=str_replace(array('{item}','{tong}','{timein}','{discount}'), array($itx,number_format($total,0,",",'.'),$timein,$discount), $nd);
if ($r2[0]['iv_total']!=$total){
$db->query("UPDATE {$cf['prefix']}invoice SET iv_total=$total WHERE iv_id={$r2[0]['iv_id']}");
}
$nd.='<br/><center>
<a href="#" onclick="updatetab('.$tab.');return false;"><img src="images/update.png" /></a>
<a href="#" onclick="movetab('.$tab.','.$r2[0]['iv_id'].');return false;"><img src="images/chuyenban.png" /></a>
<a href="#" onclick="checkout('.$tab.');return false;"><img src="images/checkout.png" /></a>
<a href="#" onclick="opend();return false;"><img src="images/intam.png" /></a>
<br/>
<a href="#" onclick="canceltab('.$tab.');return false;"><img src="images/cancel.png" /></a>
</center>
';
}
} else{
$nd="<a href='#' onclick='loadtablist();return false;'><img src='images/dialog_cancel.png' /></a><center><h3>Bàn trống</h3><b>{$r[0]['tab_name']}</b>
</center>
";
}
}
$db->disconnect();
return $nd;
}
function loaditem($tab){
global $cf;
$s=@$_GET['s'];
$db = new Kdb($cf);
if ($s!=''){
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_name LIKE '%$s%'");
} else{
$db->query("SELECT * FROM {$cf['prefix']}items ORDER BY it_cat");
}
$r=$db->rows;
$db->disconnect();
$rand=$cf['time'].'-'.rand(10,200);
$nd='
<script>
var options, a;
jQuery(function(){
options = { serviceUrl:"autocomplete.php",
onSelect: function(value, data){
$.get("ajax.php?act=loaditem&tab='.$tab.'&s=" + data ,
function(data){
$("#item").html(data);
});
} };
a = $("#s").autocomplete(options);
});
function toggle(element){
$.get("ajax.php?act=loaditem&tab='.$tab.'&s=" + element.value ,
function(data){
$("#item").html(data);
});
}
</script>
Tìm kiếm: <input type="text" size="50" name="s" id="s" onchange="toggle(this);" />
<ul id="items">';
for ($i=0;$i<count($r);$i++){
$img='images/noimg.png';
if ($r[$i]['it_img']!='') $img=$r[$i]['it_img'];
$nd.="<li>
<img src='$img?$rand' width='220' /> <br/>
<a href='#' onclick='additem($tab,{$r[$i]['it_id']});return false;'>{$r[$i]['it_name']}
<img src='images/plus.png' class='mid' /></a>
</li>";
}
$nd.='</ul>';
return $nd;
}
function loaditems(){
global $cf;
$s=@$_GET['s'];
$db = new Kdb($cf);
if ($s!=''){
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_name LIKE '%$s%'");
} else{
$db->query("SELECT * FROM {$cf['prefix']}items ORDER BY it_cat");
}
$r=$db->rows;
$db->disconnect();
$nd='<script>
var options, a;
jQuery(function(){
options = { serviceUrl:"autocomplete.php",
onSelect: function(value, data){
$.get("ajax.php?act=loaditems&s=" + data ,
function(data){
$("#item").html(data);
});
} };
a = $("#s").autocomplete(options);
});
function toggle(element){
$.get("ajax.php?act=loaditems&s=" + element.value ,
function(data){
$("#item").html(data);
});
}
</script>
Tìm kiếm: <input type="text" size="50" name="s" id="s" onchange="toggle(this);" />
<ul id="items">';
for ($i=0;$i<count($r);$i++){
$img='images/noimg.png';
if ($r[$i]['it_img']!='') $img=$r[$i]['it_img'];
$rand=$cf['time'].'-'.rand(10,200);
$nd.="<li>
<img src='$img?$rand' width='220' /><br/>
<a href='#' onclick='frmedit({$r[$i]['it_id']});return false;'>{$r[$i]['it_name']}
[ {$r[$i]['it_price']} ]
<img src='images/config.png' class='mid' /></a>
</li>";
}
$nd.='</ul>';
return $nd;
}
function additem($tab,$it){
global $cf;
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_id=$it");
$r=$db->rows;
$db->query("SELECT * FROM {$cf['prefix']}tab WHERE tab_id=$tab");
$r1=$db->rows;
if ($r[0]['it_id']>0 && $r1[0]['tab_id']>0){
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE iv_table=$tab AND iv_status=0");
$r2=$db->rows;
if ($r2[0]['iv_id']<1){
$db->query("INSERT INTO {$cf['prefix']}invoice(iv_user,iv_table,iv_time,iv_total,iv_items,iv_status)
VALUES({$_SESSION['adm_id']},$tab,{$cf['time']},{$r[0]['it_price']},'{$r[0]['it_id']}|1',0)");
$db->query("UPDATE {$cf['prefix']}tab SET tab_status=1 WHERE tab_id=$tab");
} else{
$items=explode("|", $r2[0]['iv_items']);
$itlist=explode(",", $items[0]);
$vllist=explode(",", $items[1]);
if (in_array($it, $itlist)){
$k=0;
for ($i=0;$i<count($itlist);$i++){
if ($itlist[$i]==$it) $k=$i;
}
$vllist[$k]++;
}else{
array_push($itlist, $it);
array_push($vllist, 1);
print_r($itlist);
}
$l1="{$itlist[0]}";
$l2="{$vllist[0]}";
$total=0;
for ($i=1;$i<count($itlist);$i++){
$l1.=",{$itlist[$i]}";
$l2.=",{$vllist[$i]}";
}
$items=$l1."|".$l2;
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_id in ($l1)");
$r3=$db->rows;
for ($i=0;$i<count($r3);$i++){
for ($j=0;$j<count($itlist);$j++){
if ($r3[$i]['it_id']==$itlist[$j]) $total+=$vllist[$j]*$r3[$i]['it_price'];
}
}
$db->query("UPDATE {$cf['prefix']}invoice SET iv_items='$items', iv_total=$total WHERE iv_id={$r2[0]['iv_id']}");
}
}
$db->disconnect();
return $nd;
}
function updatetab($tab){
global $cf;
$nd='';
$st=@$_GET['st'];
if ($st!=''){
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE iv_table=$tab AND iv_status=0");
$r2=$db->rows;
if ($r2[0]['iv_id']>0){
$it=explode("|", $r2[0]['iv_items']);
$items=$it[0]."|".$st;
$db->query("UPDATE {$cf['prefix']}invoice SET iv_items='$items' WHERE iv_id={$r2[0]['iv_id']}");
$nd='ok';
}
$db->disconnect();
}
return $nd;
}
function canceltab($tab){
global $cf;
$nd='';
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE iv_table=$tab AND iv_status=0");
$r2=$db->rows;
if ($r2[0]['iv_id']>0){
$db->query("UPDATE {$cf['prefix']}tab SET tab_status=0 WHERE tab_id=$tab");
$db->query("UPDATE {$cf['prefix']}invoice SET iv_items='', iv_total=0, iv_status=2 WHERE iv_id={$r2[0]['iv_id']}");
$nd='ok';
}
$db->disconnect();
return $nd;
}
function checkout($tab){
global $cf;
$nd='';
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE iv_table=$tab AND iv_status=0");
$r2=$db->rows;
if ($r2[0]['iv_id']>0){
$db->query("UPDATE {$cf['prefix']}tab SET tab_status=0 WHERE tab_id=$tab");
$db->query("UPDATE {$cf['prefix']}invoice SET iv_status=1 WHERE iv_id={$r2[0]['iv_id']}");
$nd='Đã thanh toán và lưu lại';
} else{
$nd='Có lỗi';
}
$db->disconnect();
return $nd;
}
function loadtablist(){
global $cf;
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}tab WHERE tab_hide=0 ORDER BY tab_id");
$r=$db->rows;
$db->disconnect();
$nd='<ul id="tabx">';
for ($i=0;$i<count($r);$i++){
$st='';
if ($r[$i]['tab_status']==1) $st='_busy';
$tabtype='table';
if ($r[$i]['tab_karaoke']==1) $tabtype='karaoke';
$nd.='<li>
<a href="#" onclick="tabchose('.$r[$i]['tab_id'].'); return false;">
<img src="images/'.$tabtype.''.$st.'.png" /><br/>
'.$r[$i]['tab_name'].'
</a>
</li>';
}
$nd.='</ul>';
return $nd;
}
function movetab(){
global $cf;
$tab=(int) $_GET['tab'];
$inv=(int) $_GET['inv'];
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}tab WHERE tab_hide=0 and tab_status=0 ORDER BY tab_id");
$r=$db->rows;
$db->disconnect();
$nd='<ul id="tabx">';
for ($i=0;$i<count($r);$i++){
$tabtype='table';
if ($r[$i]['tab_karaoke']==1) $tabtype='karaoke';
$nd.='<li>
<a href="#" onclick="movetabto('.$tab.','.$r[$i]['tab_id'].','.$inv.'); return false;">
<img src="images/'.$tabtype.'.png" /><br/>
'.$r[$i]['tab_name'].'
</a>
</li>';
}
$nd.='</ul>';
return $nd;
}
function movetabto(){
global $cf;
$tabfrom=(int) $_GET['tabfrom'];
$tabto=(int) $_GET['tabto'];
$inv=(int) $_GET['inv'];
$db = new Kdb($cf);
$db->query("UPDATE {$cf['prefix']}tab SET tab_status=0 WHERE tab_id={$tabfrom}");
$db->query("UPDATE {$cf['prefix']}tab SET tab_status=1 WHERE tab_id={$tabto}");
$db->query("UPDATE {$cf['prefix']}invoice SET iv_table={$tabto} WHERE iv_id={$inv}");
$nd='ok';
return $nd;
}
function frmadd(){
global $cf;
$nd='
<h3>Thêm hàng hoá</h3>
<form action="?act=add" method="post" enctype="multipart/form-data">
<div>
<label for="it_name">Tên hàng hoá:</label>
<input name="it_name" type="text" class="input_field" id="name" maxlength="150" />
</div>
<div>
<label for="it_price">Giá tiền:</label>
<input name="it_price" type="text" class="input_field" id="price" maxlength="150" />
</div>
<label for="file">Ảnh:</label>
<input type="file" name="file" id="file"><br>
<input type="submit" name="submit" value="Submit" class="submit_btn">
</form>';
return $nd;
}
function frmedit(){
global $cf;
$id=(int)@$_GET['id'];
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_id=$id");
$r=$db->rows;
$db->disconnect();
$nd=' <a href="#" onclick="frmadd(); return false;" ><img src="images/dialog_cancel.png" /></a>
<h3>Sửa hàng hoá</h3>
<form action="?act=edit" method="post" enctype="multipart/form-data">
<div>
<label for="it_name">Tên hàng hoá:</label>
<input name="it_name" type="text" class="input_field" id="name" value="'.$r[0]['it_name'].'" maxlength="150" />
</div>
<div>
<label for="it_price">Giá tiền:</label>
<input name="it_price" type="text" class="input_field" id="price" value="'.$r[0]['it_price'].'" maxlength="150" />
</div>
<label for="file">Ảnh:</label>
<input type="file" name="file" id="file"><br>
<input type="submit" name="submit" value="Submit" class="submit_btn" />
<input type="hidden" name="id" value="'.$r[0]['it_id'].'" />
</form>';
return $nd;
}
function reportlist(){
global $cf;
$nd="<form name='formVar' id='formVar'>
<input type='hidden' name='q[]' value='0' />
<center><h3>Báo cáo</h3><b>Từ ngày {from} đến ngày {to} [Doanh thu: {tong}] </b></center>
<div class='CSSTableGenerator2' ><table><tr><td width='10px'><b>#</b></td><td width='250px'><b>Món</b></td><td><b>SL</b></td>
<td><b>Đơn giá</b></td><td><b>Thành tiền</b></td></tr>
<!--item-->
</table></div></form>";
$from=@$_GET['fromdate'];
$to=@$_GET['todate'];
$fromdate=strtotime($from);
$todate=strtotime($to)+86400;
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE (iv_time>=$fromdate AND iv_time<=$todate) AND iv_status=1");
$r=$db->rows;
$ids=array();
$values=array();
for ($i=0;$i<count($r);$i++){
$id=explode("|", $r[$i]['iv_items']);
if (count($id)==2){
$vl=explode(",",$id[0]);
$va=explode(",",$id[1]);
for ($j=0;$j<count($vl);$j++){
if (!in_array($vl[$j], $ids)){
$ids[]=$vl[$j];
$values[]=$va[$j];
}else{
for ($k=0;$k<count($ids);$k++){
if ($ids[$k]==$vl[$j]){
$values[$k]+=$va[$j];
}
}
}
}
}
}
$l1="{$ids[0]}";
$total=0;
for ($i=1;$i<count($ids);$i++){
$l1.=",{$ids[$i]}";
}
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_id in ($l1)");
$r3=$db->rows;
$k=1;
$itx='';
for ($j=0;$j<count($ids);$j++){
for ($i=0;$i<count($r3);$i++){
if ($r3[$i]['it_id']==$ids[$j]){
if ($values[$j]>0){
$totalx=$values[$j]*$r3[$i]['it_price'];
$total+=$values[$j]*$r3[$i]['it_price'];
$itx.="<tr><td>$k</td><td>{$r3[$i]['it_name']}</td><td>{$values[$j]}</td>
<td>".number_format($r3[$i]['it_price'],0,",",'.')."</td><td>".number_format($totalx,0,",",'.')."</td></tr>";
$k++;
}
}
}
}
$nd=str_replace(array('{from}','{to}','{tong}','<!--item-->'), array($from,$to,number_format($total,0,",",'.'),$itx), $nd);
$db->disconnect();
return $nd;
}
function reporttab(){
global $cf;
$nd="<form name='formVar' id='formVar'>
<input type='hidden' name='q[]' value='0' />
<center><h3>Chi tiết bàn</h3></center>
<div class='CSSTableGenerator' ><table><tr><td width='10px'><b>#</b></td><td width='130px'><b>Ngày giờ</b></td>
<td><b>Bàn</b></td><td><b>Tổng tiền</b></td></tr>
<!--item-->
</table></div></form>";
$from=@$_GET['fromdate'];
$to=@$_GET['todate'];
$fromdate=strtotime($from);
$todate=strtotime($to)+86400;
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}tab WHERE tab_hide=0");
$r=$db->rows;
$tab=array();
for ($i=0;$i<count($r);$i++){
$tab[$r[$i]['tab_id']]=$r[$i]['tab_name'];
}
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE (iv_time>=$fromdate AND iv_time<=$todate) AND iv_status=1 ORDER BY iv_id DESC");
$r=$db->rows;
$itx='';
$k=1;
for ($i=0;$i<count($r);$i++){
$itx.="<tr><td>{$r[$i]['iv_id']}</td><td><a href='#' onclick=\"detailtab({$r[$i]['iv_id']},'$from','$to');return false;\"><font color='black'>".
date("d-m-Y H:i",$r[$i]['iv_time'])."</font></a></td><td>{$tab[$r[$i]['iv_table']]}</td>
<td>".number_format($r[$i]['iv_total'],0,",",'.')."</td></tr>";
$k++;
}
$nd=str_replace(array('<!--item-->'), array($itx), $nd);
$db->disconnect();
return $nd;
}
function detailtab($tab){
global $cf;
$db = new Kdb($cf);
$db->query("SELECT * FROM {$cf['prefix']}tab WHERE tab_hide=0");
$r=$db->rows;
$tabx=array();
for ($i=0;$i<count($r);$i++){
$tabx[$r[$i]['tab_id']]=$r[$i]['tab_name'];
}
$nd="<form name='formVar' id='formVar'>
<input type='hidden' name='q[]' value='0' />
<a href='#' onclick=\"reporttab('".$_GET['fromdate']."','".$_GET['todate']."');return false;\"><img src='images/dialog_cancel.png' /></a>
<center><h3>Hoá đơn thanh toán</h3>Số hd: $tab; Bàn: {tabname}; ngày: {time} </center>
<div class='CSSTableGenerator' ><table><tr><td width='10px'><b>#</b></td><td width='130px'><b>Món</b></td><td><b>SL</b></td>
<td><b>Đơn giá</b></td><td><b>Thành tiền</b></td></tr>
{item}
</table></div></form>
<br/><h3>Tổng tiền: {tong}</h3>
<script>
function opend(){
var page = 'print.php?id=$tab';
var dialog = $('<div></div>')
.html('<iframe style=\"border: 0px; \" src=\"' + page + '\" width=\"100%\" height=\"100%\"></iframe>')
.dialog({
autoOpen: false,
modal: true,
height: 625,
width: 500,
title: 'In'
});
dialog.dialog('open');
}
</script>
<a href='#' onclick='opend();'><img src='images/print.png'></a>
";
$db->query("SELECT * FROM {$cf['prefix']}invoice WHERE iv_id=$tab");
$r2=$db->rows;
$items=explode("|", $r2[0]['iv_items']);
$itlist=explode(",", $items[0]);
$vllist=explode(",", $items[1]);
$l1="{$itlist[0]}";
$total=0;
for ($i=1;$i<count($itlist);$i++){
$l1.=",{$itlist[$i]}";
}
$itx="";
$db->query("SELECT * FROM {$cf['prefix']}items WHERE it_id in ($l1)");
$r3=$db->rows;
$k=1;
$dellist=array();
for ($j=0;$j<count($itlist);$j++){
for ($i=0;$i<count($r3);$i++){
if ($r3[$i]['it_id']==$itlist[$j]){
if ($vllist[$j]>0){
$totalx=$vllist[$j]*$r3[$i]['it_price'];
$total+=$vllist[$j]*$r3[$i]['it_price'];
$itx.="<tr><td>$k</td><td>{$r3[$i]['it_name']}</td><td>{$vllist[$j]}</td>
<td>".number_format($r3[$i]['it_price'],0,",",'.')."</td><td>".number_format($totalx,0,",",'.')."</td></tr>";
$k++;
}
}
}
}
for ($i=0;$i<count($itlist);$i++){
if (!in_array($i, $dellist)){
$arr2[]=$itlist[$i];
$arr3[]=$vllist[$i];
}
}
$itlist=$arr2;
$vllist=$arr3;
if (count($itlist)==1 && $itlist[0]==0){
unset($itlist);
unset($vllist);
$st='';
} else{
$l1="{$itlist[0]}";
$l2="{$vllist[0]}";
for ($i=1;$i<count($itlist);$i++){
if ($itlist[$i]>0){
$l1.=",{$itlist[$i]}";
$l2.=",{$vllist[$i]}";
}
}
$st="$l1|$l2";
}
$nd=str_replace(array('{item}','{tong}','{tabname}','{time}'), array($itx,number_format($total,0,",",'.'),$tabx[$r2[0]['iv_table']],date("d-m-Y H:i",$r2[0]['iv_time'])), $nd);
$db->disconnect();
return $nd;
}
?>| .. | |||||
| SimpleImage-master | |||||
| abeautifulsite | |||||
| cache | |||||
| css | |||||
| images | |||||
| includes | |||||
| js | |||||
| jsupload | |||||
| pics | |||||
| .htaccess | |||||
| .project | |||||
| ajax.php | |||||
| autocomplete.php | |||||
| config.php | |||||
| index.php | |||||
| print.css | |||||
| print.html | |||||
| print.php | |||||
| temp.html | |||||
| templatemo_style.css |