k_online_backend/include.ini.php

<?php

if (extension_loaded('zlib')) {
    ini_set('zlib.output_compression', 'On');
    ini_set('zlib.output_compression_level', '9');
}

if (!empty($_REQUEST['sessionid'])) {
    session_id($_REQUEST['sessionid']);
}
//error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);
error_reporting(0);
session_start();

ini_set("magic_quotes_runtime", 0);
define('IN_ONLINE', TRUE);
define('DS', DIRECTORY_SEPARATOR);
define('WEB_ROOT', str_replace(DS, '/', str_replace(str_replace("/", DS, $_SERVER['DOCUMENT_ROOT']), '', realpath(dirname(__FILE__)))));
define('ONLINE_ROOT', realpath(dirname(__FILE__)) . DS);
define('ADODB_PATH', ONLINE_ROOT . 'libs' . DS . 'ADOdb-5.20.17' . DS);
define('C_PATH', ONLINE_ROOT . 'service' . DS);
define('FILE_UPLOAD_PAHT', "upload" . DS);

// define('DOCUMENT_AIR_UPLOAD_PATH', "D:" . DS . "DOC_AIR" . DS);
// define('DOCUMENT_OCEAN_UPLOAD_PATH', "D:" . DS . "DOC" . DS);
// define('DOCUMENT_SFSAIR_UPLOAD_PATH', "D:" . DS . "DOC_AIR" . DS);
// define('DOCUMENT_SFSOCEAN_UPLOAD_PATH', "D:" . DS . "DOC" . DS);

define('DOCUMENT_AIR_UPLOAD_PATH', "/DOC_AIR" . DS);
define('DOCUMENT_OCEAN_UPLOAD_PATH', "/DOC" . DS);
define('DOCUMENT_SFSAIR_UPLOAD_PATH', "/DOC_AIR" . DS);
define('DOCUMENT_SFSOCEAN_UPLOAD_PATH', "/DOC" . DS);

if (preg_match("/(bot|crawl|spider|slurp)/i", $_SERVER['HTTP_USER_AGENT'])) {
    header('HTTP/1.1 403 Forbidden');
    exit;
}

if (function_exists("date_default_timezone_set") and function_exists("date_default_timezone_get"))
    @date_default_timezone_set(@date_default_timezone_get());

header('Content-type: text/html; Charset=utf-8');
include_once ADODB_PATH . 'toexport.inc.php';
include_once ADODB_PATH . 'adodb.inc.php';
include_once ONLINE_ROOT . 'libs' . DS . 'config.ini.php';
include_once ONLINE_ROOT . 'utils' . DS . 'utils.class.php';
include_once ONLINE_ROOT . 'utils' . DS . 'common.class.php';
include_once ONLINE_ROOT . 'utils' . DS . 'dms_edoc.class.php';
include_once ONLINE_ROOT . 'libs' . DS . 'phpXLSWriter' . DS . "xlsxwriter.class.php";


//测试服务器
if(utils::startWith($_SERVER["HTTP_HOST"],"online-beta.kln.com")){
    define('SERVER_PAHT', 'https://online-beta.kln.com/online_backend/');
    define('SERVER_Vue_PAHT', 'https://online-beta.kln.com/');
}elseif(utils::startWith($_SERVER["HTTP_HOST"],"online.kln.com")){
    define('SERVER_PAHT', 'https://online.kln.com/online_backend/');
    define('SERVER_Vue_PAHT', 'https://online.kln.com/');
}else{
    //本地测试demo
    define('SERVER_PAHT', 'http://192.168.0.161/Customer_Service_Online/');
    define('SERVER_Vue_PAHT', 'http://192.168.0.161/k_new_online/');
}

$tar = common::excuteObjectSql("select item_value from config where item='Current_Used_Company'");
if (!empty($tar["item_value"])&&$tar["item_value"]=="TOPOCEAN") {
    define("Soure", 'TopOcean');
}else{
    define("Soure", 'Apex');
}

