示例#1
0
文件: 1.php 项目: Nvenom/Cellwiz
 public static function FORMAT($S, $R, $P)
 {
     $I = array();
     if ($P === false) {
         $I[] = STR_REPLACE("/", "-", $R) . " 00:00:00";
         $I[] = STR_REPLACE("/", "-", $R) . " 24:59:59";
         $SET = 'HOUR';
     } else {
         $R = explode(" - ", $R);
         $I[] = STR_REPLACE("/", "-", $R[0]);
         $I[] = STR_REPLACE("/", "-", $R[1]);
         $SET = 'DAY';
     }
     $I[] = $S['s_id'];
     $Q = "SELECT MIN(t_checkout_created) AS `time`, AVG(t_checkout_price) AS `cost` FROM core_tickets_processed WHERE t_checkout_created >= ? AND t_checkout_created <= ? AND t_store = ? GROUP BY";
     $CA = MYSQL::QUERY($Q . " {$SET}(t_checkout_created) ORDER BY t_checkout_created ASC", $I);
     $CO = MYSQL::QUERY($Q . " t_checkout_created ORDER BY t_checkout_created ASC", $I);
     $STRING = array();
     $STRING[] = array('name' => 'Average Charge', 'data' => '');
     $STRING[] = array('name' => 'Checkout Charges', 'data' => '');
     foreach ($CA as $C) {
         $T = Date_UTC($C['time']);
         $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $T[3] . "," . $C['cost'];
     }
     foreach ($CO as $C) {
         $T = Date_UTC($C['time']);
         $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $T[3] . "," . $T[4] . "," . $C['cost'];
     }
     echo JSON_ENCODE($STRING);
 }
function showData($data, $con)
{
    $date = $con->real_escape_string($data['startdate']);
    $startdate = $_REQUEST['startdate'];
    $startdate = date("Y-m-d", strtotime($startdate));
    $enddate = $_REQUEST['enddate'];
    //    $date = $con->real_escape_string($data['enddate']);
    $enddate = date("Y-m-d", strtotime($enddate));
    $AWSU_values = array();
    $sql = "SELECT AW.AWRD_ID,AW.AWRD_REPORT,AW.AWRD_DATE,DATE_FORMAT(CONVERT_TZ(AW.AWRD_TIMESTAMP,'+00:00','+05:30'), '%d-%m-%Y %T') AS AWRD_TIMESTAMP,ULD.ULD_LOGINID as ULD_USERSTAMP FROM ADMIN_WEEKLY_REPORT_DETAILS AW JOIN USER_LOGIN_DETAILS ULD on AW.ULD_ID=ULD.ULD_ID  where AW.AWRD_DATE BETWEEN '{$startdate}' AND '{$enddate}' ORDER BY AWRD_DATE DESC";
    $projectfetch = mysqli_query($con, $sql);
    $AWSU_values = false;
    while ($row = mysqli_fetch_array($projectfetch)) {
        $awsu_report = $row['AWRD_REPORT'];
        if ($awsu_report != null) {
            $awsu_rprt = '';
            $body_msg = explode("\n", $awsu_report);
            $length = count($body_msg);
            for ($i = 0; $i < $length; $i++) {
                $awsu_rprt .= $body_msg[$i] . '<br>';
            }
        } else {
            $awsu_rprt = null;
        }
        $awsu_id = $row['AWRD_ID'];
        $awsu_date = $row['AWRD_DATE'];
        $awsu_userstamp = $row["ULD_USERSTAMP"];
        $awsu_timestamp = $row["AWRD_TIMESTAMP"];
        $AWSU_report_values = array('report' => $awsu_rprt, 'report1' => $awsu_report, 'id' => $awsu_id, 'date' => $awsu_date, 'userstamp' => $awsu_userstamp, 'timestamp' => $awsu_timestamp);
        $AWSU_values[] = $AWSU_report_values;
    }
    echo JSON_ENCODE($AWSU_values);
}
示例#3
0
文件: 2.php 项目: Nvenom/Cellwiz
 public static function FORMAT($S, $R, $P)
 {
     $I = array($S['s_id']);
     if ($P === false) {
         $TI = "AND d_date = ? LIMIT 1";
         $I[] = str_replace("/", "-", $R);
     } else {
         $R = explode(" - ", $R);
         $TI = "AND d_date >= ? AND d_date <= ? ORDER BY d_date ASC";
         $I[] = str_replace("/", "-", $R[0]);
         $I[] = str_replace("/", "-", $R[1]);
     }
     $CT = MYSQL::QUERY("SELECT * FROM core_stores_daily_checkouts WHERE s_id = ? {$TI}", $I);
     $STRING = array(array('name' => 'Sales', 'data' => ''));
     if (!$P === false) {
         foreach ($CT as $CL) {
             $T = Date_UTC($CL['d_date']);
             $Total = $CL['d_gross_nontaxable'] + $CL['d_gross_taxable'];
             $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $Total;
         }
     } else {
         $T = Date_UTC($CT['d_date']);
         $Total = $CT['d_gross_nontaxable'] + $CT['d_gross_taxable'];
         $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $Total;
     }
     if ($P === false) {
         $STRING[0]['type'] = 'column';
     }
     echo JSON_ENCODE($STRING);
 }
示例#4
0
 function productsUpdateAction(Request $request, Application $app)
 {
     $em = $app['orm.em'];
     $categoryRepository = $em->getRepository('Category');
     $categories = $categoryRepository->findAll();
     $categoriesPresentation = array();
     foreach ($categories as $category) {
         $keys = $category->getItems()->getKeys();
         array_push($categoriesPresentation, array('id' => $category->getId(), 'title' => $category->getTitle(), 'summary' => $category->getSummary(), 'photo' => $category->getItems()->get(array_rand($keys))->getPhoto()));
     }
     return JSON_ENCODE($categoriesPresentation);
 }
