session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
include '../includes/db.php';
include '../includes/connecti.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 1";
$result = oci_parse($conn, $SQL) or die("Couldn t execute query." . oci_error());
oci_execute($result);
$units = array();
while ($row = oci_fetch_array($result, MYSQL_ASSOC)) {
    $units[] = $row;
}
//echo "<pre>"; print_r($units); echo "</pre>";
$v = getScreenDefaultGodown('Sales Return');
$sales_return_master = array();
$sales_return_master['date'] = $_SESSION['dates']['sales_return'];
$sales_return_master['seq'] = "";
$sales_return_master['fyc'] = "No";
$sales_return_master['party'] = "";
$sales_return_master['party_hidden'] = "";
$sales_return_master['godown'] = $v['g_name'];
$sales_return_master['godown_hidden'] = $v['g_code'];
$sales_return_master['remarks'] = "";
$sales_return_master['billno'] = "";
$sales_return_master['type'] = "R";
$sales_return_detail = array();
$orderby = "";
$sortorder = "";
require_once 'paginator.class.php';
session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
include '../includes/db.php';
include '../includes/connecti.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 1";
$result = oci_parse($conn, $SQL) or die("Couldn t execute query." . oci_error());
oci_execute($result);
$units = array();
while ($row = oci_fetch_array($result, MYSQL_ASSOC)) {
    $units[] = $row;
}
//echo "<pre>"; print_r($units); echo "</pre>";
$v = getScreenDefaultGodown('Purchase Return');
$purchase_return_master = array();
$purchase_return_master['seq'] = "";
$purchase_return_master['fyc'] = "No";
$purchase_return_master['party'] = "";
$purchase_return_master['party_hidden'] = "";
$purchase_return_master['godown'] = $v['g_name'];
$purchase_return_master['godown_hidden'] = $v['g_code'];
$purchase_return_master['return_date'] = $_SESSION['dates']['purchase_return'];
$purchase_return_master['remarks'] = "";
$purchase_return_master['billno'] = "";
$purchase_return_master['type'] = "R";
$purchase_return_detail = array();
$orderby = "";
$sortorder = "";
require_once 'paginator.class.php';
Exemple #3
0
<?php

session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
include '../includes/db.php';
include '../includes/connecti.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 1";
$result = oci_parse($conn, $SQL) or die("Couldn t execute query." . oci_error());
oci_execute($result);
$units = array();
while ($row = oci_fetch_array($result, MYSQL_ASSOC)) {
    $units[] = $row;
}
$v = getScreenDefaultGodown('Purchase');
$purchase_master = array();
$purchase_master['seq'] = "";
$purchase_master['fyc'] = "No";
$purchase_master['supplier'] = "";
$purchase_master['supplier_hidden'] = "";
$purchase_master['shipping_date'] = $_SESSION['dates']['purchase'];
$purchase_master['receive_date'] = "";
$purchase_master['godown'] = $v['g_name'];
$purchase_master['godown_hidden'] = $v['g_code'];
$purchase_master['remarks'] = "";
$purchase_master['billno'] = "";
$purchase_master['discount'] = "";
$purchase_master['reference'] = "";
$purchase_master['notype'] = "";
$purchase_master['type'] = "R";
Exemple #4
0
<?php

@session_start();
include '../includes/connect.php';
include '../includes/connecti.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 1";
$result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error());
$units = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $units[] = $row;
}
//echo "<pre>"; print_r($units); echo "</pre>";
$v = getScreenDefaultGodown('Order');
$order_master = array();
$order_master['date'] = $_SESSION['dates']['order'];
$order_master['seq'] = "";
$order_master['supplier'] = "";
$order_master['supplier_hidden'] = "";
$order_master['remarks'] = "";
$order_master['reference'] = "";
$order_detail = array();
$orderby = "";
$sortorder = "";
require_once 'paginator.class.php';
$pages = new Paginator();
$accordion_active = "1";
if (isset($_GET['orderby'])) {
    $year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'");
    $void = "";
<?php

session_start();
include '../includes/connect.php';
include '../includes/connecti.php';
require_once '../includes/funcs.inc.php';
$selected_company_id = $_SESSION['company_id'];
$year_id = getValue("year_id", "sys_financial_year", "company_ref_id = {$selected_company_id} AND is_active = 'Yes'");
$v = getScreenDefaultGodown('Sales');
$delivery_master = array();
$delivery_master['date'] = $_SESSION['dates']['delivery_chalan'];
$delivery_master['seq'] = "";
$delivery_master['party'] = "";
$delivery_master['party_hidden'] = "";
$delivery_master['godown'] = $v['g_name'];
$delivery_master['godown_hidden'] = $v['g_code'];
$delivery_master['billno'] = "";
$delivery_master['remarks'] = "";
$delivery_detail = array();
$orderby = "";
$sortorder = "";
require_once 'paginator.class.php';
$pages = new Paginator();
$accordion_active = "1";
if ($_SERVER['REQUEST_METHOD'] == 'POST' || isset($_GET['ipp'])) {
    $s_delivery_id = "";
    if (isset($_POST['s_delivery_id']) && strlen($_POST['s_delivery_id']) > 0) {
        $s_delivery_id = "dm.seq = {$_POST['s_delivery_id']}";
    } else {
        if (isset($_GET['s_delivery_id']) && strlen($_GET['s_delivery_id']) > 0) {
            $s_delivery_id = "dm.seq = {$_GET['s_delivery_id']}";
session_start();
$conn = oci_connect($db_user, $db_pass, $db_host);
include '../includes/db.php';
include '../includes/connecti.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 1";
$result = oci_parse($conn, $SQL) or die("Couldn t execute query." . oci_error());
oci_execute($result);
$units = array();
while ($row = oci_fetch_array($result, MYSQL_ASSOC)) {
    $units[] = $row;
}
//echo "<pre>"; print_r($units); echo "</pre>";
$v = getScreenDefaultGodown('Godown Transfer');
$godown_transfer_master = array();
$godown_transfer_master['date'] = $_SESSION['dates']['godown_transfer'];
$godown_transfer_master['seq'] = "";
$godown_transfer_master['gto'] = "";
$godown_transfer_master['gto_hidden'] = "";
$godown_transfer_master['gfrom'] = $v['g_name'];
$godown_transfer_master['gfrom_hidden'] = $v['g_code'];
$godown_transfer_master['remarks'] = "";
$godown_transfer_master['billno'] = "";
$godown_transfer_detail = array();
$orderby = "";
$sortorder = "";
require_once 'paginator.class.php';
$pages = new Paginator();
$accordion_active = "1";