function _isApexLogin() {
    return strtolower($_SESSION['ONLINE_USER']['user_type']) == "employee";
    //return false;
}

function _isAdmin() {
    return $_SESSION['ONLINE_USER']['is_super'] == 't';
}

function _isRevenueDisplay() {
    return $_SESSION['ONLINE_USER']['revenue_active'] == 't';
}

function _isDesensitizationKln() {
    return $_SESSION['ONLINE_USER']['is_desensitization_kln'] == 't';
}

function _isNewUser() {
    return _isCustomerLogin() && empty($_SESSION['ONLINE_USER']['permission']);
}

function _isCustomerLogin() {
    return strtolower($_SESSION['ONLINE_USER']['user_type']) == 'customer';
}

function _getLoginName() {
    return $_SESSION['ONLINE_USER']['user_login'];
}

function _getLoginEamil() {
    return $_SESSION['ONLINE_USER']['email'];
}

function _getLoginEmployeeEamil() {
    return $_SESSION['ONLINE_USER']['employee_email'];
}

function _isAdminHandNew($user) {
    return $user['is_super'] == 't';
}

function _canViewAMSLog($schemas = "public") {
    if ($schemas == "public") {
        return strtolower($_SESSION['ONLINE_USER']['can_see_amslog']) == 't' || _isAdmin();
    } else {
        return strtolower($_SESSION[$schemas . '_ONLINE_USER']['can_see_amslog']) == 't' || _isAdmin();
    }
}

function _canViewISFLog($schemas = "public") {
    if ($schemas == "public") {
        return strtolower($_SESSION['ONLINE_USER']['can_see_isflog']) == 't' || _isAdmin();
    } else {
        return strtolower($_SESSION[$schemas . '_ONLINE_USER']['can_see_isflog']) == 't' || _isAdmin();
    }
}

function _isDocAdmin($username) {
    return strtolower($username) == "doc.alice" || strtolower($username) == "apexdoc.admin" 
    || strtolower($username) == "doc.patty1"  || strtolower($username) == "maria" || strtolower($username) == "it.andywu" 
    || strtolower($username) == "doc.riley" || strtolower($username) == "doc.amy" || strtolower($username) == "doc.vicky" 
    || strtolower($username) == "doc.leah" || strtolower($username) == "doc.yuki" || strtolower($username) == "doc.yoyo";
}

function _isVipReportAdmin($username) {
    return strtolower($username) == "doc.alice" || strtolower($username) == "maria" 
           || strtolower($username) == "chud" || strtolower($username) == "doc.sansa1" 
           || strtolower($username) == "doc.tianna" || strtolower($username) == "it.andywu" 
           || strtolower($username) == "ra.admin" || strtolower($username) == "jon.walker@kln.com" 
           || strtolower($username) == "mark.szymanowski@kln.com" || strtolower($username) == "cynthia.sy.lee@kln.com";
}