示例#5
0
文件: 4.php 项目: Nvenom/Cellwiz
 public static function FORMAT($S, $R, $P)
 {
     $I = array($S['s_id']);
     if ($P === false) {
         $TI = "AND d_date = ? LIMIT 1";
         $I[] = str_replace("/", "-", $R);
     } else {
         $R = explode(" - ", $R);
         $TI = "AND d_date >= ? AND d_date <= ? ORDER BY d_date ASC";
         $I[] = str_replace("/", "-", $R[0]);
         $I[] = str_replace("/", "-", $R[1]);
     }
     $CT = MYSQL::QUERY("SELECT * FROM core_stores_daily_checkouts WHERE s_id = ? {$TI}", $I);
     $STRING = array(array('name' => 'Cash', 'data' => ''), array('name' => 'Check', 'data' => ''), array('name' => 'American Express', 'data' => ''), array('name' => 'Discover', 'data' => ''), array('name' => 'Master Card', 'data' => ''), array('name' => 'Visa', 'data' => ''), array('name' => 'Debit', 'data' => ''));
     if (!$P === false) {
         foreach ($CT as $CL) {
             $T = Date_UTC($CL['d_date']);
             $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_cash'];
             $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_check'];
             $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_amex'];
             $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_discover'];
             $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_master'];
             $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_visa'];
             $STRING[6]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_debit'];
         }
     } else {
         $T = Date_UTC($CT['d_date']);
         $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_cash'];
         $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_check'];
         $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_amex'];
         $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_discover'];
         $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_master'];
         $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_visa'];
         $STRING[6]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_debit'];
     }
     if ($P === false) {
         $STRING[0]['type'] = 'column';
         $STRING[1]['type'] = 'column';
         $STRING[2]['type'] = 'column';
         $STRING[3]['type'] = 'column';
         $STRING[4]['type'] = 'column';
         $STRING[5]['type'] = 'column';
         $STRING[6]['type'] = 'column';
     }
     echo JSON_ENCODE($STRING);
 }
        $menunameradiovalues = $_GET['radio_value'];
        $URSRC_basic_roleval=str_replace("_"," ",$menunameradiovalues);
        $URSRC_getmenu_folder_values=URSRC_getmenu_folder($URSRC_basic_roleval);
        echo JSON_ENCODE($URSRC_getmenu_folder_values);
    }
    //FUNCTION to get basic menus
    if($_REQUEST['option']=="URSRC_tree_view_basic"){
        $menunameradiovalues = $_GET['radio_value'];
        $URSRC_basic_roleval=str_replace("_"," ",$menunameradiovalues);
        $URSRC_getmenu_folder_values=URSRC_getmenubasic_folder1();
        echo JSON_ENCODE($URSRC_getmenu_folder_values);
    }
    //FUNCTION TO LOAD INITIAL VALUES ROLE LST bX
    if($_REQUEST['option']=="ACCESS_RIGHTS_SEARCH_UPDATE_BASICROLE"){
        $URSRC_role_array=get_roles();
        echo JSON_ENCODE($URSRC_role_array);
    }
}
//
////function URSRC_unshare_document($loggin,$fileId){
////
////    global $con,$ClientId,$ClientSecret,$RedirectUri,$DriveScopes,$CalenderScopes,$Refresh_Token;
////    $drive = new Google_Client();
////    $drive->setClientId($ClientId);
////    $drive->setClientSecret($ClientSecret);
////    $drive->setRedirectUri($RedirectUri);
////    $drive->setScopes(array($DriveScopes,$CalenderScopes));
////    $drive->setAccessType('online');
////    $authUrl = $drive->createAuthUrl();
////    $refresh_token= $Refresh_Token;
////    $drive->refreshToken($refresh_token);
示例#7
0
        $admin_searchmin_date_value = $row["AWRD_DATE"];
        //        $min_date = date('d-m-Y',strtotime($admin_searchmin_date_value));
        $min_date = date('Y-m-d', strtotime($admin_searchmin_date_value));
    }
    $admin_weekly_maxdate = mysqli_query($con, "SELECT MAX(AWRD_DATE) as AWRD_DATE FROM ADMIN_WEEKLY_REPORT_DETAILS");
    while ($row = mysqli_fetch_array($admin_weekly_maxdate)) {
        $admin_searchmin_date_value = $row["AWRD_DATE"];
        //        $max_date = date('d-m-Y',strtotime($admin_searchmin_date_value));
        $max_date = date('Y-m-d', strtotime($admin_searchmin_date_value));
        date_default_timezone_set('Asia/Kolkata');
        $a_date = $admin_searchmin_date_value;
        $date = new DateTime($a_date);
        $date->modify('last day of this month');
        $date = $date->format('d');
    }
    $value_array = array($errormsg_array, $min_date, $max_date, $date);
    echo JSON_ENCODE($value_array);
}
if ($_REQUEST['option'] == "ADMIN WEEKLY REPORT ENTRY") {
    $str = '3,7,84';
    $errormsg_array = get_error_msg($str);
    $comp_startdate = get_company_start_date();
    $value_array = array($errormsg_array, $comp_startdate);
    echo JSON_ENCODE($value_array);
}
if ($_REQUEST["option"] == "PUBLIC_HOLIDAY") {
    $error = '71,93,94,96';
    $error_array = get_error_msg($error);
    $values_array = array($error_array);
    echo JSON_ENCODE($values_array);
}
示例#8
0
文件: 0.php 项目: Nvenom/Cellwiz
 public static function FORMAT($S, $R, $P)
 {
     $I = array($S['s_id']);
     if ($P === false) {
         $TI = "AND d_date = ? LIMIT 1";
         $I[] = str_replace("/", "-", $R);
     } else {
         $R = explode(" - ", $R);
         $TI = "AND d_date >= ? AND d_date <= ? ORDER BY d_date ASC";
         $I[] = str_replace("/", "-", $R[0]);
         $I[] = str_replace("/", "-", $R[1]);
     }
     $CT = MYSQL::QUERY("SELECT * FROM core_stores_daily_tickets WHERE s_id = ? {$TI}", $I);
     $AE = MYSQL::QUERY("SELECT * FROM core_stores_daily_accepts WHERE s_id = ? {$TI}", $I);
     $WT = MYSQL::QUERY("SELECT * FROM core_stores_daily_walkouts WHERE s_id = ? {$TI}", $I);
     $CD = MYSQL::QUERY("SELECT * FROM core_stores_daily_checkouts WHERE s_id = ? {$TI}", $I);
     $RD = MYSQL::QUERY("SELECT * FROM core_stores_daily_repairs WHERE s_id = ? {$TI}", $I);
     $CC = MYSQL::QUERY("SELECT * FROM core_stores_daily_customers WHERE s_id = ? {$TI}", $I);
     $STRING = array(array('name' => 'Created Tickets', 'data' => ''), array('name' => 'Accepted Estimates', 'data' => ''), array('name' => 'Walked Out Tickets', 'data' => ''), array('name' => 'Checked Out Tickets', 'data' => ''), array('name' => 'Repaired Devices', 'data' => ''), array('name' => 'Customer Accounts Created', 'data' => ''));
     if (!$P === false) {
         foreach ($CT as $CL) {
             $T = Date_UTC($CL['d_date']);
             $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CL['d_key'];
         }
         foreach ($AE as $A) {
             $T = Date_UTC($A['d_date']);
             $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $A['d_key'];
         }
         foreach ($WT as $W) {
             $T = Date_UTC($W['d_date']);
             $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $W['d_key'];
         }
         foreach ($CD as $C) {
             $T = Date_UTC($C['d_date']);
             $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $C['d_key'];
         }
         foreach ($RD as $R) {
             $T = Date_UTC($R['d_date']);
             $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $R['d_key'];
         }
         foreach ($CC as $C) {
             $T = Date_UTC($C['d_date']);
             $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $C['d_key'];
         }
     } else {
         $T = Date_UTC($CT['d_date']);
         $STRING[0]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CT['d_key'];
         $STRING[1]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $AE['d_key'];
         $STRING[2]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $WT['d_key'];
         $STRING[3]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CD['d_key'];
         $STRING[4]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $RD['d_key'];
         $STRING[5]['data'][] .= $T[0] . "," . $T[1] . "," . $T[2] . "," . $CC['d_key'];
     }
     if ($P === false) {
         $STRING[0]['type'] = 'column';
         $STRING[1]['type'] = 'column';
         $STRING[2]['type'] = 'column';
         $STRING[3]['type'] = 'column';
         $STRING[4]['type'] = 'column';
         $STRING[5]['type'] = 'column';
     }
     echo JSON_ENCODE($STRING);
 }
