Beispiel #1
0
<?php

include '../includes/db.php';
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('purchase', $_POST['purchase_shipping_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if (substr($key, 0, 9) == "purchase_" && $key != "purchase_supplier" && $key != "purchase_godown" && $key != "purchase_acc_code" && $key != "purchase_notype" && $key != "purchase_id" && $key != "purchase_currency_value") {
            if (strlen($key) > 18 && substr($key, 0, 18) == "purchase_shipment_" || strlen($key) > 14 && substr($key, 0, 14) == "purchase_bank_") {
                // do nothing with these values, will be handled further ahead.
            } else {
                if ($key == "purchase_shipping_date") {
                    $key = "shipping_date";
                    $val = my_sql_date($val);
                }
                if ($key == "purchase_receive_date") {
Beispiel #2
0
<?php

@session_start();
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report']) && $_GET['report'] == 'true') {
    updateDate('rpt_purchase_invoice_start', $_GET['date_start']);
    updateDate('rpt_purchase_invoice_end', $_GET['date_end']);
    require_once '../includes/PDFReport.class.php';
    class PDF extends PDFReport
    {
        function printHeader()
        {
            global $showimport, $recDate, $shipDate, $godown, $partyName, $pid, $billNo;
            $this->SetFont('Arial', 'B', 10);
            $col1 = 30;
            $col2 = 50;
            $col3 = 30;
            $col4 = 50;
            $xspace = 80 - $col2;
            $pdata = array("Invoice #", $pid, "Bill No", $billNo, "Vendor", $partyName, "Warehouse", $godown, "Ship Date", $shipDate, "Receive Date", $recDate);
            for ($i = 0; $i < count($pdata); $i += 4) {
                $border = "0";
                if (strlen($pdata[$i + 0]) > 0) {
                    $border = 'B';
                }
                $this->Cell($col1, 6, $pdata[$i + 0], 0, 0, 'L');
                $this->Cell($col2, 6, $pdata[$i + 1], $border, 0, 'L');
Beispiel #3
0
@session_start();
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_party_ledger_start', $date_start);
    updateDate('rpt_party_ledger_end', $date_end);
    $accounts = array();
    foreach ($_GET['account'] as $account) {
        if ($account == '#ALL#') {
            continue;
        }
        $accounts[] = $account;
    }
    if (count($accounts) == 0) {
        //all was selected
        require_once '../includes/connect.php';
        $items = mysql_query("SELECT coa.account_ref_id\n" . "  FROM chart_of_account coa\n" . "       INNER JOIN party p ON p.account_ref_id = coa.account_ref_id\n" . " WHERE p.party_city = '{$_GET['city']}'\n" . "   AND coa.company_ref_id = {$_SESSION['company_id']}\n" . "ORDER BY account_name");
        while ($row = mysql_fetch_assoc($items)) {
            $accounts[] = $row['account_ref_id'];
        }
    }
<?php

session_start();
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report'])) {
    updateDate('rpt_inventory_movement_start', $_GET['date1']);
    updateDate('rpt_inventory_movement_end', $_GET['date2']);
    $item = array();
    $result = $mysqli->query("SELECT im.i_code, im.cno, im.manufacturer_no, im.description, im.company_ref_id FROM item_master im WHERE i_code = {$_GET['item_hidden']}");
    if ($row = $result->fetch_assoc()) {
        $item = $row;
    }
    $date1 = $_GET['date1'];
    if (strlen($date1) < 1) {
        $date1 = getFinancialStartDate();
    }
    $where = "   AND TO_DAYS(trans_date) >= TO_DAYS('" . my_sql_date($date1) . "')\n";
    if (strlen($_GET['date2']) > 0) {
        $where .= "   AND TO_DAYS(trans_date) <= TO_DAYS('" . my_sql_date($_GET['date2']) . "')\n";
    }
    $data = array();
    $result = $mysqli->query("SELECT g.g_name FROM godown g WHERE g.company_ref_id = {$item['company_ref_id']}");
    while ($row = $result->fetch_assoc()) {
        $gname = $row['g_name'];
        $data["{$gname}"] = array();
        $data["{$gname}"]['total'] = (double) 0;
        $data["{$gname}"]['opening_balance'] = (double) 0;
Beispiel #5
0
session_start();
require_once '../includes/connect.php';
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_ledger_class_start', $date_start);
    updateDate('rpt_ledger_class_end', $date_end);
    $accounts = array();
    $items = mysql_query("SELECT coa.account_ref_id\n" . "  FROM chart_of_account coa\n" . " WHERE coa.account_class = '{$_GET['account_class']}'\n" . "   AND coa.company_ref_id = {$_SESSION['company_id']}\n" . "ORDER BY account_name");
    while ($row = mysql_fetch_assoc($items)) {
        $accounts[] = $row['account_ref_id'];
    }
    $ledger = array();
    foreach ($accounts as $account) {
        $ledger[] = getLedgerData($account, $_GET['report'], $date_start, $date_end);
    }
    $mysqli->close();
    if ($_GET['report'] == 'pdf') {
        include_once '../reports/ledger.pdf.php';
    } else {
        if ($_GET['report'] == 'xls') {
            include_once '../reports/ledger.xls.php';
Beispiel #6
0
<?php

include '../includes/connect.php';
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
include '../includes/JSON.php';
@session_start();
$selected_company_id = $_SESSION['company_id'];
$login_user_name = $_SESSION['user_name'];
ob_start();
dump($_POST);
$data = array();
updateDate('cash_book', $_POST['cash_book_date']);
$cash_book_date = my_sql_date($_POST['cash_book_date']);
if ($_POST['oper'] == 'delete') {
    $cash_book_id = $_POST['cb_id'];
    $voucher_id = getValue("voucher_id", "voucher_detail", "voucher_id = (SELECT voucher_id FROM cash_book WHERE cb_id = {$cash_book_id})", true);
    d_mysql_query("DELETE FROM voucher_detail WHERE voucher_id = {$voucher_id}");
    d_mysql_query("DELETE FROM voucher_master WHERE voucher_id = {$voucher_id}");
    d_mysql_query("DELETE FROM cash_book WHERE cb_id = {$cash_book_id}");
} else {
    $v_cash_acc_id = $_POST['cash_book_id'];
    $year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
    $counter = $_POST['counter'] * 1;
    for ($i = 1; $i <= $counter; $i++) {
        $account_code = $_POST["account_" . $i . "_hidden"];
        $cash_book_ammount = 0;
        $cash_book_type = "";
        if (isset($_POST["inp3_{$i}"])) {
session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_account_outstanding_start', $date_start);
    updateDate('rpt_account_outstanding_end', $date_end);
    $outstanding = array();
    $outstanding[] = getOutstandingData($_GET['account_category'], $_GET['report'], $date_start, $date_end, false);
    $mysqli->close();
    if ($_GET['report'] == 'pdf') {
        include_once '../reports/outstanding.pdf.php';
    } else {
        if ($_GET['report'] == 'xls') {
            include_once '../reports/outstanding.xls.php';
        }
    }
} else {
    ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
Beispiel #8
0
<?php

session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report']) && $_GET['report'] == 'true') {
    updateDate('rpt_sales_invoice_start', $_GET['date_start']);
    updateDate('rpt_sales_invoice_end', $_GET['date_end']);
    require_once '../includes/PDFReport.class.php';
    require_once '../includes/fpdf.rotate.php';
    class PDF extends PDFReport
    {
        function printHeader()
        {
            global $title, $invoice, $partyName, $billno, $partyCity, $date, $billteNo, $transporter, $address, $godown, $aob, $amt;
            $this->SetFillColor(255, 255, 255);
            $col1 = 20;
            $col2 = 60;
            $col3 = 15;
            $col4 = 20;
            $col5 = 25;
            $col6 = 30;
            $xspace = 10;
            $pdata = array();
            if ($partyName != 'Cash') {
                $pdata = array("Customer", $partyName, "Inv#", $invoice, "Date", $date, "Address", $address, "Bilty #", $billteNo, "Amount this Bill", number_format($amt, 0), "City", $partyCity, "Challan#", $billno, "Previous Balance", number_format($aob, 0), "Transporter", $transporter, "Godown", $godown, "Total Balance", number_format($aob + $amt, 0));
            } else {
Beispiel #9
0
<?php

session_start();
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    updateDate('rpt_godown_stock_start', $_GET['date1']);
    updateDate('rpt_godown_stock_end', $_GET['date2']);
    if ($_GET['detail'] == 'detail') {
        include_once '../reports/godown_stock_old.php';
    } else {
        if ($_GET['detail'] == 'compact') {
            include_once '../reports/godown_stock_new.php';
        }
    }
} else {
    ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<link rel="shortcut icon" href="../images/logo_icon.gif">
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<link href="../stylesheets/style.css" rel="stylesheet" type="text/css" />
	<title><?php 
    echo $_SESSION['companyname'];
    ?>
 - Reports</title>
	<?php 
    include '../includes/js.php';
    ?>
Beispiel #10
0
<?php

include '../includes/connect.php';
include_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('delivery_chalan', $_POST['delivery_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if ($key == "delivery_date" || $key == "delivery_party_hidden" || $key == "delivery_godown_hidden" || $key == "delivery_billno" || $key == "delivery_remarks") {
            if ($key == "delivery_date") {
                $val = my_sql_date($val);
            }
            if ($key == "delivery_party_hidden") {
                $key = "party_code";
            }
            if ($key == "delivery_godown_hidden") {
                $key = "g_code";
            }
            if ($key == "delivery_billno") {
@session_start();
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_account_ledger_start', $date_start);
    updateDate('rpt_account_ledger_end', $date_end);
    $ledger = array();
    $ledger[] = getLedgerData_summary($_GET['account_hidden'], $_GET['report'], $date_start, $date_end);
    $mysqli->close();
    if ($_GET['report'] == 'pdf') {
        include_once '../reports/ledger_summary.pdf.php';
    } else {
        if ($_GET['report'] == 'xls') {
            include_once '../reports/ledger_summary.xls.php';
        } else {
            if ($_GET['report'] == 'htm') {
                include '../includes/JSON.php';
                $json = new Services_JSON();
                $output = $json->encode($ledger);
                print $output;
            }
Beispiel #12
0
<?php

session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report']) && $_GET['report'] == 'true') {
    updateDate('rpt_sales_return_start', $_GET['date1']);
    updateDate('rpt_sales_return_end', $_GET['date2']);
    require_once '../includes/PDFReport.class.php';
    class PDF extends PDFReport
    {
        function printHeader()
        {
            global $date, $billNo, $partyName;
            $this->SetFont('Arial', 'B', 8);
            $col1 = 30;
            $col2 = 50;
            $col3 = 30;
            $col4 = 50;
            $xspace = 80 - $col2;
            $pdata = array("Date", $date, "Bill #", $billNo, "Party", $partyName, "", "");
            for ($i = 0; $i < count($pdata); $i += 4) {
                $border = "0";
                if (strlen($pdata[$i + 0]) > 0) {
                    $border = 'B';
                }
                $this->Cell($col1, 6, $pdata[$i + 0], 0, 0, 'L');
Beispiel #13
0
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_account_class_start', $date_start);
    updateDate('rpt_account_class_end', $date_end);
    $outstanding = array();
    $outstanding[] = getOutstandingData($_GET['account_class'], $_GET['report'], $date_start, $date_end, false, true);
    $mysqli->close();
    if ($_GET['report'] == 'pdf') {
        include_once '../reports/outstanding.pdf.php';
    } else {
        if ($_GET['report'] == 'xls') {
            include_once '../reports/outstanding.xls.php';
        }
    }
} else {
    ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php

include '../includes/connect.php';
include_once '../includes/connecti.php';
/** @var $mysqli mysqli */
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('sales_return', $_POST['sales_return_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if ($key == "sales_return_date" || $key == "sales_return_remarks" || $key == "sales_return_party_hidden" || $key == "sales_return_billno" || $key == "sales_return_type" || $key == "sales_return_godown_hidden") {
            if ($key == "sales_return_date") {
                $key = "rsale_date";
                $val = my_sql_date($val);
            }
            if ($key == "sales_return_party_hidden") {
                $key = "party_code";
            }
            if ($key == "sales_return_godown_hidden") {
                $key = "g_code";
Beispiel #15
0
<?php

session_start();
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    updateDate('rpt_cash_movement_start', $_GET['date_start']);
    updateDate('rpt_cash_movement_end', $_GET['date_end']);
    $data = array();
    $tdata = array();
    $accounts_classes = array('BANKS' => 'Karachi Region', 'LHR BANKS' => 'Lahore Region');
    foreach ($accounts_classes as $accounts_class => $accounts_class_name) {
        $sdata = array();
        $openingBalance = (double) 0;
        $sql = "SELECT coa.account_ref_id FROM chart_of_account coa WHERE coa.account_class = '{$accounts_class}' AND coa.company_ref_id = {$_SESSION['company_id']}";
        $result = $mysqli->query($sql);
        while ($row = $result->fetch_assoc()) {
            $aob = getOpeningBalance($row['account_ref_id'], $_GET['date_start']);
            $openingBalance += $aob;
        }
        $sdata[] = array('account_name' => $accounts_class . " OPEN BAL", 'amount' => $openingBalance);
        $runningBalance = (double) 0;
        $sql = "" . "SELECT IFNULL(SUM(vd.debit_amount), 0) bal\n" . "  FROM voucher_detail vd\n" . "       INNER JOIN voucher_master vm ON vm.voucher_id = vd.voucher_id\n" . " WHERE TO_DAYS(vm.voucher_date) >= TO_DAYS('" . my_sql_date($_GET['date_start']) . "')\n" . "   AND TO_DAYS(vm.voucher_date) <= TO_DAYS('" . my_sql_date($_GET['date_end']) . "')\n" . "   AND vd.account_ref_id IN (SELECT coa.account_ref_id FROM chart_of_account coa WHERE coa.account_class = '{$accounts_class}' AND coa.company_ref_id = vm.company_ref_id)\n" . "   AND vm.company_ref_id = {$_SESSION['company_id']}\n";
        $result = $mysqli->query($sql);
        if ($row = $result->fetch_assoc()) {
            $runningBalance += $row['bal'] * 1;
        }
        $sdata[] = array('account_name' => $accounts_class, 'amount' => $runningBalance);
Beispiel #16
0
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_party_age_start', $date_start);
    updateDate('rpt_party_age_end', $date_end);
    $accounts = array();
    foreach ($_GET['account'] as $account) {
        if ($account == '#ALL#') {
            continue;
        }
        $accounts[] = $account;
    }
    if (count($accounts) == 0) {
        //all was selected
        require_once '../includes/db.php';
        $items = oci_parse($conn, "SELECT coa.account_ref_id\n" . "  FROM chart_of_account coa\n" . "       INNER JOIN party p ON p.account_ref_id = coa.account_ref_id\n" . " WHERE p.party_city = '{$_GET['city']}'\n" . "   AND coa.company_ref_id = {$_SESSION['company_id']}\n" . "ORDER BY account_name");
        oci_execute($items);
        while ($row = oci_fetch_assoc($items)) {
            $accounts[] = $row['account_ref_id'];
        }
<?php

include '../includes/db.php';
include_once '../includes/connecti.php';
/** @var $mysqli mysqli */
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('purchase_return', $_POST['purchase_return_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if (substr($key, 0, 9) == "purchase_" && $key != "purchase_return_party" && $key != "purchase_return_notype" && $key != "purchase_return_id" && $key != "purchase_return_godown") {
            if ($key == "purchase_return_date") {
                $key = "pur_ret_date";
                $val = my_sql_date($val);
            }
            if ($key == "purchase_return_party_hidden") {
                $key = "party_code";
            }
            if ($key == "purchase_return_godown_hidden") {
Beispiel #18
0
<?php

session_start();
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    updateDate('rpt_vouchers_start', $_GET['date_start']);
    updateDate('rpt_vouchers_end', $_GET['date_end']);
    $sql = "" . "  SELECT vm.voucher_id, vm.seq,\n" . "         DATE_FORMAT(vm.voucher_date, '%d-%m-%Y') voucher_date_fmt,\n" . "         CASE\n" . "           WHEN vm.voucher_type = 'CR' THEN 'Cash Recieve Voucher'\n" . "           WHEN vm.voucher_type = 'CP' THEN 'Cash Payment Voucher'\n" . "           WHEN vm.voucher_type = 'BV' THEN 'Bank Voucher'\n" . "           WHEN vm.voucher_type = 'JV' THEN 'Journal Voucher'\n" . "           ELSE (SELECT s.description FROM sys_codes s WHERE s.code = vm.voucher_type AND s.company_ref_id = vm.company_ref_id LIMIT 1)\n" . "         END voucher_type,\n" . "         vm.voucher_remarks,\n" . "         CONCAT(u.user_first_name, ' ', u.user_last_name) voucher_by\n" . "    FROM voucher_master vm\n" . "         LEFT OUTER JOIN sys_users u ON u.user_id = vm.voucher_by\n" . "     WHERE vm.company_ref_id = {$_SESSION['company_id']}\n" . "       AND vm.voucher_type NOT IN ('SV', 'SR', 'PV', 'PR', 'CO', 'CJV', 'CBV')";
    if (strlen($_GET['voucher_id']) > 0) {
        $input = $_GET['voucher_id'];
        $rangeCharacters = "0123456789, -";
        $voucher_ids = array();
        if (containsOnly($input, $rangeCharacters)) {
            $ranges = explode(",", $input);
            for ($j = 0; $j < count($ranges); $j++) {
                $range = trim($ranges[$j]);
                if (strlen($range) < 1) {
                    continue;
                }
                $index = strpos($range, "-");
                if ($index > 0) {
                    $rangeInputs = explode("-", $range);
                    if (count($rangeInputs) == 2) {
                        $num1 = $rangeInputs[0] * 1;
                        $num2 = $num3 = $rangeInputs[1] * 1;
                        if ($num1 > $num2) {
                            $num3 = $num1;
                            $num1 = $num2;
                        }
Beispiel #19
0
<?php

session_start();
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    if (strlen($_GET['date_start']) > 0) {
        updateDate('rpt_order_invoice_start', $_GET['date_start']);
    }
    if (strlen($_GET['date_end']) > 0) {
        updateDate('rpt_order_invoice_end', $_GET['date_end']);
    }
    $title = $_title;
    $where = "";
    if (strlen($_GET['date_start']) > 0) {
        $where .= "   AND TO_DAYS(m.o_date) >= TO_DAYS('" . my_sql_date($_GET['date_start']) . "')\n";
    }
    if (strlen($_GET['date_end']) > 0) {
        $where .= "   AND TO_DAYS(m.o_date) <= TO_DAYS('" . my_sql_date($_GET['date_end']) . "')\n";
    }
    if (strlen($_GET['order_id']) > 0) {
        $where .= "   AND m.seq = {$_GET['order_id']}\n";
    }
    if (isset($_GET['supplier']) && count($_GET['supplier']) > 0) {
        if (count($_GET['supplier']) == 1 && $_GET['supplier'][0] == "#ALL#") {
            //Select All was selected.
        } else {
            $where .= "   AND m.party_code IN ('" . join("','", $_GET['supplier']) . "')\n";
        }
    }
Beispiel #20
0
     modifierOeuvre();
     break;
 case 'modifierOeuvreSoumise':
     modifierOeuvreSoumise();
     break;
 case 'modifierArtisteSoumis':
     modifierArtisteSoumis();
     break;
 case 'modifierCommentaireSoumis':
     modifierCommentaireSoumis();
     break;
 case 'updateOeuvresVille':
     updateOeuvresVille();
     break;
 case 'updateDate':
     updateDate();
     break;
 case 'recupererCategories':
     recupererCategories();
     break;
 case 'recupererArrondissements':
     recupererArrondissements();
     break;
 case 'recupererOeuvres':
     recupererOeuvres();
     break;
 case 'recupererUneOeuvre':
     recupererUneOeuvre();
     break;
 case 'recupererUnePhoto':
     recupererUnePhoto();
<?php

@session_start();
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
require_once '../includes/funcs.inc.php';
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report'])) {
    updateDate('rpt_sales_vendor_party_start', $_GET['date_start']);
    updateDate('rpt_sales_vendor_party_end', $_GET['date_end']);
    $title = $_title;
    $partyName = getIVal("party_name", "party", "party_code = {$_GET['party_hidden']}");
    $sql = "" . "SELECT sm.seq, sm.billno, im.cno, concat(IFNULL(CONCAT(manufacturer_no, ' -- '), ''), description) as description,\n" . "       sd.sales_qty, sd.sales_rate, im.circular_rate, im.fix_rate, (sd.sales_qty)*(sd.sales_rate-IFNULL(im.fix_rate,0)) diff\n" . "  FROM sales_master sm\n" . "       INNER JOIN sales_detail sd ON sd.sale_master_id = sm.sale_master_id\n" . "       INNER JOIN item_master im ON im.i_code = sd.i_code\n" . " WHERE sm.party_code = {$_GET['party_hidden']}\n";
    if (strlen($_GET['date_start']) > 0) {
        $sql .= "   AND TO_DAYS(sm.sale_date) >= TO_DAYS('" . my_sql_date($_GET['date_start']) . "')\n";
    }
    if (strlen($_GET['date_end']) > 0) {
        $sql .= "   AND TO_DAYS(sm.sale_date) <= TO_DAYS('" . my_sql_date($_GET['date_end']) . "')\n";
    }
    if (strlen($_GET['date_start']) + strlen($_GET['date_end']) < 1) {
        $d = date('Y') . "-01-01";
        $sql .= "   AND TO_DAYS(sm.sale_date) >= TO_DAYS('{$d}')\n";
    }
    $result = $mysqli->query($sql);
    $data = array();
    $tdata = array('title' => 'Total', 'rate' => (double) 0);
    while ($row = $result->fetch_assoc()) {
        $row['sales_qty'] = $row['sales_qty'] * 1;
        $row['sales_rate'] = $row['sales_rate'] * 1;
        $row['circular_rate'] = $row['circular_rate'] * 1;
Beispiel #22
0
<?php

include '../includes/connect.php';
include_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('order', $_POST['order_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if ($key == "order_date" || $key == "order_supplier_hidden" || $key == "order_remarks" || $key == "order_reference") {
            if ($key == "order_date") {
                $key = "o_date";
                $val = my_sql_date($val);
            }
            if ($key == "order_supplier_hidden") {
                $key = "party_code";
            }
            if ($key == "order_remarks") {
                $key = "remarks";
            }
Beispiel #23
0
<?php

include '../includes/connect.php';
include_once '../includes/connecti.php';
/** @var $mysqli mysqli */
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('sales', $_POST['sales_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$year_start_date = getValue("start_date", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
$sale_date = "";
$sale_party = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if ($key == "sales_date" || $key == "sales_remarks" || $key == "sales_party_hidden" || $key == "sales_godown_hidden" || $key == "sales_billno" || $key == "sales_packing" || $key == "sales_type" || $key == "sales_transporter" || $key == "sales_billteno" || $key == "sales_person" || $key == "sales_by") {
            if ($key == "sales_date") {
                $key = "sale_date";
                //Add following check by Khurram Naseem to avoid stock report bug, if date is financial year start date add one day.
                if (my_sql_date($val) == $year_start_date) {
                    $val = my_sql_date($val);
                    //dump($year_start_date);
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report'])) {
    $date_start = "";
    if (isset($_GET['date_start']) && strlen($_GET['date_start']) > 0) {
        $date_start = $_GET['date_start'];
    }
    $date_end = "";
    if (isset($_GET['date_end']) && strlen($_GET['date_end']) > 0) {
        $date_end = $_GET['date_end'];
    }
    updateDate('rpt_party_outstanding_start', $date_start);
    updateDate('rpt_party_outstanding_end', $date_end);
    $accounts = array();
    if (count($accounts) == 0) {
        //all was selected
        require_once '../includes/db.php';
        $where = "";
        $order = "";
        if (isset($_GET['region']) && strlen($_GET['region']) > 0) {
            $where = "p.party_city IN (SELECT city FROM vu_city_region WHERE region = '{$_GET['region']}')\n";
            $order = "p.party_city, coa.account_name";
        } else {
            if (isset($_GET['city']) && strlen($_GET['city']) > 0) {
                $where = "p.party_city = '{$_GET['city']}'\n";
                $order = "coa.account_name";
            }
        }
Beispiel #25
0
<?php

include '../includes/connect.php';
include_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('voucher', $_POST['voucher_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if ($key == "voucher_date" || $key == "voucher_remarks" || $key == "voucher_type" || $key == "voucher_cheque") {
        if ($key == 'voucher_date') {
            $val = my_sql_date($val);
        }
        $first_colval = $first_colval . $seprator . $key . " = '" . $val . "'";
        $seprator = ',';
    } else {
        if ($key == "voucher_id") {
            $last_part = " WHERE voucher_id = " . $val;
        }
    }
}
<?php

include '../includes/connect.php';
include_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
session_start();
$selected_company_id = $_SESSION['company_id'];
ob_start();
dump($_POST);
$data = array();
updateDate('godown_transfer', $_POST['godown_transfer_date']);
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'", true);
$first_colval = "";
$seprator = "";
$last_part = "";
$first_part = "";
$first_tab_ins = "";
foreach ($_POST as $key => $val) {
    if (strlen($val) > 0) {
        if (substr($key, 0, 16) == "godown_transfer_" && $key != "godown_transfer_from" && $key != "godown_transfer_to" && $key != "godown_transfer_id") {
            if ($key == "godown_transfer_date") {
                $key = "trans_date";
                $val = my_sql_date($val);
            }
            if ($key == "godown_transfer_from_hidden") {
                $key = "from_godown";
            }
            if ($key == "godown_transfer_to_hidden") {
                $key = "to_godown";
            }
<?php

@session_start();
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
require_once '../includes/funcs.inc.php';
$_title = getReportTitle();
if (isset($_GET['report']) && $_GET['report'] == 'true') {
    updateDate('rpt_purchase_return_start', $_GET['date_start']);
    updateDate('rpt_purchase_return_end', $_GET['date_end']);
    require_once '../includes/PDFReport.class.php';
    class PDF extends PDFReport
    {
        function printHeader()
        {
            global $date, $billNo, $partyName;
            $this->SetFont('Arial', 'B', 8);
            $col1 = 30;
            $col2 = 50;
            $col3 = 30;
            $col4 = 50;
            $xspace = 80 - $col2;
            $pdata = array("Date", $date, "Bill #", $billNo, "Vendor", $partyName, "", "");
            for ($i = 0; $i < count($pdata); $i += 4) {
                $border = "0";
                if (strlen($pdata[$i + 0]) > 0) {
                    $border = 'B';
                }
                $this->Cell($col1, 6, $pdata[$i + 0], 0, 0, 'L');
                $this->Cell($col2, 6, $pdata[$i + 1], $border, 0, 'L');
<?php

@session_start();
require_once '../includes/connect.php';
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report'])) {
    if (strlen($_GET['date1']) > 0) {
        updateDate('rpt_godown_transfer_start', $_GET['date1']);
    }
    if (strlen($_GET['date2']) > 0) {
        updateDate('rpt_godown_transfer_end', $_GET['date2']);
    }
    $title = "{$_title}";
    $gfrom = "";
    $gto = "";
    $where = "";
    $year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$_SESSION['company_id']} AND is_active = 'Yes'");
    if (isset($_GET['invoice']) && strlen($_GET['invoice']) > 0) {
        $gfrom = getValue("g.g_name", "godown g INNER JOIN godown_trans_master m ON m.from_godown = g.g_code", "m.tr_id = {$_GET['invoice']}");
        $gto = getValue("g.g_name", "godown g INNER JOIN godown_trans_master m ON m.to_godown   = g.g_code", "m.tr_id = {$_GET['invoice']}");
        $where = "   AND m.tr_id = {$_GET['invoice']}\n";
    } else {
        $gfrom = getValue("g_name", "godown", "g_code = {$_GET['gfrom']}");
        $gto = getValue("g_name", "godown", "g_code = {$_GET['gto']}");
        $where = "   AND m.from_godown = {$_GET['gfrom']}\n   AND m.to_godown = {$_GET['gto']}\n";
    }
    if (strlen($_GET['date1']) > 0) {
Beispiel #29
0
    $html = '<h3>Semester Start Date&nbsp;&nbsp;<div id="sems_date" > <input type="text" name="s_date" id="s_date" value="' . $semStartDate . '" /></div>&nbsp;&nbsp;Semester End Date&nbsp;&nbsp;<div id="seme_date"> <input type="text" name="s_date" id="s_date" value="' . $semEndDate . '" /></div></h3>';
    $html = $html . '<input type="button" name="change" id="update" value="update" onclick="updateDate(' . $dept_id . ');" />';
    echo $html;
}
function updateDate($dDB, $s_date, $e_date, $dept_id)
{
    $re1 = $dDB->setsemStartDate($dept_id, $s_date);
    $re2 = $dDB->setsemEndDate($dept_id, $e_date);
    $html = "";
    $html = $html . '<h3>Semester Start Date&nbsp;&nbsp;<div id="sems_date" >' . $s_date . '</div>&nbsp;&nbsp;Semester End Date&nbsp;&nbsp;<div id="seme_date">' . $e_date . '</div></h3>
                    <input type="button" name="change" id="change"value="change" onclick="editDate(' . $dept_id . ');" />';
    echo $html;
}
require_once '../DB/initDB.php';
require_once '../DB/leaveDB.php';
require_once '../DB/userDB.php';
require_once '../DB/departmentDB.php';
require_once '../checkid.php';
$lDB = new leaveDB();
$uDB = new userDB();
$dDB = new departmentDB();
$param = mysql_escape_string(trim($_POST['param']));
if ($param == editDate) {
    $dept_id = mysql_escape_string(trim($_POST['dept_id']));
    editDate($lDB, $uDB, $dDB, $dept_id);
} elseif ($param == updateDate) {
    $dept_id = mysql_escape_string(trim($_POST['dept_id']));
    $s_date = mysql_escape_string(trim($_POST['s_date']));
    $e_date = mysql_escape_string(trim($_POST['e_date']));
    updateDate($dDB, $s_date, $e_date, $dept_id);
}
<?php

session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
require_once '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
$_title = getReportTitle();
if (isset($_GET['report']) && $_GET['report'] == 'true') {
    updateDate('rpt_delivery_challan_start', $_GET['date_start']);
    updateDate('rpt_delivery_challan_end', $_GET['date_end']);
    require_once '../includes/PDFReport.class.php';
    require_once '../includes/fpdf.rotate.php';
    class PDF extends PDFReport
    {
        function printHeader()
        {
            global $invoice, $partyName, $date, $billno;
            $this->SetFillColor(255, 255, 255);
            $cols = array(15, 55, 15, 10, 15, 15, 15, 20);
            $xspace = 10;
            $pdata = array("Customer", $partyName, "Order#", $invoice, "Challan#", $billno, "Date", $date);
            for ($i = 0; $i < count($pdata); $i += 8) {
                for ($j = 0; $j <= 6; $j += 2) {
                    if ($j > 0) {
                        $this->SetX($this->GetX() + $xspace);
                    }
                    $border = "0";
                    if (strlen($pdata[$i + $j]) > 0) {
                        $border = 'B';