PHP get_projectentry 예제들

예제 #1

파일: TSLIB_COMMON.php 프로젝트: Rajagunasekaran/TS

    return $active_nonemp;
}
function get_company_start_date()
{
    global $con;
    $comp_sdate = mysqli_query($con, "SELECT * from USER_RIGHTS_CONFIGURATION WHERE URC_ID=11");
    while ($row = mysqli_fetch_array($comp_sdate)) {
        $comp_startdate = $row["URC_DATA"];
    }
    $comp_startdate = date('d-m-Y', strtotime($comp_startdate));
    return $comp_startdate;
}
if ($_REQUEST["option"] == "admin_report_entry") {
    $get_permission_array = get_permission();
    $ure_uld_id = get_uldid();
    $get_project_array = get_projectentry($ure_uld_id);
    $error = '3,4,5,6,7,8,16,17,18,67,115,120,142';
    $error_array = get_error_msg($error);
    $min_date = get_joindate($ure_uld_id);
    $login_array = get_active_emp_id();
    //    $select_wfh=mysqli_query($con,"select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID=$ure_uld_id");
    //    while($row=mysqli_fetch_array($select_wfh))
    //    {
    //        $wfh_flag=$row['WFHA_FLAG'];
    //    }
    $values_array = array($get_permission_array, $get_project_array, $min_date, $error_array, $login_array, $wfh_flag);
    echo JSON_ENCODE($values_array);
}
if ($_REQUEST["option"] == "admin_search_update") {
    $get_permission_array = get_permission();
    $ure_uld_id = get_uldid();

예제 #2

파일: DB_DAILY_REPORTS_ADMIN_REPORT_ENTRY.php 프로젝트: Rajagunasekaran/TS

include "../TSLIB/TSLIB_GET_USERSTAMP.php";
include "../TSLIB/TSLIB_COMMON.php";
date_default_timezone_set('Asia/Kolkata');
$USERSTAMP = $UserStamp;
if ($_REQUEST["option"] == "login_id") {
    $ADM_uld_id = $_REQUEST['login_id'];
    $min_date = mysqli_query($con, "SELECT UA_JOIN_DATE FROM USER_ACCESS where ULD_ID='{$ADM_uld_id}' AND UA_TERMINATE IS NULL");
    while ($row = mysqli_fetch_array($min_date)) {
        $mindate_array = $row["UA_JOIN_DATE"];
        $min_date = date('d-m-Y', strtotime($mindate_array));
    }
    $select_wfh = mysqli_query($con, "select WFHA_FLAG from WORK_FROM_HOME_ACCESS where ULD_ID={$ADM_uld_id}");
    while ($row = mysqli_fetch_array($select_wfh)) {
        $wfh_flag = $row['WFHA_FLAG'];
    }
    $get_project_array = get_projectentry($ADM_uld_id);
    $finalvalue = array($min_date, $get_project_array, $wfh_flag);
    echo JSON_ENCODE($finalvalue);
}
if ($_REQUEST["option"] == "LOGINID") {
    $ADM_uld_id = $_REQUEST['login_id'];
    $min_date = mysqli_query($con, "SELECT UA_JOIN_DATE FROM USER_ACCESS where ULD_ID='{$ADM_uld_id}' AND UA_TERMINATE IS NULL");
    while ($row = mysqli_fetch_array($min_date)) {
        $mindate_array = $row["UA_JOIN_DATE"];
        $min_date = date('d-m-Y', strtotime($mindate_array));
    }
    echo $min_date;
}
if ($_REQUEST["option"] == "DATE") {
    $date = $_REQUEST['date_change'];
    $ADM_uld_id = $_REQUEST['login_id'];

예제 #3

파일: COMMON.php 프로젝트: Rajagunasekaran/BACKUP

}
function get_company_start_date(){

    global $con;
    $comp_sdate=mysqli_query($con,"SELECT * from USER_RIGHTS_CONFIGURATION WHERE URC_ID=11");
    while($row=mysqli_fetch_array($comp_sdate)){
        $comp_startdate=$row["URC_DATA"];
    }
    $comp_startdate = date('d-m-Y',strtotime($comp_startdate));
    return $comp_startdate;
}
if($_REQUEST["option"]=="admin_report_entry")
{
    $get_permission_array=get_permission();
    $ure_uld_id=get_uldid();
    $get_project_array=get_projectentry();
    $error='3,4,5,6,7,8,16,17,18,67,115,132,133';
    $error_array=get_error_msg($error);
    $min_date=get_joindate($ure_uld_id);
    $login_array=get_active_emp_id();
    $values_array=array($get_permission_array,$get_project_array,$min_date,$error_array,$login_array);
    echo JSON_ENCODE($values_array);
}
if($_REQUEST["option"]=="admin_search_update")
{
    $get_permission_array=get_permission();
    $ure_uld_id=get_uldid();
//    $get_project_array=get_project();
    $error='3,4,5,6,7,8,16,17,18,67,83,98,109,110,132,133';
    $error_array=get_error_msg($error);

예제 #4

파일: DB_DAILY_REPORTS_REPORT_ENTRY.php 프로젝트: Rajagunasekaran/BACKUP

    }
    echo json_encode($ure_date_array);
}
if($_REQUEST['option']=='PRESENT')
{
    $row=get_projectentry();
    if(count($row)!=0)
    {
        $flag=1;
    }
    else
    {
        $flag=0;
    }
    echo $flag;
}
if($_REQUEST['option']=='HALFDAYABSENT')
{
    $row=get_projectentry();
    if(count($row)!=0)
    {
        $flag=1;
    }
    else
    {
        $flag=0;
    }
    echo $flag;
}

?>