示例#9
0
 function getImages()
 {
     if (isset($_POST["ObjectId"])) {
         $images = Resources::getImage($_POST["ObjectId"]);
         for ($i = 0; $i < count($images); $i++) {
             $images[$i]["ImageBlob"] = base64_encode($images[$i]["ImageBlob"]);
         }
         $object = new stdClass();
         $object->Images = $images;
         echo JSON_ENCODE($this->utf8ize($object));
     }
 }
示例#10
0
文件: index.php 项目: surger/carvin
 protected function actionList()
 {
     if (count($this->routes) > 0) {
         $id = array_shift($this->routes);
         $file = $this->dir . $id . self::jsonExtension;
         if (is_file($file)) {
             return file_get_contents($file);
         }
         return notFound();
     }
     $page = (int) $this->get(self::getPage, 1);
     if ($page == 0) {
         $page = 1;
     }
     $start = ($page - 1) * self::pageSize;
     $end = $start + self::pageSize;
     $items = [];
     $c = 0;
     $this->readDirectory(function ($file) use(&$c, &$items, $start, $end) {
         if ($c >= $start && $c < $end) {
             $items[] = json_decode(file_get_contents($this->dir . $file), true);
         }
         $c++;
     });
     header('Content-type: text/json');
     return JSON_ENCODE(['items' => $items, '_meta' => ['page' => $page, 'total' => $c, 'pages' => ceil($c / self::pageSize)]]);
 }
