}
foreach ($tvoucher_detail as $vd) {
$sql = "" . "SELECT vm.voucher_id, vd.account_ref_id\n" . " FROM voucher_master vm\n" . " INNER JOIN voucher_detail vd ON vd.voucher_id = vm.voucher_id\n" . " WHERE vm.voucher_remarks = '{$vd['voucher_id']}'\n" . " AND vm.voucher_type = 'CBV'\n" . " AND vd.credit_amount = 0\n";
$result = $mysqli->query($sql);
if ($row = $result->fetch_assoc()) {
$vd['bank_detail'] = $row;
}
$voucher_detail[] = $vd;
}
$sql = "" . "SELECT coa.account_ref_id, coa.account_name FROM chart_of_account coa WHERE coa.account_category = (\n" . "SELECT sc.sys_codes_ref_id FROM sys_codes sc WHERE sc.code = 'Bank' AND sc.company_ref_id = coa.company_ref_id)\n" . "AND coa.company_ref_id = {$selected_company_id} AND coa.is_close = 'No' AND coa.account_ref_id <> {$cheque_id} ORDER BY coa.account_class, coa.account_name\n";
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
$banks[] = $row;
}
}
$value_date = locale_date($value_date);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php
echo $_SESSION['companyname'];
?>
- Cheque Voucher</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="../images/logo_icon.gif">
<?php
include '../includes/js.php';
?>
<script type="text/javascript">
$arr['account_code'] = $row[5];
$cash_book_detail[] = $arr;
}
$cb_balance = '<div id="cb_balance"';
$cb = getValue("IFNULL(sum(debit_amount - credit_amount), 0)", "voucher_detail", "account_code = (SELECT code FROM sys_codes WHERE description = 'CASH ACCOUNT' AND company_ref_id = {$selected_company_id})");
if ($cb < 0) {
$cb_balance .= ' style="color:red;"';
}
$cb_balance .= '>' . number_format($cb, 2, ".", ",") . '</div>';
$cb_balance_todate = '<div id="cb_balance"';
$cb = getValue("IFNULL(sum(vd.debit_amount - vd.credit_amount), 0)", "voucher_detail vd INNER JOIN voucher_master vm ON vm.voucher_id = vd.voucher_id", "vd.account_code = (SELECT code FROM sys_codes WHERE description = 'CASH ACCOUNT' AND company_ref_id = {$selected_company_id}) AND TO_DAYS(vm.voucher_date) <= TO_DAYS('{$cash_book_date}')");
if ($cb < 0) {
$cb_balance_todate .= ' style="color:red;"';
}
$cb_balance_todate .= '>' . number_format($cb, 2, ".", ",") . '</div>';
$cash_book_date = locale_date($cash_book_date);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php
echo $_SESSION['companyname'];
?>
- cash_book</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="../images/logo_icon.gif">
<?php
include '../includes/js.php';
require_once '../includes/funcs.inc.php';
$selected_company_id = $_SESSION['company_id'];
$SQL = "select unit_id, description from item_unit where company_ref_id = {$selected_company_id} order by 2";
$result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error());
$units = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$units[] = $row;
}
$SQL = "SELECT user_id, user_name FROM sys_users WHERE company_ref_id = {$selected_company_id} ORDER BY user_name";
$result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error());
$users = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$users[] = $row;
}
$sales_master = array();
$sales_master['date'] = locale_date(date("Y-m-d"));
$sales_master['party'] = "";
$sales_master['party_hidden'] = "";
$sales_master['godown'] = "";
$sales_master['godown_hidden'] = "";
$sales_master['remarks'] = "";
$sales_master['billno'] = "";
$sales_master['notype'] = "";
$sales_master['packing'] = "";
$sales_master['type'] = "R";
$sales_master['billte_no1'] = "";
$sales_master['transporter1'] = "";
$sales_master['billte_no2'] = "";
$sales_master['transporter2'] = "";
$sales_master['billte_no3'] = "";
$sales_master['transporter3'] = "";
$sql = " UPDATE cash_book SET {$sql} WHERE cb_id = {$cash_book_id}";
} else {
$sql = " INSERT INTO cash_book SET company_ref_id = {$selected_company_id}, year_id = {$year_id}, {$sql}";
}
$result = mysql_query($sql) or die("Couldn t execute query." . mysql_error());
$parent_key = -1;
if (strlen($cash_book_id) > 0) {
$parent_key = $cash_book_id;
} else {
$parent_key = mysql_insert_id();
}
if (strlen($cash_book_id) > 0) {
$voucher_id = getValue("voucher_id", "voucher_detail", "voucher_id = (SELECT voucher_id FROM cash_book WHERE cb_id = {$cash_book_id})");
dd_mysql_query("DELETE FROM voucher_detail WHERE voucher_id = {$voucher_id}");
dd_mysql_query("DELETE FROM voucher_master WHERE voucher_id = {$voucher_id}");
}
$v_cash_acc_id = getValue("code", "sys_codes", "description = 'CASH ACCOUNT'");
$call = "";
if ($cash_book_type == 'R') {
$call = "CALL Create_Voucher({$selected_company_id}, {$year_id}, {$v_cash_acc_id}, {$account_code}, '{$cash_book_ammount}', '{$remarks}', {$parent_key}, 'CR', '" . $cash_book_date . "')";
} else {
$call = "CALL Create_Voucher({$selected_company_id}, {$year_id}, {$account_code}, {$v_cash_acc_id}, '{$cash_book_ammount}', '{$remarks}', {$parent_key}, 'CP', '" . $cash_book_date . "')";
}
$mysqli->query($call);
}
}
}
$mysqli->close();
$url = "../transaction/cash_book.php?cash_date=" . locale_date($cash_book_date);
//echo "<a href='$url'>$url</a><br/>";
header("Location: {$url}");
<?php
session_start();
include '../includes/connect.php';
require_once '../includes/funcs.inc.php';
$selected_company_id = $_SESSION['company_id'];
$voucher_master = array();
$voucher_master['date'] = locale_date(date("Y-m-d"));
$voucher_master['remarks'] = "";
$voucher_master['type'] = "JV";
$voucher_detail = array();
$orderby = "";
$sortorder = "";
require_once 'paginator.class.php';
$pages = new Paginator();
$accordion_active = "1";
$search = array();
$search['s_voucher_id'] = "";
$search['voucher_date'] = "";
$search['voucher_type'] = "";
$search['account'] = "";
$search['account_hidden'] = "";
if ($_SERVER['REQUEST_METHOD'] == 'POST' || isset($_GET['ipp'])) {
$vid = "";
if (isset($_POST['s_voucher_id']) && strlen($_POST['s_voucher_id']) > 0) {
$vid = "vm.voucher_id = '{$_POST['s_voucher_id']})'";
$search['s_voucher_id'] = $_POST['s_voucher_id'];
} else {
if (isset($_GET['s_voucher_id']) && strlen($_GET['s_voucher_id']) > 0) {
$vid = "vm.voucher_id = '{$_GET['s_voucher_id']}'";
$search['s_voucher_id'] = $_GET['s_voucher_id'];
<?php
session_start();
include '../includes/connect.php';
require_once '../includes/funcs.inc.php';
$selected_company_id = $_SESSION['company_id'];
$SQL = "SELECT user_id, user_name FROM sys_users WHERE company_ref_id = {$selected_company_id} AND user_name IN ('khurram', 'zeeshan') ORDER BY user_name";
$result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error());
$users = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$users[] = $row;
}
$sales_visit = array();
$sales_visit['date'] = locale_date(date("Y-m-d"));
$sales_visit['route'] = "";
$sales_visit['visit_by'] = $_SESSION['user_id'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title><?php
echo $_SESSION['companyname'];
?>
- Sales Visit</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="../images/logo_icon.gif">
<?php
include '../includes/js.php';
?>
<link rel="stylesheet" type="text/css" href="../stylesheets/paginate.css"/>
echo $row['party_city'];
?>
"><?php
echo $row['party_city'];
?>
</option><?php
}
$result->close();
?>
</select>
</td>
</tr>
<tr>
<td class="tablebody"><label for="date_start">Start Date</label></td>
<td class="tablebody"><input type="text" name="date_start" id="date_start" value="<?php
echo locale_date(date('Y') . '-01-01');
?>
" /></td>
</tr>
<tr>
<td class="tablebody"><label for="date_end">End Date</label></td>
<td class="tablebody"><input type="text" name="date_end" id="date_end" value="" /></td>
</tr>
</tbody>
<tfoot>
<tr>
<td class="tablebody"> </td>
<td class="tablebody">
<input type="button" name="btn" value=" Generate " onclick="javascript:onGenerate(this);" />
</td>
</tr>
$row['debit'] = number_format($row['debit']);
$row['credit'] = number_format($row['credit']);
$row['sno'] = $sno++;
$data[] = $row;
}
$result->close();
$mysqli->close();
$printTitle = $title;
if (strlen($startDate) > 0 && strlen($endDate) > 0) {
$printTitle .= " (" . locale_date($startDate) . " to " . locale_date($endDate) . ")";
} else {
if (strlen($startDate) > 0) {
$printTitle .= " (from " . locale_date($startDate) . ")";
} else {
if (strlen($endDate) > 0) {
$printTitle .= " (till " . locale_date($endDate) . ")";
}
}
}
$ac = $aob + $dr - $cr;
if ($_GET['report'] == 'pdf') {
require_once '../includes/PDFReport.class.php';
class PDF extends PDFReport
{
function Header()
{
$this->printTitle();
$this->SetFont('Arial', '', 12);
$this->SetX(-35);
$this->Cell(0, 6, date("M d, Y"), 0, 1, 'R');
$this->Ln(10);