function _customerFilerSearchHandNew($tableName,$user, $schemas = "public", $p = 'place_of_delivery', $s = 'shipper_id', $c = 'consignee_id', $b = 'billto_id', $n = 'notify_party_id', $d = 'port_of_discharge_code') {
    $tt = $user['customer_search_type'];
    $sales = $user['ocean_sales'];
    if (empty($tt)) {
        return "1<>1";
    }
    //error_log("_customerFilerSearchHandNew -- " . $schemas);
    $_contact_id = _getContactIDHandNew($user, $schemas);
    if (empty($_contact_id)) {
        return "1<>1";
    }
    $sqlWhere1 = "";
    if (utils::checkExist($tt, 's') && !empty($s)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($s) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($s) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'c') && !empty($c)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($c) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($c) " . common::getInNotInSql($_contact_id);
        }
    }
    //暂时注释掉，ocean_booking 没有这个字段
    // if (utils::checkExist($tt, 'b') && !empty($b)) {
    //     if (empty($sqlWhere1)) {
    //         $sqlWhere1 = " lower($b) " . common::getInNotInSql($_contact_id);
    //     } else {
    //         $sqlWhere1 .= " or lower($b) " . common::getInNotInSql($_contact_id);
    //     }
    // }
    if (utils::checkExist($tt, 'n') && !empty($n)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($n) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($n) " . common::getInNotInSql($_contact_id);
        }
    }

    //controlling_customer_code
    // if (utils::checkExist($tt, 't')) {
    //     if (empty($sqlWhere1)) {
    //         $sqlWhere1 = " exists(select 1 from $schemas.ocean_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)."  limit 1)";
    //     } else {
    //         $sqlWhere1 .= " or exists(select 1 from $schemas.ocean_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)." limit 1)";
    //     }
    // }
    if (utils::checkExist($tt, 't')) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower(customer_code) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower(customer_code) " . common::getInNotInSql($_contact_id);
        }
    }
    if (empty($sqlWhere1))
        return "1<>1";
    $sqlWhere1 = "(" . $sqlWhere1 . ")";

    if (!empty($user['customer_destination']) && !empty($p)) {
        $sqlWhere1 .= " and lower($p) " . common::getInNotInSql($user['customer_destination']);
    }

    if (!empty($user['customer_discharge']) && !empty($d)) {
        $sqlWhere1 .= " and lower($d) " . common::getInNotInSql($user['customer_discharge']);
    }

    if (strtolower($sales) == 'all' || empty($sales)) {
        
    } else {
        if (utils::checkExist($sales, ";")) {
            $sql = "1!=1";
            $tt = explode(";", $sales);
            foreach ($tt as $t) {
                $t = trim($t);
                if (!empty($t))
                    $sql .= " or sales_rep ilike '" . $t . "%'";
            }
            $sqlWhere1 .= " and ($sql)";
        } else
            $sqlWhere1 .= " and sales_rep ilike '" . $sales . "%'";
    }
    return $sqlWhere1;
}

function _getContactIDHandNew_Air($user, $schemas = "public") {
    $contact_id_user = _getCompanyContactHandNew_Air($user);
    $id = "";
    if ($schemas == "public") {
        $contact_id = common::excuteListSql("select contacts_id from " . $schemas . ".contacts_group_all where lower(company_name)  " . utils::getInSql(_getCompanyHandNew($user)));
    } else {
        $contact_id = common::excuteListSql("select contacts_id from " . $schemas . ".contacts_group_all where lower(company_name)  " . utils::getInSql(_getCompanyHandNew($user, $schemas)));
    }
    foreach ($contact_id as $v) {
        if (empty($id))
            $id = trim($v['contacts_id']);
        else
            $id .= ";" . $v['contacts_id'];
    }
    if (!empty($contact_id_user)) {
        $id .= ";" . $contact_id_user;
    }
    return $id;
}

function _getCompanyContactHandNew_Air($user, $schemas = "public") {
    if ($schemas == "public") {
        return $user['air_customers'];
    } else {
        return $user[$schemas . '_ONLINE_USER']['air_customers'];
    }
}

function _getCompanyHandNew($user, $schemas = "public") {
    if ($schemas == "public") {
        return $user['company'];
    } else {
        if (empty($user['company'])) {
            return $user['company_name'];
        } else {
            return $user['company'];
        }
    }
}

function _getContactIDHandNew($user, $schemas = "public") {
    $contact_id_user = _getCompanyContactHandNew($user);
    $id = "";
    if ($schemas == "public") {
        $contact_id = common::excuteListSql("select contacts_id from " . $schemas . ".contacts_group_all where lower(company_name)  " . utils::getInSql(_getCompanyHandNew($user)));
    } else {
        $contact_id = common::excuteListSql("select contacts_id from " . $schemas . ".contacts_group_all where lower(company_name)  " . utils::getInSql(_getCompanyHandNew($user, $schemas)));
    }
    foreach ($contact_id as $v) {
        if (empty($id))
            $id = trim($v['contacts_id']);
        else
            $id .= ";" . $v['contacts_id'];
    }
    if (!empty($contact_id_user)) {
        $id .= ";" . $contact_id_user;
    }
    return $id;
}