示例#11
0
            }
        } else {
            $checkintime = null;
        }
        $checkouttime = mysqli_query($con, "select ECIOD_CHECK_OUT_TIME from EMPLOYEE_CHECK_IN_OUT_DETAILS where ECIOD_DATE='{$date}' and ULD_ID='{$ADM_userstamp_id}'");
        $checkoutrow = mysqli_num_rows($checkouttime);
        if ($checkoutrow > 0) {
            if ($checkoutrow = mysqli_fetch_array($checkouttime)) {
                $check_out_time = $checkoutrow["ECIOD_CHECK_OUT_TIME"];
            }
        } else {
            $check_out_time = null;
        }
        $allvalues = array($final_values, $checkintime, $err_msg, $date, $check_out_time, $login_id_role, $ip_check_flag);
        //    mysqli_close($con);
        echo JSON_ENCODE($allvalues);
    } catch (mysqli_sql_exception $e) {
        echo $e->getMessage();
    }
} else {
    if ($_REQUEST['option'] == 'CLOCK') {
        global $con;
        $check_in_out_location = $_REQUEST['location'];
        $btn_value = $_REQUEST['btn_value'];
        $date = date('Y-m-d');
        $checkintime = date("G:i:s", time());
        $checkouttime = date("G:i:s", time());
        $uld_id = mysqli_query($con, "select ULD_ID from USER_LOGIN_DETAILS where ULD_LOGINID='{$USERSTAMP}'");
        while ($row = mysqli_fetch_array($uld_id)) {
            $ure_uld_id = $row["ULD_ID"];
        }
}
if($_REQUEST['option']=="search")
{
    $loginid=$_REQUEST['empid'];
    $uld_id=mysqli_query($con,"select ULD_ID from VW_TS_ALL_EMPLOYEE_DETAILS where EMPLOYEE_NAME='$loginid'");
    while($row=mysqli_fetch_array($uld_id)){
        $TH_uld_id=$row["ULD_ID"];
    }
    $result = $con->query("CALL SP_TS_USER_ADMIN_REPORT_DETAILS_TICKLER_DATA('$TH_uld_id','$USERSTAMP',@TEMP_UARD_TICKLER_HISTORY)");
    if(!$result) die("CALL failed: (" . $con->errno . ") " . $con->error);
    $select = $con->query('SELECT @TEMP_UARD_TICKLER_HISTORY');
    $result = $select->fetch_assoc();
    $temp_tickler_history= $result['@TEMP_UARD_TICKLER_HISTORY'];
    $TH_values=array();
    $sqlquery=mysqli_query($con,"SELECT EVENT_TYPE,TABLE_NAME,TH_OLD_VALUE,TH_NEW_VALUE,TH_USERSTAMP,DATE_FORMAT(CONVERT_TZ(TH_TIMESTAMP,'+00:00','+08:00'),'%d-%m-%Y %T') AS T_TIMESTAMP FROM $temp_tickler_history ORDER BY TH_TIMESTAMP DESC ");
    while($row=mysqli_fetch_array($sqlquery)){
        $TH_eventtype=$row["EVENT_TYPE"];
        $TH_tblename=$row["TABLE_NAME"];
        $TH_oldvalue=$row['TH_OLD_VALUE'];
        $TH_oldvalue=htmlspecialchars($TH_oldvalue);
        $TH_newvalue=$row['TH_NEW_VALUE'];
        $TH_newvalue=htmlspecialchars($TH_newvalue);
        $TH_userstamp=$row['TH_USERSTAMP'];
        $TH_timestamp=$row['T_TIMESTAMP'];
        $TH_values[]=(object)['tptype'=>$TH_eventtype,'ttipdata'=>$TH_tblename,'oldvalue'=>$TH_oldvalue,'newvalue'=>$TH_newvalue,'userstamp'=>$TH_userstamp,'timestamp'=>$TH_timestamp];
    }
    $drop_query="DROP TABLE $temp_tickler_history ";
    mysqli_query($con,$drop_query);
    echo JSON_ENCODE($TH_values);
}
?>
示例#13
0
    while ($row = mysqli_fetch_array($URSRC_select_basicrole_result)) {
        $URSRC_basicrole = $row["URC_DATA"];
    }
    $URSRC_basicroleid_array_result = mysqli_query($con, "select * from LMC_USER_RIGHTS_CONFIGURATION URC,LMC_BASIC_ROLE_PROFILE BRP where URC.URC_DATA='" . $URSRC_basicrole . "' and URC.URC_ID=BRP.URC_ID");
    $URSRC_basicroleid_array = array();
    while ($row = mysqli_fetch_array($URSRC_basicroleid_array_result)) {
        $URSRC_basicroleid_array[] = $row["BRP_BR_ID"];
    }
    $get_URSRC_basicrole_profile_array = array();
    for ($i = 0; $i < count($URSRC_basicroleid_array); $i++) {
        $URSRC_basicrole_profile_array_result = mysqli_query($con, "select * from LMC_USER_RIGHTS_CONFIGURATION URC,LMC_BASIC_ROLE_PROFILE BRP where  BRP.BRP_BR_ID=URC.URC_ID and BRP.BRP_BR_ID='" . $URSRC_basicroleid_array[$i] . "' order by URC_DATA asc ");
        while ($row = mysqli_fetch_array($URSRC_basicrole_profile_array_result)) {
            $get_URSRC_basicrole_profile_array[] = $row["URC_DATA"];
        }
    }
    $get_URSRC_basicrole_profile_array = array_values(array_unique($get_URSRC_basicrole_profile_array));
    $comp_startdate = get_company_start_date();
    $value_array = array($get_rolecreation_array, $get_project_array, $get_menuname_array, $get_URSRC_basicrole_profile_array, $URSRC_errmsg, $get_emptype_array, $comp_startdate, $get_team_array);
    echo JSON_ENCODE($value_array);
}
if ($_REQUEST["option"] == "EMAIL_TEMPLATE_ENTRY") {
    $error = '71,85,86';
    $error_array = get_error_msg($error);
    $values_array = array($error_array);
    echo JSON_ENCODE($values_array);
}
if ($_REQUEST["option"] == "RESET_FORM") {
    $str = '20,138,139';
    $URSRC_errmsg = get_error_msg($str);
    echo JSON_ENCODE($URSRC_errmsg);
}
    if($_REQUEST['option']=="CLK_loginid_searchoption")
    {
//        $CLK_loginid=$_REQUEST['CLK_loginid'];
        $CLK_mnthyrval=$_REQUEST['CLK_monthyear'];
//        echo $CLK_mnthyrval;
//        $CLK_start_value = date('Y-m-d',strtotime($CLK_mnthyrval));
        $final_start=date('Y-m-01', strtotime($CLK_mnthyrval));
//        echo $final_start;
        $final_end=date('Y-m-t', strtotime($CLK_mnthyrval));
//        echo $final_end;
//        echo "SELECT COUNT(*) AS CLOCK_OUTMISSED  FROM EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE  ECIOD_DATE BETWEEN '$final_start' AND '$final_end' AND ECIOD_CHECK_OUT_LOCATION IS NULL AND ULD_ID='$CLK_loginid'";
        $CLK_flextbl= mysqli_query($con,"SELECT DATE_FORMAT(ECIOD_DATE,'%d-%m-%Y') AS ECIOD_DATE FROM EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE  ECIOD_DATE BETWEEN '$final_start' AND '$final_end' AND ECIOD_FLAG='X' AND ULD_ID='$uld_id'");
        $CLK_COUNT= mysqli_query($con,"SELECT COUNT(*) AS CLOCK_OUTMISSED FROM EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE  ECIOD_DATE BETWEEN '$final_start' AND '$final_end' AND ECIOD_FLAG='X' AND ULD_ID='$uld_id'");

        $CLK_values=array();
        $ET_count_values=array();
        while($row=mysqli_fetch_array($CLK_flextbl)){
            $CLK_count=$row["ECIOD_DATE"];
            $final_values=(object) ['date'=>$CLK_count];
            $CLK_values[]=$final_values;
        }
        while($row=mysqli_fetch_array($CLK_COUNT)){
            $CLK_missedcount=$row["CLOCK_OUTMISSED"];
            $final_values_count=(object) ['count'=>$CLK_missedcount];
            $ET_count_values[]=$final_values_count;
        }
        $variable=array($CLK_values,$ET_count_values);
        echo JSON_ENCODE($variable);
    }

}
    //    }
    $fromdate = date('Y-m-d', strtotime($fdate));
    $todate = date('Y-m-d', strtotime($tdate));
    $ure_date_array = array();
    if ($ADM_uld_id != 'SELECT') {
        $sql = mysqli_query($con, "SELECT DISTINCT DATE_FORMAT(UARD_DATE,'%d-%m-%Y') AS UARD_DATE FROM USER_ADMIN_REPORT_DETAILS WHERE UARD_DATE BETWEEN '{$fromdate}' AND '{$todate}' AND ULD_ID={$ADM_uld_id} ORDER BY UARD_DATE");
        while ($row = mysqli_fetch_array($sql)) {
            $ure_date_array[] = $row["UARD_DATE"];
        }
    } else {
        $sql = mysqli_query($con, "SELECT DISTINCT DATE_FORMAT(UARD_DATE,'%d-%m-%Y') AS UARD_DATE FROM USER_ADMIN_REPORT_DETAILS WHERE UARD_DATE BETWEEN '{$fromdate}' AND '{$todate}'  ORDER BY UARD_DATE");
        while ($row = mysqli_fetch_array($sql)) {
            $ure_date_array[] = $row["UARD_DATE"];
        }
    }
    echo JSON_ENCODE($ure_date_array);
}
if ($_REQUEST['option'] == 'ALLEMPDATE') {
    $mindate = mysqli_query($con, "SELECT MIN(UARD_DATE) as UARD_DATE FROM USER_ADMIN_REPORT_DETAILS ORDER BY UARD_DATE");
    while ($row = mysqli_fetch_array($mindate)) {
        $allmindate = $row["UARD_DATE"];
    }
    $allmindate = date('d-m-Y', strtotime($allmindate));
    echo $allmindate;
}
if ($_REQUEST['option'] == 'PRESENT') {
    $emptyflag = 0;
    $rprtdate = $_REQUEST['reportdate'];
    $ure_uld_id = $_REQUEST['loginid'];
    $rprtdate = date('Y-m-d', strtotime($rprtdate));
    $uld_id = mysqli_query($con, "select ULD_LOGINID from USER_LOGIN_DETAILS where ULD_ID='{$ure_uld_id}'");
示例#16
0
*/
if ($_GET['mode'] == 'load') {
    //Load a file
    $send_data = array();
    $j = 0;
    for ($i = 0; $i < count($formats); $i++) {
        if ($formats[$i] != 'deleted') {
            if ($formats[$i]['owner'] == unserialize($_COOKIE['MALSIG_LOGIN'])['username']) {
                $send_data[$j] = $formats[$i];
                $send_data[$j]['id'] = $i;
                $j++;
            }
        }
    }
    //$data = file_GET_contents('../raw/files/' . $_POST['id'] . '.' . $formats[$_POST['id']]['format']); //Grab the file contents
    echo JSON_ENCODE($send_data);
    //Feed them back to the other file
} else {
    if ($_GET['mode'] == 'new') {
        //Save a new image
        $number = count($formats);
        //New id
        if (isset($_FILES["file"])) {
            //Filter the file types , if you want.
            if ($_FILES["file"]["error"] > 0) {
                die("Error: " . $_FILES["file"]["error"]);
            } else {
                move_uploaded_file($_FILES["file"]["tmp_name"], $output_dir . $number . '.' . array_pop(explode('.', $_FILES["file"]["name"])));
                //echo "Uploaded File :".$_FILES["file"]["name"];
                $formats[$number] = array('title' => $_FILES["file"]["name"], 'owner' => unserialize($_COOKIE['MALSIG_LOGIN'])['username']);
                $serializeFormats = base64_encode(serialize($formats));
示例#17
0
            <br>
            <?php 
$cor = array('Amarelo', 'Azul', 'Verde');
foreach ($cor as $valor) {
    echo $valor . '<br>';
}
foreach ($cor as $chave => $valor) {
    echo $chave . ' - ' . $valor . '<br>';
}
?>
            Uso de JSON
            <br>

            <?php 
$aAlunos = array(array('nome' => 'Marcos', 'notas' => array(8, 9, 7)), array('nome' => 'Maria', 'notas' => array(8, 10, 7)));
$sJSON = JSON_ENCODE($aAlunos);
echo $sJSON;
echo "<pre>" . print_r($sJSON, true) . "</pre>";
//[{"nome":"Marcos","notas":[8,9,7]},{"nome":"Maria","notas":[8,10,7]}]
?>
            Decodificando o JSON
            <br>
            <?php 
$sJSON = '[{"nome":"Marcos","notas":[8,9,7]},{"nome":"Maria","notas":[8,10,7]}] ';
//Usa o DECODE
$aAlunos = JSON_DECODE($sJSON, true);
foreach ($aAlunos as $valor) {
    echo $valor['nome'] . ':';
    echo implode($valor['notas'], ',') . '<br>';
}
?>
        $REP_values = array();
        while ($row = mysqli_fetch_array($REP_flextbl)) {
            $check_in_time = $row["ECIOD_CHECK_IN_TIME"];
            $check_in_location = $row["ECIOD_CHECK_IN_LOCATION"];
            $check_out_time = $row["ECIOD_CHECK_OUT_TIME"];
            $check_out_location = $row["ECIOD_CHECK_OUT_LOCATION"];
            $check_in_date = $row["E_ECIOD_DATE"];
            $final_values = array('check_in_date' => $check_in_date, 'check_in_time' => $check_in_time, 'check_in_location' => $check_in_location, 'check_out_time' => $check_out_time, 'check_out_location' => $check_out_location);
            $REP_values[] = $final_values;
        }
        echo JSON_ENCODE($REP_values);
    }
    //SET  MIN ND MAX DATE FUNCTION FOR PROJECT NAME BY DATE RANGE
    if ($_REQUEST['option'] == "set_datemin_max") {
        $REP_loginid = $_REQUEST['REP_chk_loginid'];
        //SET MIN DATE
        $min_date = mysqli_query($con, "select  MIN(ECIOD_DATE) AS ECIOD_DATE from EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ULD_ID='{$REP_loginid}'");
        while ($row = mysqli_fetch_array($min_date)) {
            $mindate_array = $row["ECIOD_DATE"];
            $min_date = $mindate_array;
        }
        //SET MAX DATE
        $REV_searchmax_date = mysqli_query($con, "select  MAX(ECIOD_DATE) AS ECIOD_DATE from EMPLOYEE_CHECK_IN_OUT_DETAILS WHERE ULD_ID='{$REP_loginid}'");
        while ($row = mysqli_fetch_array($REV_searchmax_date)) {
            $REV_searchmax_date_value = $row["ECIOD_DATE"];
            $max_date = $REV_searchmax_date_value;
        }
        $minmax_date_values = array($min_date, $max_date);
        echo JSON_ENCODE($minmax_date_values);
    }
}
示例#19
0
文件: cid.php 项目: Nvenom/Cellwiz
require "../../../frame/engine.php";
ENGINE::START();
$USER = USER::VERIFY(0, TRUE);
if (empty($_GET['sSearch'])) {
    $S = $_GET['string'];
} else {
    $S = $_GET['sSearch'];
}
$iDS = $_GET['iDisplayStart'];
$iDL = $_GET['iDisplayLength'];
$iSC = $_GET['iSortCol_0'];
$iSD = $_GET['sSortDir_0'];
switch ($iSC) {
    case 0:
        $SS = 'ORDER BY c_name ' . $iSD;
        break;
    case 1:
        $SS = 'ORDER BY c_phone ' . $iSD;
        break;
    case 2:
        $SS = '';
        break;
}
$iTotal = MYSQL::QUERY('SELECT COUNT(c_id) AS `COUNT` FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ?', array('%' . $S . '%', '%' . $S . '%'));
$iQuery = MYSQL::QUERY("SELECT * FROM core_customers WHERE c_name LIKE ? OR c_phone LIKE ? {$SS} LIMIT {$iDS},{$iDL}", array('%' . $S . '%', '%' . $S . '%'), FALSE, TRUE);
$OUTPUT = array('sEcho' => $_GET['sEcho'], 'iTotalRecords' => $iTotal[0]['COUNT'], 'iTotalDisplayRecords' => $iTotal[0]['COUNT'], 'aaData');
foreach ($iQuery as $C) {
    $OUTPUT['aaData'][] = array($C['c_name'], FORMAT::PHONE($C['c_phone']), '<button onClick="LoadCustomer(' . "'" . $C['c_id'] . "'" . ')">LOAD</button>');
}
echo JSON_ENCODE($OUTPUT);
 }
 //FUNCTION FOR SHOW THE DATA IN TABLE
 if($_REQUEST['option']=="EMAIL_TEMPLATE_DETAILS"){
     $ET_SRC_UPD_DEL_scriptname=$_POST['ET_SRC_UPD_DEL_lb_scriptname'];
     $ET_SRC_UPD_DEL_flextbl= mysqli_query($con,"SELECT DATE_FORMAT(CONVERT_TZ(ETD.ETD_TIMESTAMP,'+00:00','+08:00'),'%d-%m-%Y %T') AS TIMESTAMP,ETD.ETD_EMAIL_SUBJECT,ETD.ETD_EMAIL_BODY,ULD.ULD_LOGINID,ETD.ETD_ID FROM EMAIL_TEMPLATE_DETAILS ETD,USER_LOGIN_DETAILS ULD WHERE ETD.ULD_ID=ULD.ULD_ID AND ETD.ET_ID='$ET_SRC_UPD_DEL_scriptname'");
     $ET_SRC_UPD_DEL_values=array();
     while($row=mysqli_fetch_array($ET_SRC_UPD_DEL_flextbl)){
         $ET_SRC_UPD_DEL_subject=$row["ETD_EMAIL_SUBJECT"];
         $ET_SRC_UPD_DEL_body=$row["ETD_EMAIL_BODY"];
         $ET_SRC_UPD_DEL_userstamp=$row["ULD_LOGINID"];
         $ET_SRC_UPD_DEL_timestamp=$row["TIMESTAMP"];
         $ET_SRC_UPD_DEL_el_id=$row['ETD_ID'];
         $final_values=(object) ['id'=>$ET_SRC_UPD_DEL_el_id,'ET_SRC_UPD_DEL_subject' =>$ET_SRC_UPD_DEL_subject,'ET_SRC_UPD_DEL_body' =>$ET_SRC_UPD_DEL_body,'ET_SRC_UPD_DEL_userstamp'=>$ET_SRC_UPD_DEL_userstamp,'ET_SRC_UPD_DEL_timestamp'=>$ET_SRC_UPD_DEL_timestamp];
         $ET_SRC_UPD_DEL_values[]=$final_values;
     }
     echo JSON_ENCODE($ET_SRC_UPD_DEL_values);
 }
 //UPDATE DATA FOR EMAIL TEMPLATE TABLE
 if($_REQUEST['option']=="EMAIL_TEMPLATE_UPDATE"){
     $ET_SRC_UPD_DEL_el_id=$_POST['ET_SRC_UPD_DEL_rd_flxtbl'];
     $ET_SRC_UPD_DEL_subject=$_POST['ET_SRC_UPD_DEL_ta_updsubject'];
     $ET_SRC_UPD_DEL_subject= $con->real_escape_string($ET_SRC_UPD_DEL_subject);
     $ET_SRC_UPD_DEL_body=$_POST['ET_SRC_UPD_DEL_ta_updbody'];
     $ET_SRC_UPD_DEL_body= $con->real_escape_string($ET_SRC_UPD_DEL_body);
     $sql="UPDATE EMAIL_TEMPLATE_DETAILS SET ETD_EMAIL_SUBJECT='$ET_SRC_UPD_DEL_subject',ETD_EMAIL_BODY='$ET_SRC_UPD_DEL_body',ULD_ID=(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP') WHERE ETD_ID='$ET_SRC_UPD_DEL_el_id' ";
     if (!mysqli_query($con,$sql)) {
         die('Error: ' . mysqli_error($con));
         $flag=0;
     }
     else{
         $flag=1;
示例#21
0
<?php

require "../../../frame/engine.php";
ENGINE::START();
$user = USER::VERIFY(1);
$SYS_LEDGER = MYSQL::QUERY('SELECT * FROM core_stores_daily_checkouts WHERE s_id=? AND d_date=? LIMIT 1', array($user['store'], $_POST['date']));
$RESULTS = array('KEY' => $_POST['rec'] - $SYS_LEDGER['d_key'], 'CASH' => $_POST['cas'] - $SYS_LEDGER['d_cash'], 'CHECK' => $_POST['che'] - $SYS_LEDGER['d_check'], 'AMEX' => $_POST['ame'] - $SYS_LEDGER['d_amex'], 'DISCOVER' => $_POST['dis'] - $SYS_LEDGER['d_discover'], 'MASTER' => $_POST['mas'] - $SYS_LEDGER['d_master'], 'VISA' => $_POST['vis'] - $SYS_LEDGER['d_visa'], 'DEBIT' => $_POST['deb'] - $SYS_LEDGER['d_debit'], 'TICKETS' => '');
$CHECK = 0;
foreach ($RESULTS as $KEY => $VALUE) {
    if ($VALUE != 0 && $CHECK == 0) {
        $RESULTS['TICKETS'] = array('TICKETS' => MYSQL::QUERY("SELECT qb_id,items,pm_1,pm_1_cost,pm_2,pm_2_cost FROM core_checkout_sessions WHERE s_id=? AND d_date>=? AND d_date<=?", array($user['store'], $_POST['date'] . ' 00:00:00', $_POST['date'] . ' 24:59:59')));
        $CHECK = 1;
    }
}
echo JSON_ENCODE($RESULTS);
//        }
//        $CONFIG_ENTRY_errmsg_modlist=array($CONFIG_ENTRY_errmsg,$CONFIG_ENTRY_arr_mod);
        echo JSON_ENCODE($CONFIG_ENTRY_errmsg);
    }
    if($_REQUEST['option']=="CONFIG_ENTRY_load_type")
    {
//        $CONFIG_ENTRY_mod=$_REQUEST['module'];
        //CONFIG TYPE LIST
        $CONFIG_ENTRY_type = mysqli_query($con,"SELECT * FROM LMC_CONFIGURATION WHERE CNP_ID='2' AND (CGN_NON_IP_FLAG is null) ORDER BY CGN_TYPE ASC");
        $CONFIG_ENTRY_arr_type=array();
        while($row=mysqli_fetch_array($CONFIG_ENTRY_type)){
            $CONFIG_ENTRY_arr_type[]=array($row[0],$row[2]);
        }
        $CONFIG_ENTRY_errmsg=get_error_msg('71,127,130,131');
        $values=array($CONFIG_ENTRY_arr_type,$CONFIG_ENTRY_errmsg);
        echo JSON_ENCODE($values);
    }
    //SAVE CODING
    if($_REQUEST['option']=="CONFIG_ENTRY_save")
    {
        $flag=$_REQUEST['CONFIG_ENTRY_lb_module'];
        $CONFIG_ENTRY_data=$_REQUEST['CONFIG_ENTRY_tb_data'];
        $CONFIG_ENTRY_data=$con->real_escape_string($CONFIG_ENTRY_data);
        $CONFIG_ENTRY_type=$_REQUEST['CONFIG_ENTRY_lb_type'];
        $CONFIG_ENTRY_arr_config=array(3=>array("LMC_USER_RIGHTS_CONFIGURATION","URC_DATA"));
        $sql1= "SELECT ".$CONFIG_ENTRY_arr_config[$flag][1]." FROM ".$CONFIG_ENTRY_arr_config[$flag][0]." CCN WHERE CCN.CGN_ID=(SELECT C.CGN_ID FROM LMC_CONFIGURATION C WHERE C.CGN_ID='$CONFIG_ENTRY_type') AND ".$CONFIG_ENTRY_arr_config[$flag][1]."='$CONFIG_ENTRY_data'";
        $CONFIG_ENTRY_type1 = mysqli_query($con,$sql1);
        $CONFIG_ENTRY_save=0;
        if($row=mysqli_fetch_array($CONFIG_ENTRY_type1)){
            $CONFIG_ENTRY_save= 2;
        }
示例#23
0
 function getpaymenttypedetail($paymenttypeid)
 {
     $this->db->where('id', $paymenttypeid);
     $query = $this->db->get('paymenttypedetail')->row();
     if ($query) {
         echo JSON_ENCODE($query);
     } else {
         echo 0;
     }
 }
            $CONFIG_SRCH_UPD_sql_data = mysqli_query($con, "SELECT URC_ID,URC_DATA,URC_USERSTAMP,URC_TIMESTAMP FROM LMC_USER_RIGHTS_CONFIGURATION WHERE CGN_ID='$CONFIG_SRCH_UPD_type'");
        }
        $appendTable="<br><div id='CONFIG_SRCH_UPD_div_errmsg'></div><br><table id='CONFIG_SRCH_UPD_tble_config' border=1 cellspacing='0' class='srcresult'><thead  bgcolor='#6495ed' style='color:white'><tr class='head'><th style='text-align:center;' width=350>DATA</th><th style='text-align:center;' width=150>USERSTAMP</th><th style='text-align:center;' width=130>TIMESTAMP</th></tr></thead><tbody>";
        while($row=mysqli_fetch_array($CONFIG_SRCH_UPD_sql_data)){
            $appendTable .='<tr  id='.$row[0].'><td id='.'CONFIG_'.$row[0].' class="data">'.$row[1].'</td>';
            for($x = 2; $x < 4; $x++) {
                if($x == 3){
                    $appendTable .="<td style='text-align:center;'>".$row[$x]."</td>";
                }
                else{
                    $appendTable .="<td>".$row[$x]."</td>";
                }
            }
        }
        $appendTable .='</tbody></table>';
        echo JSON_ENCODE($appendTable);
    }
    //UPDATE CODING
    if($_REQUEST['option']=="CONFIG_SRCH_UPD_save")
    {
        $ff=1;
        $flag=$_REQUEST['CONFIG_SRCH_UPD_lb_module'];
        $CONFIG_SRCH_UPD_data=$_REQUEST['CONFIG_SRCH_UPD_tb_data'];
        $CONFIG_SRCH_UPD_type=$_REQUEST['CONFIG_SRCH_UPD_lb_type'];
        $CONFIG_SRCH_UPD_id=$_REQUEST['CONFIG_SRCH_UPD_id'];
        $CONFIG_SRCH_UPD_arr_config=array(4=>array("attendance_configuration","AC_ID","AC_DATA","ULD_ID","(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP')"),5=>array("PROJECT_CONFIGURATION","PC_ID","PC_DATA","ULD_ID","(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP')"),2=>array("REPORT_CONFIGURATION","RC_ID","RC_DATA","ULD_ID","(SELECT ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID='$USERSTAMP')"),3=>array("LMC_USER_RIGHTS_CONFIGURATION","URC_ID","URC_DATA","URC_USERSTAMP","(SELECT ULD_ID FROM LMC_USER_LOGIN_DETAILS WHERE ULD_USERNAME='******')"));

        $sql1= "SELECT ".$CONFIG_SRCH_UPD_arr_config[$flag][1]." FROM ".$CONFIG_SRCH_UPD_arr_config[$flag][0]." CCN WHERE CCN.CGN_ID=(SELECT C.CGN_ID FROM CONFIGURATION C WHERE C.CGN_ID='$CONFIG_SRCH_UPD_type') AND ".$CONFIG_SRCH_UPD_arr_config[$flag][1]."='$CONFIG_SRCH_UPD_data'";
        $CONFIG_SRCH_UPD_type1 = mysqli_query($con,$sql1);
        $CONFIG_SRCH_UPD_save=0;
            }
            if($ure_reason_txt!=null){
                $ure_reason='';
                $URE_reason_msg =explode("\n", $ure_reason_txt);
                $length=count($URE_reason_msg);
                for($i=0;$i<=$length;$i++){
                    $ure_reason.=$URE_reason_msg[$i].'<br>';
                }
            }
            else{
                $ure_reason=null;
            }
            $final_values=(object) ['id'=>$ure_id,'date' => $ure_date,'report' =>$ure_report,'report1' =>$ure_reprt,'userstamp'=> $ure_userstamp,'timestamp'=>$ure_timestamp,'reason'=>$ure_reason,'reason1'=>$ure_reason_txt,'permission'=>$ure_permission,'attendance'=>$ure_attendance,'pdid'=>$ure_pdid,'morningsession'=>$ure_morningsession,'afternoonsession'=>$ure_afternoonsession,'user_stamp'=>$userstamp,'flag'=>$ure_flag,'imageurl'=>$base64];
            $ure_values[]=$final_values;
        }
        echo JSON_ENCODE($ure_values);
    }
    if($_REQUEST['option']=='ALLDATE')
    {
        $alldate = $_REQUEST['alldate'];
        $empdate = date('Y-m-d',strtotime($alldate));
        $sql=mysqli_query($con,"SELECT DISTINCT AED.EMPLOYEE_NAME,A.UARD_REPORT,A.UARD_REASON,AC.AC_DATA as PERMISSION,AT.AC_DATA,G.AC_DATA AS UARD_AM_SESSION,H.AC_DATA AS UARD_PM_SESSION,C.ULD_LOGINID as USERSTAMP,DATE_FORMAT(CONVERT_TZ(A.UARD_TIMESTAMP,'+00:00','+08:00'), '%d-%m-%Y %T') as UARD_TIMESTAMP FROM USER_ADMIN_REPORT_DETAILS A INNER JOIN USER_LOGIN_DETAILS B on A.ULD_ID=B.ULD_ID INNER JOIN USER_LOGIN_DETAILS C on A.UARD_USERSTAMP_ID=C.ULD_ID INNER JOIN VW_TS_ALL_EMPLOYEE_DETAILS AED ON A.ULD_ID=AED.ULD_ID
INNER JOIN USER_ACCESS D LEFT JOIN ATTENDANCE_CONFIGURATION G ON G.AC_ID=A.UARD_AM_SESSION LEFT JOIN ATTENDANCE_CONFIGURATION H ON H.AC_ID=A.UARD_PM_SESSION LEFT join ATTENDANCE_CONFIGURATION AC ON A.UARD_PERMISSION=AC.AC_ID left JOIN ATTENDANCE_CONFIGURATION AT on AT.AC_ID=A.UARD_ATTENDANCE INNER JOIN EMPLOYEE_DETAILS ED ON A.ULD_ID=ED.ULD_ID where A.UARD_DATE='$empdate' and D.UA_TERMINATE IS null order by EMPLOYEE_NAME");
        while($row=mysqli_fetch_array($sql)){
            $adm_reprt=$row["UARD_REPORT"];
            $adm_userstamp=$row["USERSTAMP"];
            $adm_timestamp=$row["UARD_TIMESTAMP"];
            $adm_loginid=$row["EMPLOYEE_NAME"];
            $adm_reason_txt=$row["UARD_REASON"];
            $ure_morningsession=$row["UARD_AM_SESSION"];
            $ure_afternoonsession=$row["UARD_PM_SESSION"];
    $USERSTAMP = $UserStamp;
    global $con;
//FUNCTION TO FETCHING EMAIL TEMPLATE SCRIPT NAME,ERROR MESSAGE FROM SQL TABLE
    if ($_REQUEST['option'] == "EP_ENTRY_getdomain_err") {
        $EP_ENTRY_profile_array=[];
        $select_data=mysqli_query($con,"SELECT EP_ID,EP_EMAIL_DOMAIN FROM LMC_EMAIL_PROFILE WHERE EP_NON_IP_FLAG is null ORDER BY EP_EMAIL_DOMAIN ASC");
        while($row=mysqli_fetch_array($select_data)){
            $ep_id=$row['EP_ID'];
            $ep_profilename=$row['EP_EMAIL_DOMAIN'];
            $EP_ENTRY_script_object=array('EP_ENTRY_profile_names_id'=>$ep_id,'EP_ENTRY_profile_names' =>$ep_profilename);
            $EP_ENTRY_profile_array[]=$EP_ENTRY_script_object;
        }
        // GET ERR MSG
        $EP_SRC_UPD_DEL_errmsg = get_error_msg('7,40,158,159');
        $finalvalues=array("EP_ENTRY_profilenamedataid"=>$EP_ENTRY_profile_array,"EP_ENTRY_errormsg"=>$EP_SRC_UPD_DEL_errmsg);
        echo JSON_ENCODE($finalvalues);
    }
    if($_REQUEST['option']=="EP_ENTRY_already")
    {
        $profilename=$_REQUEST['EP_ENTRY_listboxname'];
        $EP_ENTRY_email=$_REQUEST['EP_ENTRY_email'];
        $EP_ENTRY_alreadyemailid=mysqli_query($con,"SELECT * FROM LMC_EMAIL_LIST WHERE EL_EMAIL_ID='$EP_ENTRY_email' AND EP_ID=(SELECT  EP_ID FROM LMC_EMAIL_PROFILE WHERE EP_EMAIL_DOMAIN='$profilename')");
        $row=mysqli_num_rows($EP_ENTRY_alreadyemailid);
        if($row>0)
        {
            $EP_ENTRY_chkmail_flag=1;
        }
        else{
            $EP_ENTRY_chkmail_flag=0;
        }
        echo $EP_ENTRY_chkmail_flag;
    $USERSTAMP = $UserStamp;
    if ($_REQUEST['option'] == 'SUBMIT') {
        $rep_entryreport = $_REQUEST['AWRE_SRC_ta_enterreport'];
        $date = $_REQUEST['AWRE_SRC_tb_date'];
        $rep_entrydate = date("Y-m-d", strtotime($date));
        $rep_entryreport = $con->real_escape_string($rep_entryreport);
        $query = "select ULD_ID FROM USER_LOGIN_DETAILS WHERE ULD_LOGINID ='{$USERSTAMP}'";
        $result = mysqli_query($con, $query);
        while ($row = mysqli_fetch_array($result)) {
            $rep_getuld_id = $row["ULD_ID"];
        }
        $sql = "INSERT INTO ADMIN_WEEKLY_REPORT_DETAILS (AWRD_REPORT,AWRD_DATE,ULD_ID)VALUES('{$rep_entryreport}','{$rep_entrydate}','{$rep_getuld_id}')";
        if (!mysqli_query($con, $sql)) {
            die('Error: ' . mysqli_error($con));
            $flag = 0;
        } else {
            $flag = 1;
        }
        echo $flag;
    } else {
        if ($_REQUEST['option'] == 'CHECK') {
            $date_array = array();
            $sql = "SELECT * FROM ADMIN_WEEKLY_REPORT_DETAILS ";
            $sql_result = mysqli_query($con, $sql);
            while ($row = mysqli_fetch_array($sql_result)) {
                $date_array[] = $row["AWRD_DATE"];
            }
            echo JSON_ENCODE($date_array);
        }
    }
}