本文整理汇总了PHP中getIVal函数的典型用法代码示例。如果您正苦于以下问题：PHP getIVal函数的具体用法？PHP getIVal怎么用？PHP getIVal使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getIVal函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getIVal
} else {
$invoice = $d['sale_master_id'];
$partyName = $d['party_name'];
$partyCity = $d['party_city'];
$billno = $d['billno'];
$date = $d['sale_date_fmt'];
$billteNo = $d['billte_no'];
$transporter = $d['transporter_name'];
$address = $d['party_address'];
$voucher = $d['voucher_id'];
$godown = $d['g_name'];
$packing = $d['packing_charges'] * 1;
$aob = 0;
if ($partyName != 'Cash') {
$aob1 = getIVal("IFNULL(opening_balance, 0)", "account_opening_balance", "account_ref_id = {$d['account_ref_id']} AND year_id = {$year_id}") * 1;
$aob2 = getIVal("IFNULL(SUM(vd.debit_amount - vd.credit_amount),0) bal", "voucher_master vm INNER JOIN voucher_detail vd ON vd.voucher_id = vm.voucher_id", "vd.account_ref_id = {$d['account_ref_id']} AND vm.year_id = {$year_id} AND vm.voucher_id < {$voucher}") * 1;
$aob = $aob1 + $aob2;
}
$sql = "SELECT * FROM vu_saledetailsreport WHERE sale_master_id = {$d['sale_master_id']}";
$result = $mysqli->query($sql);
$ddata = array();
$amt = 0;
$dis = 0;
$net = 0;
$sno = 1;
while ($row = $result->fetch_assoc()) {
$row['sno'] = $sno++;
$amt += $row['amount'] * 1;
$dis += $row['discount_value'] * 1;
$net += $row['net'] * 1;
$row['raw_qty'] = $row['raw_qty'] * 1;示例2: getIVal
buttonImageOnly: true,
constrainInput: true,
disableInput: true,
minDate: <?php
echo getIVal("minDate", "vu_minMaxDate", "company_ref_id = {$_SESSION['company_id']} AND is_active = 'Yes'");
?>
});
$("#date2").datepicker({
showOn: 'button',
buttonImage: '../images/calendar.gif',
buttonImageOnly: true,
constrainInput: true,
disableInput: true,
minDate: <?php
echo getIVal("minDate", "vu_minMaxDate", "company_ref_id = {$_SESSION['company_id']} AND is_active = 'Yes'");
?>
});
});
$(function() {
populate('Godown', 'godown');
$('#category').change(function() {
$('#item').html('');
getPopulateSelect($(this).val());
});
$('#chkDetail').click(function() {
$('#vendor').attr('disabled', 'disabled');
$('#category').attr('disabled', '');示例3: session_start
<?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'])) {
$vehicle = "";
$where = "";
if (strlen($_GET['vehicle']) > 0) {
$where = " AND im.vehicle_id = {$_GET['vehicle']}\n";
}
$vendor = getIVal("CASE WHEN p.party_name = 'DEPO AUTO PARTS' THEN 'DEPO' WHEN p.party_name = 'TIK ZENITH TROOP' THEN 'TIK' WHEN p.party_name = 'FORTUNE PARTS INDUSTRY' THEN 'FPI' ELSE p.party_name END party_name", "party p", "party_code = {$_GET['party']}");
$title = $_title;
$sql = "" . "SELECT im.i_code, im.cno, im.description, im.model, im.oem, IFNULL(im.circular_rate,0) rate, CONCAT(iu.description, ' RATE') unit,\n" . " im.fix_rate, im.vehicle_id, s.code vehicle\n" . " FROM item_master im\n" . " INNER JOIN item_category ic ON ic.cat_id = im.cat_id\n" . " INNER JOIN item_unit iu ON iu.unit_id = ic.unit_id\n" . " INNER JOIN sys_codes s ON s.sys_codes_ref_id = im.vehicle_id\n" . " WHERE IFNULL(im.circular_rate,0) > 0\n" . $where . " AND im.party_code = {$_GET['party']}\n" . " order by im.description\n";
$data = array();
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
$vid = $row['vehicle_id'];
$row['rate'] = $row['rate'] * 1;
$row['fix_rate'] = $row['fix_rate'] * 1;
if (!isset($data["{$vid}"])) {
$data["{$vid}"] = array();
$data["{$vid}"]['vehicle'] = $row['vehicle'];
$data["{$vid}"]['data'] = array();
}
$data["{$vid}"]['data'][] = $row;
}
$mysqli->close();示例4: array
$step = $_POST['step'] * 1;
$data = array();
$data['error'] = true;
$data['error_msg'] = "Invalid";
switch ($step) {
case 1:
$p_comp = addslashes(trim($_POST['new_comp']));
$company = getIVal("company_ref_id", "sys_companies", "name = '{$p_comp}'");
dump($company);
if ($company != null) {
$data['error'] = true;
$data['error_msg'] = "Company Name already exists";
break;
}
$p_email = addslashes(trim($_POST['new_email']));
$company = getIVal("company_ref_id", "sys_companies", "email = '{$p_email}'");
dump($company);
if ($company != null) {
$data['error'] = true;
$data['error_msg'] = "E-Mail already exists";
break;
}
if ($company == null) {
$p_showCaptcha = 'No';
if (isset($_POST['show_captcha'])) {
$p_showCaptcha = $_POST['show_captcha'];
}
/* Create New Company */
$ret = newcompany_data($p_comp, $p_email, $p_showCaptcha);
dump($ret);
$data['error'] = $ret['error'];示例5: while
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
$taxes[] = $row;
}
?>
<div id="tabCountrySetContainer">
<ul>
<li><a href="#tabCountrySetCountry"><span title="World Countries">Country</span></a></li>
<li><a href="#tabCountrySetRegion"><span title="Provinces">Region</span></a></li>
<li><a href="#tabCountrySetCity"><span title="Cities">City</span></a></li>
</ul>
<div id="tabCountrySetCountry">
<form id="formCountrySetCountry" autocomplete="off" method="post" action="settings_cud.php">
<input type="hidden" name="form" value="countrySetCountry" />
<input type="hidden" name="parentCountryCode" value="<?php
echo getIVal('sys_codes_ref_id', 'sys_codes', "code = 'Country' AND company_ref_id = {$selected_company_id}");
?>
" />
<table border="0" width="100%" align="center">
<colgroup>
<col width="40%" />
<col width="40%" />
<col width="19%" />
<col width="1%" />
</colgroup>
<thead>
<tr>
<th class="tableth"><div class="tableheader">Name</div></th>
<th class="tableth"><div class="tableheader">Description</div></th>
<th class="tableth" colspan="2"><div class="tableheader">Active</div></th>
</tr>示例6: getIVal
buttonImageOnly: true,
constrainInput: true,
disableInput: true,
minDate: <?php
echo getIVal("minDate", "vu_minMaxDate", "company_ref_id = {$_SESSION['company_id']}");
?>
});
$("#date_end").datepicker({
showOn: 'button',
buttonImage: '../images/calendar.gif',
buttonImageOnly: true,
constrainInput: true,
disableInput: true,
minDate: <?php
echo getIVal("minDate", "vu_minMaxDate", "company_ref_id = {$_SESSION['company_id']}");
?>
});
});
$(function() {
});
function onGenerate(btn) {
if ($('#account_class').val() == '') {
alert("Please select an account class first.");
document.getElementById('account_class').focus();
return;
}
setTimeout("ref()", 1000);示例7: d_mysql_query
if (strlen($voucher_detail_id) > 0) {
d_mysql_query("UPDATE voucher_detail SET debit_amount = {$taxamt} WHERE voucher_id = {$voucher_id} AND account_ref_id = {$account_ref_id}");
} else {
d_mysql_query("INSERT INTO voucher_detail SET debit_amount = {$taxamt}, voucher_id = {$voucher_id}, account_ref_id = {$account_ref_id}, credit_amount = 0, remarks = 'Tax'");
}
}
}
} else {
$parent_key = $_POST['dpurchase_id'];
}
/* start auditing on add, update, delete */
$voucher_id = getValue("voucher_id", "purchase_master", "p_id = {$parent_key}", true);
$voucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, '{$oper}', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$voucher_id}", true);
d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$voucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$voucher_id}");
echo "Purchase Import Exp";
$evoucher_id = getIVal("voucher_id", "purchase_import_exp", "p_id = {$parent_key}", true);
if ($evoucher_id != null) {
$evoucher_aud_id = d_mysql_query("INSERT INTO voucher_master_aud SELECT NULL, vm.*, '{$oper}', {$_SESSION['user_id']}, now() FROM voucher_master vm WHERE vm.voucher_id = {$evoucher_id}", true);
d_mysql_query("INSERT INTO voucher_detail_aud SELECT NULL, vd.*, {$evoucher_aud_id} FROM voucher_detail vd WHERE vd.voucher_id = {$evoucher_id}");
}
$purchase_aud_id = d_mysql_query("INSERT INTO purchase_master_aud SELECT NULL, pm.*, {$voucher_aud_id}, '{$oper}', {$_SESSION['user_id']}, now() FROM purchase_master pm WHERE p_id = {$parent_key}", true);
d_mysql_query("INSERT INTO purchase_detail_aud SELECT NULL, pd.*, {$purchase_aud_id} FROM purchase_detail pd WHERE pd.p_id = {$parent_key}");
/* end auditing on add, update, delete */
if ($oper == 'delete') {
d_mysql_query("DELETE FROM purchase_import_exp WHERE p_id = {$parent_key}");
if ($evoucher_id != null) {
d_mysql_query("DELETE FROM voucher_detail WHERE voucher_id = {$evoucher_id}");
d_mysql_query("DELETE FROM voucher_master WHERE voucher_id = {$evoucher_id}");
}
d_mysql_query("DELETE FROM purchase_detail WHERE p_id = {$parent_key}");
d_mysql_query("DELETE FROM purchase_master WHERE p_id = {$parent_key}");示例8: array
<?php
require_once '../includes/connecti.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
/** @var $_title string */
require_once '../includes/funcs.inc.php';
$title = $_title . "({$_GET['date1']} - {$_GET['date2']})";
$godowns = array();
$sql = "SELECT g_name FROM godown WHERE company_ref_id = {$_SESSION['company_id']}";
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
$godowns[] = $row['g_name'];
}
$isStartDate = getIVal("TO_DAYS(start_date) < TO_DAYS('" . my_sql_date($_GET['date1']) . "')", "sys_financial_year", "company_ref_id = {$_SESSION['company_id']} AND is_active = 'Yes'");
$oOper = "<";
if ($isStartDate == '0') {
$oOper = "<=";
}
$swhere = "";
$swhere .= " AND TO_DAYS(s.trans_date) >= TO_DAYS('" . my_sql_date($_GET['date1']) . "')\n";
$swhere .= " AND TO_DAYS(s.trans_date) <= TO_DAYS('" . my_sql_date($_GET['date2']) . "')\n";
$owhere = " AND s.trans_date >= (SELECT y.start_date FROM sys_financial_year y WHERE y.company_ref_id = s.company_ref_id AND y.is_active = 'Yes')\n";
$owhere .= " AND TO_DAYS(s.trans_date) {$oOper} TO_DAYS('" . my_sql_date($_GET['date1']) . "')\n";
$where = "";
/*
-- Remark By Khurram Adding Multiply Selection of vendor in below block of code.
if (strlen($_GET['vendor_hidden']) > 0) {
$where .= " AND s.party_code = $_GET[vendor_hidden]\n";
}
*/示例9: ob_start
require_once '../includes/funcs.inc.php';
include '../includes/JSON.php';
include '../includes/connecti.php';
/** @var $mysqli mysqli */
/** @var $result mysqli_result */
@session_start();
ob_start();
dump($_POST);
$step = $_POST['step'] * 1;
$data = array();
$data['error'] = true;
$data['error_msg'] = "Invalid";
switch ($step) {
case 1:
$p_comp = addslashes(trim($_POST['new_comp']));
$company = getIVal("company_ref_id", "sys_companies", "name = '{$p_comp}'");
dump($company);
if ($company != null) {
$data['error'] = true;
$data['error_msg'] = "Company Name already exists";
break;
}
$p_email = addslashes(trim($_POST['new_email']));
/*$company = getIVal("company_ref_id", "sys_companies", "email = '$p_email'");
dump($company);
if ($company != null) {
$data['error'] = true;
$data['error_msg'] = "E-Mail already exists";
break;
}*/
if ($company == null) {示例10: mysql_query
$sql = "exp_code = '{$e_code}', amount = '{$amt}', account_ref_id = '{$cacc}', remarks = '{$remarks}'";
if (strlen($import_id) > 0) {
$sql = " UPDATE purchase_import_exp SET {$sql} WHERE pi_id = {$import_id}";
} else {
$sql = " INSERT INTO purchase_import_exp SET p_id = {$parent_key}, {$sql}";
}
}
echo $sql . "<br/>";
mysql_query($sql) or die("Couldn t execute query." . mysql_error());
if (strlen($_POST["expense_" . $i]) < 1) {
$_key = 0;
} else {
$dr_acc = getIVal("code", "sys_codes", "sys_codes_ref_id = {$e_code}");
if (strlen($import_id) > 0) {
$_key = $import_id;
$voucher_id = getIVal("voucher_id", "purchase_import_exp", "pi_id = {$_key}");
d_mysql_query("UPDATE voucher_detail SET debit_amount = {$amt}, account_ref_id = {$dr_acc} WHERE voucher_id = {$voucher_id} AND remarks = 'Debit'");
d_mysql_query("UPDATE voucher_detail SET credit_amount = {$amt}, account_ref_id = {$cacc} WHERE voucher_id = {$voucher_id} AND remarks = 'Credit'");
} else {
$_key = mysql_insert_id();
$createVoucher = createVoucher($selected_company_id, $year_id, $dr_acc, $cacc, $amt, $remarks, $_key, 'PI', my_sql_date($_POST['purchase_receive_date']), $_SESSION['user_id']);
dump($createVoucher);
}
}
$data["iid_" . $i] = $_key;
}
}
$sum = getValue("sum((ship_quantity * ship_rate) - IFNULL(discount_rate, 0)) amt", "purchase_detail", "p_id = {$parent_key}", true);
$dr_acc = -1;
$cr_acc = -1;
$purchase_exchange_rate = 0;示例11: session_start
<?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'])) {
$where = "";
if (strlen($_GET['party']) > 0) {
$where = " AND cat.cat_id = {$_GET['party']}\n";
}
$vendor = getIVal("cat_name", "item_category ", "cat_id = {$_GET['party']}");
$title = $_title;
$sql = "" . "SELECT cat.cat_id cat_id, cat.cat_name catname,im.i_code ,im.cno, im.manufacturer_no, im.description ,\n" . " ROUND(IFNULL(AVG(sd.sales_rate), 0)) sale_rate, ROUND(IFNULL(sum(sd.sales_qty), 0)) sale_qty\n" . " FROM item_master im\n" . " INNER JOIN item_category cat ON cat.cat_id = im.cat_id\n" . "\t INNER JOIN sales_detail sd on sd.i_code = im.i_code\n" . " where im.company_ref_id = {$_SESSION['company_id']}\n" . $where . " group by cat.cat_id,cat.cat_name,im.cno,\n" . " im.i_code, im.manufacturer_no, im.description \n" . " order by im.cno\n";
$data = array();
$result = $mysqli->query($sql);
while ($row = $result->fetch_assoc()) {
$vid = $row['catname'];
$cost = icost($row['i_code']);
$row['Cost'] = $cost;
$row['Diff'] = $row['sale_rate'] - $cost;
$row['Amount'] = $row['sale_qty'] * $row['Diff'];
//$data["$vid"]['data'] = array();
$data["{$vid}"]['data'][] = $row;
}
if ($_GET['report'] == 'pdf') {
require_once '../includes/PDFReport.class.php';
class PDF extends PDFReport
{示例12: mysql_query
}
$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'];
}
}
$ndata = array();
foreach ($accounts as $account) {
$party = getIVal("party_name", "party", "account_ref_id = {$account}");
$party_hidden = getIVal("party_code", "party", "account_ref_id = {$account}");
$days_limit = getIVal("days_limit", "party", "account_ref_id = {$account}");
$aob = _getOpeningBalance($account, $date_start);
$pay = getPayments($account, $date_start, $date_end);
$balance = $aob - $pay;
if ($balance < 0) {
$balance = $balance * -1;
} else {
$balance = 0;
}
$sql = "" . "SELECT sa.invoice,\n" . " sa.remarks,\n" . " DATE_FORMAT(sa.sale_date, '%d-%b-%y') sale_date,\n" . " DATEDIFF(now(), sa.sale_date) days,\n" . " sa.net\n" . " FROM vu_sales_age sa\n" . " WHERE sa.party_code = {$party_hidden}\n" . " AND sa.company_ref_id = {$_SESSION['company_id']}\n";
if (strlen($date_start) > 0) {
$sql .= " AND TO_DAYS(sa.sale_date) >= TO_DAYS('" . my_sql_date($date_start) . "')\n";
}
if (strlen($date_end) > 0) {
$sql .= " AND TO_DAYS(sa.sale_date) <= TO_DAYS('" . my_sql_date($date_end) . "')\n";
}示例13: session_start
<?php
session_start();
include '../includes/connecti.php';
include '../includes/JSON.php';
include '../includes/funcs.inc.php';
$data = array();
$data['count'] = 0;
if (isset($_GET['start_date']) && isset($_GET['end_date']) && isset($_GET['id'])) {
$data['count'] = getIVal("count(*) cnt", "voucher_master vm", "(vm.voucher_date < '{$_GET['start_date']}' OR vm.voucher_date > '{$_GET['end_date']}') AND vm.year_id = {$_GET['id']}");
}
$json = new Services_JSON();
$output = $json->encode($data);
print $output;示例14: oci_parse
}
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'];
}
}
$ndata = array();
foreach ($accounts as $account) {
$party = getIVal("party_name", "party", "account_ref_id = {$account}");
$party_hidden = getIVal("party_code", "party", "account_ref_id = {$account}");
$days_limit = getIVal("days_limit", "party", "account_ref_id = {$account}");
$payment_term = getIVal("payment_term", "party", "account_ref_id = {$account}") * 1;
$aob = getInitialOpeningBalance($account);
$pay = getPayments($account, $date_start, $date_end, true);
$balance = $aob - $pay;
if ($balance < 0) {
$balance = $balance * -1;
} else {
$balance = 0;
}
$sql = "" . "SELECT sa.invoice, sa.seq,\n" . " sa.remarks,\n" . " DATE_FORMAT(sa.sale_date, '%d-%b-%y') sale_date,\n" . " DATEDIFF(now(), sa.sale_date) days,\n" . " sa.net\n" . " FROM vu_sales_age sa\n" . " WHERE sa.party_code = {$party_hidden}\n" . " AND sa.company_ref_id = {$_SESSION['company_id']}\n";
if (strlen($date_start) > 0) {
$sql .= " AND TO_DAYS(sa.sale_date) >= TO_DAYS('" . my_sql_date($date_start) . "')\n";
}
if (strlen($date_end) > 0) {
$sql .= " AND TO_DAYS(sa.sale_date) <= TO_DAYS('" . my_sql_date($date_end) . "')\n";
}示例15: getFinancialDate
function getFinancialDate($col, $year_id = "")
{
$where = "AND is_active = 'Yes'";
if ($year_id != "") {
$where = "AND year_id = {$year_id}";
}
return getIVal($col, "sys_financial_year", "company_ref_id = {$_SESSION['company_id']} {$where}");
}