function _getCompanyContactHandNew($user, $schemas = "public") {
    if ($schemas == "public") {
        return $user['contact_id_user'];
    } else {
        return $user[$schemas . '_ONLINE_USER']['contact_id_user'];
    }
}

function _isDemo() {
    return $_SESSION['ONLINE_USER']['is_demo'] == "t";
}

function _is_only_vgm() {
    if ($_SESSION['ONLINE_USER']['is_only_vgm'] == "t") {
        return TRUE;
    }
    return FALSE;
}

function _get_schemas() {
    return $_SESSION['schemas_list'];
}

function _getViewDocType($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['view_doc_type'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['view_doc_type'];
    }
}

function _getAirViewDocType($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['view_air_doc_type'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['view_air_doc_type'];
    }
}

function _canEdiVgm($schemas = "public") {
    if ($schemas == "public") {
        return strtolower($_SESSION['ONLINE_USER']['can_edi_vgm']) == 't' || _isAdmin();
    } else {
        return strtolower($_SESSION[$schemas . '_ONLINE_USER']['can_edi_vgm']) == 't' || _isAdmin();
    }
}
function _getAirStation($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['air_station'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['air_station'];
    }
}

function _getAirStationOr($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['air_station_or'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['air_station_or'];
    }
}

function _getAirSales($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['air_sales'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['air_sales'];
    }
}

function _getAirSalesOr($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['air_sales_or'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['air_sales_or'];
    }
}

function _customerAirSearchType($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['air_customer_search_type'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['air_customer_search_type'];
    }
}

function _getAirContactID($schemas = "public") {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER']['air_customers'];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER']['air_customers'];
    }
}

function _customerAirFilerSearch($tableName,$schemas = "public", $s = 'shipper_id', $c = 'consignee_id', $b = 'billto_id', $n = 'notify_party_id') {
    $tt = _customerAirSearchType($schemas);
    if (empty($tt))
        return "1<>1";
    $_contact_id = _getAirContactID($schemas);
    if (empty($_contact_id)) {
        return "1<>1";
    }
    $sqlWhere1 = "";
    if (utils::checkExist($tt, 's') && !empty($s)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($s) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($s) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'c') && !empty($c)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($c) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($c) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'b') && !empty($b)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($b) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($b) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'n') && !empty($n)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($n) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($n) " . common::getInNotInSql($_contact_id);
        }
    }
    //controlling_customer_code
    // if (utils::checkExist($tt, 't')) {
    //     if (empty($sqlWhere1)) {
    //         $sqlWhere1 = " exists(select 1 from $schemas.air_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)."  limit 1)";
    //     } else {
    //         $sqlWhere1 .= " or exists(select 1 from $schemas.air_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)." limit 1)";
    //     }
    // }
    if (utils::checkExist($tt, 't')) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower(customer_code) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower(customer_code) " . common::getInNotInSql($_contact_id);
        }
    }
    if (empty($sqlWhere1))
        return "1<>1";
    $sqlWhere1 = "(" . $sqlWhere1 . ")";

    return $sqlWhere1;
}

/**
 * 员工的有关的group_name 和contact id 权限配置查询 ocean air 合并写
 * @return string sql
 */
