Esempio n. 1
0
<?php

$rptfls = array();
// $inetreportsfiles = (isset($sess_usertype_short) && (trim($sess_usertype_short)=='OA' || trim($sess_usertype_short)=='OU'))? $inetreportsfiles.'/adminrpt' : $inetreportsfiles.'/userrpt';
// $rptfiles = scandir(SPATH_ROOT.$inetreportsfiles);
if (!isset($rptReportsObj)) {
    include_once SITE_CLASS_APPLICATION . "class.RPTReports.php";
    $rptReportsObj = new RPTReports();
}
$rptfiles = $rptReportsObj->getDetails('*', " AND eType='{$sess_usertype_short}' AND eStatus='Active' ");
#echo $inetcorehome."===".$sess_usertype_short;pr($rptfiles); exit;
$prms = array();
$rptdesc = array();
if (is_array($rptfiles) && count($rptfiles) > 0) {
    $shoc = "none";
    $shuc = "none";
    //
    if ($sess_usertype_short == 'SM') {
        $orgcary = array("ID" => "promptorganization_id", "Name" => "promptorganization_id", "Type" => "Query", "tableName" => PRJ_DB_PREFIX . "_organization_master", "fieldId" => "iOrganizationID", "fieldName" => "vCompanyName", "extVal" => '', "selectedVal" => '', "width" => '230px', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_ORGANIZATION') . " ---", "where" => "eStatus ='Active' ", "multiple_select" => "", "orderby" => '', "extra" => "title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_ORGANIZATION') . "'", "validationmsg" => "", "class" => "required");
        $org_combo = $gdbobj->DynamicDropDown($orgcary);
        $org_combo = str_replace('"', '\\"', $org_combo);
        $org_combo = "<span class='porg' style='display:inline-block;'>" . $org_combo . "</span><span style='float:right; padding-right:70px;'>" . $smarty->get_template_vars('LBL_FILTER_LIST_BY') . " : <input type='text' name='orgfilter' id='orgfilter' style='width:100px;' /></span>";
        $shoc = '';
    } else {
        $org_combo = "<input type='text' name='promptorganization_id' id='promptorganization_id' class='required' value='" . $curORGID . "' />";
    }
    //
    if ($sess_usertype_short != 'OU') {
        $wh = '';
        if ($sess_usertype_short == 'OA') {
            $wh = "AND iOrganizationID = {$curORGID}";
Esempio n. 2
0
// $inetreportsfiles = (isset($sess_usertype_short) && (trim($sess_usertype_short)=='OA' || trim($sess_usertype_short)=='OU'))? $inetreportsfiles.'/adminrpt' : $inetreportsfiles.'/userrpt';
// $rptfiles = scandir(SPATH_ROOT.$inetreportsfiles);
if (!isset($rptReportsObj)) {
    include_once SITE_CLASS_APPLICATION . "class.RPTReports.php";
    $rptReportsObj = new RPTReports();
}
if (!isset($pursesordObj)) {
    include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
    $pursesordObj = new PurchaseOrderHeading();
}
if (!isset($invoiceObj)) {
    include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
    $invoiceObj = new InvoiceOrderHeading();
}
if ($parameter == "po") {
    $rptfiles = $rptReportsObj->getDetails('*', " AND eType='{$sess_usertype_short}' AND eStatus='Active' AND tParameters LIKE '%po_id%'");
} else {
    if ($parameter == "inv") {
        $rptfiles = $rptReportsObj->getDetails('*', " AND eType='{$sess_usertype_short}' AND eStatus='Active' AND tParameters LIKE '%invoice_id%'");
    } else {
        $rptfiles = $rptReportsObj->getDetails('*', " AND eType='{$sess_usertype_short}' AND eStatus='Active'");
    }
}
// pr($rptfiles);exit;
$iID = $_GET['id'];
$prms = array();
$rptdesc = array();
if (is_array($rptfiles) && count($rptfiles) > 0) {
    $shoc = "none";
    $shuc = "none";
    //