function _employeeFilerSearch($tableName,$ocean_air,$contact_field,$group_name_field,$schemas = "public", $p = 'place_of_delivery', $s = 'shipper_id', $c = 'consignee_id', $b = 'billto_id', $n = 'notify_party_id', $d = 'port_of_discharge_code'){
    if($ocean_air == "ocean"){
        $tt = _employeeSearchType($schemas,"employee_search_type");
    }else{
        $tt = _employeeSearchType($schemas,"employee_air_search_type");
    }
    if (empty($tt))
        return "1<>1";
    $_contact_id = _getEmployeeContactID($schemas,$contact_field,$group_name_field);
    if (empty($_contact_id)) {
        return "1<>1";
    }
    $sqlWhere1 = "";
    if (utils::checkExist($tt, 's') && !empty($s)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($s) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($s) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'c') && !empty($c)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($c) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($c) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'b') && !empty($b)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($b) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($b) " . common::getInNotInSql($_contact_id);
        }
    }
    if (utils::checkExist($tt, 'n') && !empty($n)) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower($n) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower($n) " . common::getInNotInSql($_contact_id);
        }
    }
    //controlling_customer_code
    // if($ocean_air == "ocean"){
    //     if (utils::checkExist($tt, 't')) {
    //         if (empty($sqlWhere1)) {
    //             $sqlWhere1 = " exists(select 1 from $schemas.ocean_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)."  limit 1)";
    //         } else {
    //             $sqlWhere1 .= " or exists(select 1 from $schemas.ocean_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)." limit 1)";
    //         }
    //     }
    // }else{
    //     if (utils::checkExist($tt, 't')) {
    //         if (empty($sqlWhere1)) {
    //             $sqlWhere1 = " exists(select 1 from $schemas.air_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)."  limit 1)";
    //         } else {
    //             $sqlWhere1 .= " or exists(select 1 from $schemas.air_extend ex where ex.serial_no = ".$tableName.".serial_no and lower(ex.customer_code) " . common::getInNotInSql($_contact_id)." limit 1)";
    //         }
    //     }
    // }
    if (utils::checkExist($tt, 't')) {
        if (empty($sqlWhere1)) {
            $sqlWhere1 = " lower(customer_code) " . common::getInNotInSql($_contact_id);
        } else {
            $sqlWhere1 .= " or lower(customer_code) " . common::getInNotInSql($_contact_id);
        }
    }
    if (empty($sqlWhere1))
        return "1<>1";
    return $sqlWhere1 = "(" . $sqlWhere1 . ")";
}


function _isCustomerLoginHandNew($user) {
    return strtolower($user["user_type"]) == 'customer';
}

function _employeeSearchType($schemas = "public",$filed) {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER'][$filed];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER'][$filed];
    }
}

function _getEmployeeContactID($schemas = "public",$contact_field,$group_name_field) {
    if(!empty($contact_field)){
       $contact_id_user = _getEmployeeCompanyContact($schemas,$contact_field); 
    }
    $id = "";
    if(!empty(_getEmployeeCompany($schemas,$group_name_field))){
        if ($schemas == "public") {
            $contact_id = common::excuteListSql("select contacts_id from " . $schemas . ".contacts_group_all where lower(company_name)  " . utils::getInSql(_getEmployeeCompany($schemas,$group_name_field)));
        } else {
            $contact_id = common::excuteListSql("select contacts_id from " . $schemas . ".contacts_group_all where lower(company_name)  " . utils::getInSql(_getEmployeeCompany($schemas,$group_name_field)));
        }
    }
    foreach ($contact_id as $v) {
        if (empty($id))
            $id = trim($v['contacts_id']);
        else
            $id .= ";" . $v['contacts_id'];
    }
    if (!empty($contact_id_user)) {
        $id .= ";" . $contact_id_user;
    }
    return $id;
}

function _getEmployeeCompanyContact($schemas = "public",$contact_field) {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER'][$contact_field];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER'][$contact_field];
    }
}

function _getEmployeeCompany($schemas = "public",$group_name_field) {
    if ($schemas == "public") {
        return $_SESSION['ONLINE_USER'][$group_name_field];
    } else {
        return $_SESSION[$schemas . '_ONLINE_USER'][$group_name_field];
    }
}
?>