src/Controller/DeliveryslotapiController.php line 2438

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Pimcore\Controller\FrontendController;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use symfony\Component\Routing\Annotation\Route;
  9. use Pimcore\Model\DataObject;
  10. use Pimcore\Model\Asset\Service;
  11. use Pimcore\Model\DataObject\Service as DoService;
  12. use Carbon\Carbon;
  13. use Pimcore\Model\User;
  14. use Firebase\JWT\JWT;
  15. use Firebase\JWT\Key;
  17. class DeliveryslotapiController extends FrontendController
  18. {
  19.     /**
  20.      * @Route("/holidays/getlist")
  21.      */
  22.     public function getlistAction()
  23.     {
  24.         $api_log_info = "API:Get All Holidays - ".date("YmdHis")." ".time();
  25.         $log_data = "Started - ".$api_log_info;
  26.         SELF::createApiLog($log_data);
  28.         $holidaysList = DataObject\Holidays::getList();
  29.         $holidaysList->load();
  30.         
  31.         $log_data = $api_log_info." | holidaysList Count:".json_encode(count($holidaysList));
  32.         SELF::createApiLog($log_data);
  34.         if(count($holidaysList) > 0){
  35.             foreach ($holidaysList as $key => $holidayInfo) {  
  37.                 $log_data = $api_log_info." | holidayInfo:".json_encode($holidayInfo);
  38.                 SELF::createApiLog($log_data);
  39.                 
  40.                 $location_codes = $holidayInfo->getlocation_code();
  41.                 $loc_name = '';
  43.                 $log_data = $api_log_info." | location_codes:".json_encode($location_codes);
  44.                 SELF::createApiLog($log_data);
  46.                 foreach($location_codes as $location_code){
  47.                     $loc_name .= $location_code->getlocation_name().' ';
  48.                 }
  50.                 $log_data = $api_log_info." | loc_name:".json_encode($loc_name);
  51.                 SELF::createApiLog($log_data);
  53.                 $data[] = array(
  54.                     "name" => $holidayInfo->getname(),
  55.                     "loc_name" => $loc_name,
  56.                     "holidaydate" => $holidayInfo->getHolidaydate());
  58.                 $log_data = $api_log_info." | data:".json_encode($data);
  59.                 SELF::createApiLog($log_data);
  60.             }
  61.         } else $data[] = [];
  62.         // return $slotsList;
  63.         $returndata = ["success" => true, "data" => $data];
  65.         $log_data = "Ended - ".$api_log_info." | returndata:".json_encode($returndata);
  66.         SELF::createApiLog($log_data);
  68.         return $this->json(["success" => true, "data" => $data]);
  69.     }
  71.     /*-------------------------------- Slots Related APIs ----------------------------*/
  73.     /**
  74.      * @Route("/deliveryslots/list")
  75.      */
  76.     public function listAction()
  77.     {
  78.         $api_log_info = "API:Get Delivery Slots based on Today and Current Time - ".date("YmdHis")." ".time();
  79.         $log_data = "Started - ".$api_log_info;
  80.         SELF::createApiLog($log_data);
  82.         $today_date = strtotime("Y-m-d");
  83.         $cur_time = date("H:i");
  85.         $log_data = $api_log_info." | today_date:".json_encode($today_date)." | cur_time:".json_encode($cur_time);
  86.         SELF::createApiLog($log_data);
  88.         $slotsList = DataObject\Slots::getList();
  89.         $slotsList->setCondition("slotdate >= ? AND prior_time >= ?",[$today_date, $cur_time]);
  90.         // $slotsList->setOffset(0);
  91.         $slotsList->setLimit(100);
  92.         $slotsList->setOrderKey("slotdate");
  93.         $slotsList->setOrder("desc");
  94.         $slotsList->load();
  96.         // $slotsList = DataObject\Slots::getList();
  97.         // $slotsList->setOffset(0);
  98.         // $slotsList->setLimit(10);
  99.         // $slotsList->load();
  101.         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  102.         SELF::createApiLog($log_data);
  104.         // if(count($slotsList) > 0){
  105.             foreach ($slotsList as $key => $slotInfo) {
  107.                 $log_data = $api_log_info." | slotInfo:".json_encode($slotInfo);
  108.                 SELF::createApiLog($log_data);
  110.                 // $location_code = $blog->getlocation_code()->getlocation_code();
  111.                 // $location_code = (!empty($slotInfo->getloc_id()) && $slotInfo->getloc_id())?$slotInfo->getloc_id()->getlocation_code():'';
  112.                 // $loc_name = (!empty($slotInfo->getloc_id()) && $slotInfo->getloc_id())?$slotInfo->getloc_id()->getlocation_name():'';
  114.                 $slotLocationData = DataObject\Locations::getById($slotInfo->getLoc_id());
  115.                 $loc_name = (!empty($slotLocationData) && $slotLocationData->getlocation_name())?$slotLocationData->getlocation_name():'';
  116.                 $location_code = (!empty($slotLocationData) && $slotLocationData->getlocation_code())?$slotLocationData->getlocation_code():'';
  118.                 // foreach($location_codes as $location_code){
  119.                 //     $loc_name = $location_code->getlocation_name();
  120.                 // }
  122.                 $log_data = $api_log_info." | location_code:".json_encode($location_code)." | loc_name:".json_encode($loc_name);
  123.                 SELF::createApiLog($log_data);
  125.                 $data[] = array(
  126.                     "slotId" => $slotInfo->getId(),
  127.                     "prior_time" => $slotInfo->getprior_time(),
  128.                     // "picking_time" => $slotInfo->getpicking_time(),
  129.                     "location_code" => $location_code,
  130.                     "loc_name" => $loc_name,
  131.                     // "charge" => $slotInfo->getcharge(),
  132.                     "slotdate" => $slotInfo->getslotdate(),
  133.                     "fromtime" => $slotInfo->getfromtime(),
  134.                     "totime" => $slotInfo->gettotime(),
  135.                     "maxorder" => $slotInfo->getmaxorder(),
  136.                     "ordercount" => $slotInfo->getordercount(),
  137.                     "delivery_mode" => $slotInfo->getdelivery_mode());
  138.                 
  139.                 $log_data = $api_log_info." | data:".json_encode($data);
  140.                 SELF::createApiLog($log_data);
  141.             }
  142.         // } else $data[] = [];
  143.         // return $slotsList;
  144.         $returnData = ["success" => true, "data" => $data];
  145.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  146.         SELF::createApiLog($log_data);
  147.         return $this->json(["success" => true, "data" => $data]);
  148.     }
  150.     /**
  151.      * @Route("/deliveryslots/saveslots")
  152.      */
  153.     public function saveslotsAction()
  154.     {
  156.         $api_log_info = "API:Generating / Saving Delivery Slots - ".date("YmdHis")." ".time();
  157.         $log_data = "Started - ".$api_log_info;
  158.         SELF::createApiLog($log_data);
  159.         /*--------------- Settings info ----------------*/
  160.         $settingsInfo = SELF::getSettingInfo($api_log_info);
  162.         $log_data = $api_log_info." | settingsInfo:".json_encode($settingsInfo);
  163.         SELF::createApiLog($log_data);
  164.         /*----------- End of Settings Info -------------*/
  165.         // echo 'settingsInfo:<pre>';
  166.         // echo $settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'];
  167.         // print_r($settingsInfo); die;
  169.         $locationsList = DataObject\Locations::getList();
  170.         $locationsList->load();
  172.         $log_data = $api_log_info." | locationsList count:".json_encode(count($locationsList));
  173.         SELF::createApiLog($log_data);
  175.         foreach($locationsList as $location)//Start of Locations Loop
  176.         {
  177.             $log_data = $api_log_info." | location:".json_encode($location);
  178.             SELF::createApiLog($log_data);
  180.             //echo "<br>Id:".$location->getId()."|Location Name:".$location->getLocation_name()."|Location Code:".$location->getLocation_code();
  181.             $location_id = $location->getId();
  183.             $locationName = $location->getLocation_name();
  184.             $locationCode = $location->getLocation_code();
  186.             /*------ Check Location is Up Country or not --------*/
  187.             $Is_location_up_country = (strpos(strtolower($locationName),"up country") || strpos(strtoupper($locationCode),"UPCTR"))?1:0;
  189.             $log_data = $api_log_info." | location_id:".json_encode($location_id)." | locationName:".json_encode($locationName)." | locationCode:".json_encode($locationCode)." | Is_location_up_country:".json_encode($Is_location_up_country);
  190.             SELF::createApiLog($log_data);
  192.             $holidaysList = DataObject\Holidays::getList();
  193.             $holidaysList->setCondition("location_code like '%,".$location_id.",%'");
  194.             $holidaysList->load();
  196.             // if(count($holidaysList) > 0)
  197.             // {
  198.                 $holidayDates = $rangeDates = [];
  199.                 foreach($holidaysList as $holiday)
  200.                 {
  201.                     $log_data = $api_log_info." | holiday:".json_encode($holiday);
  202.                     SELF::createApiLog($log_data);
  204.                     $holiday_locations_list = $holiday->getLocation_code();
  205.                     $holidaydate = $holiday->getHolidaydate();
  206.                     $holidayDate = date("Y-m-d", strtotime($holidaydate));
  208.                     $holidaysenddate = $holiday->getHolidaysenddate();
  210.                     $log_data = $api_log_info." | holiday_locations_list:".json_encode($holiday_locations_list)." | holidaydate:".json_encode($holidaydate)." | holidaysenddate:".json_encode($holidaysenddate);
  211.                     SELF::createApiLog($log_data);
  213.                     if(!empty($holidaysenddate) && $holidaysenddate){
  214.                         $holidaysenddate = date("Y-m-d", strtotime($holidaysenddate));
  215.                         $rangeDates = self::getDatesFromRange($holidayDate, $holidaysenddate);
  217.                         $log_data = $api_log_info." | rangeDates:".json_encode($rangeDates)." | holidaysenddate:".json_encode($holidaysenddate);
  218.                         SELF::createApiLog($log_data);
  220.                         foreach($rangeDates as $rangeDateInfo){
  222.                             $log_data = $api_log_info." | rangeDateInfo:".json_encode($rangeDateInfo);
  223.                             SELF::createApiLog($log_data);
  225.                             array_push($holidayDates,$rangeDateInfo);
  227.                             $log_data = $api_log_info." | holidayDates:".json_encode($holidayDates);
  228.                             SELF::createApiLog($log_data);
  229.                         }
  230.                     } else {
  231.                         array_push($holidayDates,$holidayDate);
  233.                         $log_data = $api_log_info." | holidayDate:".json_encode($holidayDate)." | holidayDates:".json_encode($holidayDates);
  234.                         SELF::createApiLog($log_data);
  235.                     }
  236.                 }
  237.                 // if(!empty($rangeDates)){
  238.                 //     echo '<pre>'; print_r($holidayDates); die;
  239.                 // }
  241.                 /*----------- Delivery Slot Times Loop Starts --------*/
  242.                 $deliveryslottimesList = DataObject\Deliveryslottimes::getList();
  243.                 $deliveryslottimesList->load();
  244.                 //echo '<br>deliveryslottimesList Count:'.count($deliveryslottimesList);
  246.                 $log_data = $api_log_info." | deliveryslottimesList Count:".json_encode(count($deliveryslottimesList));
  247.                 SELF::createApiLog($log_data);
  249.                 if(count($deliveryslottimesList)>0)
  250.                 {
  251.                     foreach($deliveryslottimesList as $deliveryslottimes)
  252.                     {
  253.                         $log_data = $api_log_info." | deliveryslottimes:".json_encode($deliveryslottimes);
  254.                         SELF::createApiLog($log_data);
  256.                         // echo '<pre>deliveryslottimes:'; print_r($deliveryslottimes); //die;
  258.                         $slot_prepare_days = ($deliveryslottimes->getprepare_days())?$deliveryslottimes->getprepare_days():0;
  259.                         $slot_generate_days = ($deliveryslottimes->getslot_generate_days())?$deliveryslottimes->getslot_generate_days():7;
  260.                         $saturday_slot_availability = ($deliveryslottimes->getsaturday_slot_availability())?$deliveryslottimes->getsaturday_slot_availability():'No';
  261.                         $sunday_slot_availability = ($deliveryslottimes->getsunday_slot_availability())?$deliveryslottimes->getsunday_slot_availability():'No';
  263.                         $slot_generate_days = $slot_generate_days+$settingsInfo['stg_normalloc_slot_generate_days']; 
  265.                         $log_data = $api_log_info." | slot_prepare_days:".json_encode($slot_prepare_days)." | slot_generate_days:".json_encode($slot_generate_days)." | saturday_slot_availability:".json_encode($saturday_slot_availability)." | sunday_slot_availability:".json_encode($sunday_slot_availability)." | setting stg_normalloc_slot_generate_days:".json_encode($settingsInfo['stg_normalloc_slot_generate_days'])." | slot_generate_days:".json_encode($slot_generate_days);
  266.                         SELF::createApiLog($log_data);
  268.                         /*--------------------- Up Country Configuration ------------------------*/
  269.                         $is_upcountry_configuration_applicable = ($deliveryslottimes->getis_upcountry_configuration_applicable())?$deliveryslottimes->getis_upcountry_configuration_applicable():'No';
  270.                         $slot_upcountry_prepare_days = ($deliveryslottimes->getupcountry_prepare_days())?$deliveryslottimes->getupcountry_prepare_days():0;
  271.                         $upcountry_slot_generate_days = ($deliveryslottimes->getupcountry_slot_generate_days())?$deliveryslottimes->getupcountry_slot_generate_days():7;
  272.                         $upcountry_saturday_slot_availability = ($deliveryslottimes->getupcountry_saturday_slot_availability())?$deliveryslottimes->getupcountry_saturday_slot_availability():'No';
  273.                         $upcountry_sunday_slot_availability = ($deliveryslottimes->getupcountry_sunday_slot_availability())?$deliveryslottimes->getupcountry_sunday_slot_availability():'No';
  275.                         $upcountry_slot_generate_days = $upcountry_slot_generate_days+$settingsInfo['stg_upcountryloc_slot_generate_days']; 
  277.                         $log_data = $api_log_info." | is_upcountry_configuration_applicable:".json_encode($is_upcountry_configuration_applicable)." | slot_upcountry_prepare_days:".json_encode($slot_upcountry_prepare_days)." | upcountry_slot_generate_days:".json_encode($upcountry_slot_generate_days)." | upcountry_saturday_slot_availability:".json_encode($upcountry_saturday_slot_availability)." | upcountry_sunday_slot_availability:".json_encode($upcountry_sunday_slot_availability)." | setting stg_upcountryloc_slot_generate_days:".json_encode($settingsInfo['stg_upcountryloc_slot_generate_days'])." | upcountry_slot_generate_days:".json_encode($upcountry_slot_generate_days);
  278.                         SELF::createApiLog($log_data);
  280.                         if($settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'] == 'Yes' && $Is_location_up_country == 1)//if($is_upcountry_configuration_applicable == 'Yes' && $Is_location_up_country == 1)
  281.                             $delSlotTimesAvailibility = ['slot_prepare_days'=>$slot_upcountry_prepare_days,'slot_generate_days'=>$upcountry_slot_generate_days,'saturday_slot_availability'=>$upcountry_saturday_slot_availability,'sunday_slot_availability'=>$upcountry_sunday_slot_availability];
  282.                         else
  283.                             $delSlotTimesAvailibility = ['slot_prepare_days'=>$slot_prepare_days,'slot_generate_days'=>$slot_generate_days,'saturday_slot_availability'=>$saturday_slot_availability,'sunday_slot_availability'=>$sunday_slot_availability];
  285.                         $log_data = $api_log_info." | delSlotTimesAvailibility:".json_encode($delSlotTimesAvailibility);
  286.                         SELF::createApiLog($log_data);
  288.                         // echo '<pre>delSlotTimesAvailibility:'; print_r($delSlotTimesAvailibility); //die;
  290.                         $weekdates = self::getWeekDates($holidayDates, date("Y-m-d"), $delSlotTimesAvailibility);
  291.                         // echo '<pre>weekdates:'; print_r($weekdates);
  293.                         $log_data = $api_log_info." | weekdates:".json_encode($weekdates);
  294.                         SELF::createApiLog($log_data);
  296.                         foreach($weekdates as $weekdate)
  297.                         {
  298.                             $log_data = $api_log_info." | weekdate:".json_encode($weekdate);
  299.                             SELF::createApiLog($log_data);
  301.                             $slotsList = DataObject\Deliveryslotrules::getList();
  302.                             // $slotsList->setCondition("location_code like '%,".$location_id.",%'");
  303.                             $slotsList->setCondition("location_ids IS NOT NULL AND location_ids like '%,".$location_id.",%'");
  304.                             $slotsList->load();
  305.                             //echo '<br>slotsList Count:'.count($slotsList);
  307.                             $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  308.                             SELF::createApiLog($log_data);
  310.                             if(count($slotsList) > 0)
  311.                             {
  312.                                 foreach($slotsList as $slot)
  313.                                 {
  314.                                     $log_data = $api_log_info." | slot:".json_encode($slot);
  315.                                     SELF::createApiLog($log_data);
  317.                                     $prior_time = $slot->getprior_time();
  318.                                     $location_codes = $slot->getlocation_ids();//$slot->getlocation_code();
  319.                                     // $picking_time = $slot->getpicking_time();
  320.                                     $delivery_mode = $slot->getdelivery_mode();
  321.                                     // $charge = $slot->getcharge();
  322.                                     $fromtime = $slot->getfromtime();
  323.                                     $totime = $slot->gettotime();
  324.                                     $maxorder = $slot->getmaxorder();
  325.                                     // $ordercount = $slot->getordercount();
  326.                                     $date = $weekdate;//$slot->getslotdate();
  327.                                     $date2 = date("m/d/y", strtotime($date));
  328.                                     $dates = Carbon::createFromFormat('m/d/y', $date2);
  330.                                     $location_code_array = [];
  332.                                     // echo '<pre>location_codes Count:'.count($location_codes);
  334.                                     $log_data = $api_log_info." | location_codes:".json_encode($location_codes);
  335.                                     SELF::createApiLog($log_data);
  337.                                     if(!empty($location_codes))
  338.                                     {
  339.                                         foreach($location_codes as $location_id_info){//foreach($location_codes as $location_code){//Location Code loop Starts
  341.                                             $log_data = $api_log_info." | location_id_info:".json_encode($location_id_info);
  342.                                             SELF::createApiLog($log_data);
  344.                                             if($location_id == $location_id_info)//if($location_id == $location_code->getId())
  345.                                             {
  346.                                                 $log_data = $api_log_info." | location_id:".json_encode($location_id)." | location_id_info:".json_encode($location_id_info);
  347.                                                 SELF::createApiLog($log_data);
  348.                                                 // $location_code_array[] = DataObject\Locations::getById($location_code->getId());
  349.                                                 // $location_code_id = DataObject\Locations::getById($location_code->getId());
  350.     
  351.                                                 // $loc_id = $location_code->getId();
  352.     
  353.                                                 $location_code_array[] = DataObject\Locations::getById($location_id_info);
  354.                                                 $location_code_id = DataObject\Locations::getById($location_id_info);
  356.                                                 $log_data = $api_log_info." | location_code_id:".json_encode($location_code_id);
  357.                                                 SELF::createApiLog($log_data);
  358.     
  359.                                                 $loc_id = $location_id_info;
  360.     
  361.                                                 /*----------- Delivery Slot Times Loop Starts --------*/
  362.                                                 // $deliveryslottimesList = DataObject\Deliveryslottimes::getList();
  363.                                                 // $deliveryslottimesList->load();
  364.                                                 // //echo '<br>deliveryslottimesList Count:'.count($deliveryslottimesList);
  365.                                                 // if(count($deliveryslottimesList)>0)
  366.                                                 // {
  367.                                                 //     foreach($deliveryslottimesList as $deliveryslottimes)
  368.                                                 //     {
  369.                                                         /*------------ Checking the slot data -------------*/
  370.                                                         $slotCheck = 1;
  371.                                                         $today_date = date("Y-m-d", strtotime($weekdate));
  372.                                                         $cur_time = $prior_time;
  373.     
  374.                                                         $checkDataList = DataObject\Slots::getList();
  375.     
  376.                                                         if ($checkDataList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  377.                                                             $checkDataList->filterBySlotdate($today_date, '=');
  378.                                                         }
  379.     
  380.                                                         if ($checkDataList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  381.                                                             $checkDataList->filterByprior_time($cur_time, '=');
  382.                                                         }
  383.     
  384.                                                         if ($checkDataList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  385.                                                             $checkDataList->filterBydelivery_mode($delivery_mode, '=');
  386.                                                         }
  387.                                                         // $checkDataList->setCondition("loc_id__id = ".$loc_id);
  388.                                                         // $checkDataList->setCondition("delivery_mode = '".$delivery_mode."' ");
  389.     
  390.                                                         $checkDataList->setLimit(100);
  391.                                                         $checkDataList->setOrderKey("slotdate");
  392.                                                         $checkDataList->setOrder("asc");
  393.                                                         $checkDataList->load();
  394.                                                         //echo '<br>checkDataList Count:'.count($checkDataList);
  395.     
  396.                                                         $checkData_loc_valid = 0; $checkData_locs = [];
  398.                                                         $log_data = $api_log_info." | checkDataList count:".json_encode(count($checkDataList));
  399.                                                         SELF::createApiLog($log_data);
  400.                                                         
  401.                                                         if(count($checkDataList) > 0)
  402.                                                         {
  403.                                                             foreach($checkDataList as $checkData)
  404.                                                             {
  405.                                                                 $log_data = $api_log_info." | checkData:".json_encode($checkData);
  406.                                                                 SELF::createApiLog($log_data);
  407.                                                         
  408.                                                                 // $checkData_locData = $checkData->getloc_id();
  409.                                                                 // $checkData_locId = $checkData_locData->getId();
  410.                                                                 $checkData_locId = $checkData->getloc_id();
  411.                                                                 array_push($checkData_locs, $checkData_locId);
  413.                                                                 $log_data = $api_log_info." | checkData_locId:".json_encode($checkData_locId)." | checkData_locs:".json_encode($checkData_locs);
  414.                                                                 SELF::createApiLog($log_data);
  415.                                                             }
  416.                                                         }
  417.                                                         $checkData_loc_valid = (empty($checkData_locs) || (!empty($checkData_locs) && !in_array($loc_id, $checkData_locs)) || count($checkDataList) <= 0)?1:0;
  419.                                                         $log_data = $api_log_info." | checkData_loc_valid:".json_encode($checkData_loc_valid);
  420.                                                         SELF::createApiLog($log_data);
  421.     
  422.                                                         // echo '<br>checkData_locId:'.$checkData_locId;
  423.                                                         // echo '<pre>checkData_locs:';
  424.                                                         // print_r($checkData_locs);
  425.                                                         // echo '<br>checkData_loc_valid:'.$checkData_loc_valid;
  426.                                                         /*------------ End of Checking the slot data -------------*/
  427.     
  428.                                                         if($checkData_loc_valid == 1){
  429.                                                             // $generateObjFolderId = self::generateSlotObjFolder('Slots',$delivery_mode,$loc_id);
  430.     
  431.                                                             $createAssetFolder = DoService::createFolderByPath('Slots');
  432.                                                             $objParentId = $createAssetFolder->getId();
  433.     
  434.                                                             // $holidayObjectName = $location_code.'-'.$name;
  435.                                                             $slotObjectName = $weekdate.'-'.$loc_id.'-'.$slot->getId().'-'.$deliveryslottimes->getId().'-'.time();
  436.     
  437.                                                             $slotObject = new DataObject\Slots(); 
  438.                                                             $slotObject->setKey(\Pimcore\Model\Element\Service::getValidKey($slotObjectName, 'object'));
  439.                                                             $slotObject->setParentId($objParentId);
  440.                                                             $slotObject->setPrior_time($prior_time);
  441.                                                             // $slotObject->setPicking_time($picking_time);
  442.                                                             $slotObject->setDelivery_mode($delivery_mode);
  443.                                                             // $slotObject->setSlotdate($date2);
  444.                                                             $slotObject->setSlotdate($dates);
  445.                                                             $slotObject->setfromtime($fromtime);
  446.                                                             $slotObject->settotime($totime);
  447.                                                             $slotObject->setmaxorder($maxorder);
  448.     
  449.                                                             // $slotObject->setLocation_code($location_code_array);
  450.     
  451.                                                             // $slotObject->setCharge($charge);
  452.                                                             $slotObject->setdeliveryslottime_id(DataObject\Deliveryslottimes::getById($deliveryslottimes->getId()));
  453.                                                             // $slotObject->setloc_id(DataObject\Locations::getById($location_code->getId()));
  454.                                                             // $slotObject->setloc_id(DataObject\Locations::getById($location_id_info));
  455.                                                             $slotObject->setloc_id($location_id_info);
  456.     
  457.                                                             $slotObject->setPublished(true);
  458.                                                             $slotObject->save();
  460.                                                             $log_data = $api_log_info." | objParentId :".json_encode($objParentId)." | slotObjectName :".json_encode($slotObjectName)." | save slot : success";
  461.                                                             SELF::createApiLog($log_data);
  462.                                                         }
  463.                                                 //     }
  464.                                                 // }
  465.                                             }
  466.                                             /*---------- Delivery Slot Time loop ends ------------*/
  467.                                         }//Location Code loop ends
  468.                                     }
  469.                                 }
  470.                             }
  471.                         }
  472.                     }
  473.                 }
  474.             // }
  476.         }//End of Locations Loop
  477.         
  478.         $log_data = "Ended - ".$api_log_info." | data : Slot Created for one week Successfully'";
  479.         SELF::createApiLog($log_data);
  481.         return $this->json(["success" => true, "data" => 'Slot Created for one week Successfully']);
  482.     }
  484.     /**
  485.      * @Route("deliveryslots/updateslotordercount", methods={"POST"})
  486.      */
  487.     public function updateslotordercountAction(Request $request)
  488.     {
  489.         $api_log_info = "API:Update Delivery Slot Order Count based on slotId - ".date("YmdHis")." ".time();
  490.         $log_data = "Started - ".$api_log_info;
  491.         SELF::createApiLog($log_data);
  493.         $message = SELF::verifyauthToken($api_log_info);
  494.         $log_data = $api_log_info." | message:".json_encode($message);
  495.         SELF::createApiLog($log_data);
  497.         $data = [];
  498.         if($message == "No data found")
  499.         {
  500.             $slotId = $request->get('slotId');
  501.             $ordercount = $request->get('ordercount');
  503.             $log_data = $api_log_info." | slotId:".json_encode($slotId)." | ordercount:".json_encode($ordercount);
  504.             SELF::createApiLog($log_data);
  506.             if($slotId == "" || $ordercount == "")
  507.             {
  508.                 $data = "slotId and ordercount are mandatory!";
  509.                 $log_data = $api_log_info." | data:".json_encode($data);
  510.                 SELF::createApiLog($log_data);
  511.             } else 
  512.             {
  513.                 $slotruleObject = DataObject\Slots::getById($slotId);
  514.                 $log_data = $api_log_info." | slotruleObject:".json_encode($slotruleObject);
  515.                 SELF::createApiLog($log_data);
  517.                 if(!empty($slotruleObject) && $slotruleObject->getId()){
  518.                     $slotruleObject->setordercount($ordercount);
  519.                     $slotruleObject->save();
  521.                     $data = "Slot Updated Successfully!";
  522.                     $log_data = $api_log_info." | data:".json_encode($data);
  523.                     SELF::createApiLog($log_data);
  524.                 } else {
  525.                     $data = "This Slot Id ".$slotId." is not existed, Please try with valid Slot Id";
  526.                     $log_data = $api_log_info." | data:".json_encode($data);
  527.                     SELF::createApiLog($log_data);
  528.                 }
  529.             }
  530.         }else $data[] = ['message'=>$message];
  531.         $data = (empty($data))?$message:$data;
  533.         $returnData = ["success" => true, "data" => $data];
  534.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  535.         SELF::createApiLog($log_data);
  537.         return $this->json(["success" => true, "data" => $message]);
  538.     }
  540.     /**
  541.      * @Route("/deliveryslots/getSlot/{id}")
  542.      */
  543.     public function getSlot($id)
  544.     {
  545.         $api_log_info = "API:Slot Info by Slot ID | ID:".$id." - ".date("YmdHis")." ".time();
  546.         $log_data = "Started - ".$api_log_info;
  547.         SELF::createApiLog($log_data);
  549.         $message = SELF::verifyauthToken($api_log_info);
  550.         $log_data = $api_log_info." | message:".json_encode($message);
  551.         SELF::createApiLog($log_data);
  553.         $data = [];
  554.         if($message == "No data found")
  555.         {
  556.             $slot = DataObject\Slots::getById($id);  
  557.         
  558.             $log_data = $api_log_info." | slot:".json_encode($slot);
  559.             SELF::createApiLog($log_data);
  561.             if(isset($slot) && $slot->getId() != ''){
  562.                 
  563.                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  564.                 $loc_name = (!empty($slotLocationData) && $slotLocationData->getlocation_name())?$slotLocationData->getlocation_name():'';
  565.                 $loc_code = (!empty($slotLocationData) && $slotLocationData->getlocation_code())?$slotLocationData->getlocation_code():'';
  567.                 $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData)." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  568.                 SELF::createApiLog($log_data);
  570.                 $data = array(
  571.                     "prior_time" => $slot->getprior_time(),
  572.                     // "picking_time" => $slot->getpicking_time(),
  573.                     // "charge" => $slot->getcharge(),
  574.                     "slotdate" => date("Y-m-d", strtotime($slot->getslotdate())),//$slot->getslotdate(),
  575.                     "loc_code" => $loc_code,
  576.                     "loc_name" => $loc_name,
  577.                     "fromtime" => $slot->getfromtime(),
  578.                     "totime" => $slot->gettotime(),
  579.                     "maxorder" => $slot->getmaxorder(),
  580.                     "ordercount" => $slot->getordercount(),
  581.                     "delivery_mode" => $slot->getdelivery_mode());
  583.                 $log_data = $api_log_info." | data:".json_encode($data);
  584.                 SELF::createApiLog($log_data);
  586.             } else {
  587.                 $data = "No data found";
  588.                 $log_data = $api_log_info." | data:".json_encode($data);
  589.                 SELF::createApiLog($log_data);
  590.             }   
  591.         }else $data[] = ['message'=>$message];
  592.         $data = (empty($data))?$message:$data;  
  593.         
  594.         $returnData = ["success" => true, "data" => $data];
  595.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  596.         SELF::createApiLog($log_data);
  597.         
  598.         // return $slotsList;
  599.         return $this->json(["success" => true, "data" => $data]);
  600.     }
  602.     /**
  603.      * @Route("/deliveryslots/getStoreslot/{id}")
  604.      */
  606.     public function getStoreslot($id)
  607.     {
  608.         $api_log_info = "API:Get Delivery Slots based on Location Code for Today and Time only | ID:".$id." - ".date("YmdHis")." ".time();
  609.         $log_data = "Started - ".$api_log_info;
  610.         SELF::createApiLog($log_data);
  612.         $data ="No data found";
  613.         if($id == "")
  614.         {
  615.             $data ="Location Code is mandatory!";
  616.             $log_data = $api_log_info." | data:".json_encode($data);
  617.             SELF::createApiLog($log_data);
  619.         } else 
  620.         {
  621.             /*---- Check Location by Location Code ---------*/
  622.             $locData = DataObject\Locations::getBylocation_code($id, 1);
  624.             $log_data = $api_log_info." | locData:".json_encode($locData);
  625.             SELF::createApiLog($log_data);
  627.             if(empty($locData) || empty($locData->getId()))
  628.             {
  629.                 $data = "Location is not exited, please try with valid location code!";
  630.                 $log_data = $api_log_info." | data:".json_encode($data);
  631.                 SELF::createApiLog($log_data);
  632.             } else {
  633.                 $loc_id = $locData->getId();
  634.                 $today_date = date("Y-m-d");//"2024-01-03";//
  636.                 $cur_time = date("H:i");
  638.                 $log_data = $api_log_info." | loc_id:".json_encode($loc_id)." | today_date:".json_encode($today_date)." | cur_time:".json_encode($cur_time);
  639.                 SELF::createApiLog($log_data);
  641.                 $slotsList = DataObject\Slots::getList();
  643.                 if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  644.                     $slotsList->filterBySlotdate($today_date, '=');
  645.                 }
  647.                 if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  648.                     $slotsList->filterByprior_time($cur_time, '>=');
  649.                 }
  650.                 $slotsList->setCondition("loc_id = ".$loc_id);
  652.                 $slotsList->setLimit(100);
  653.                 $slotsList->setOrderKey("slotdate");
  654.                 $slotsList->setOrder("asc");
  655.                 $slotsList->load();
  657.                 $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  658.                 SELF::createApiLog($log_data);
  660.                 $data = [];
  662.                 if(count($slotsList) > 0){
  663.                     foreach ($slotsList as $key => $slotInfo) {
  665.                         $log_data = $api_log_info." | slotInfo:".json_encode($slotInfo);
  666.                         SELF::createApiLog($log_data);
  668.                         $slotLocationData = DataObject\Locations::getById($slotInfo->getLoc_id());
  670.                         $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData);
  671.                         SELF::createApiLog($log_data);
  673.                         $loc_name = $slotLocationData->getlocation_name();
  674.                         $loc_code = $slotLocationData->getlocation_code();
  676.                         $log_data = $api_log_info." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  677.                         SELF::createApiLog($log_data);
  678.             
  679.                         // if($loc_name != 0 && $loc_name == $id){
  680.                         // if(!empty($loc_codes) && in_array($id, $loc_codes)){//&& $id!= '' 
  681.                             // if(!empty($blog->getloc_id()) && $blog->getloc_id()->getlocation_code() == $id){//&& $id!= '' 
  682.                             $data[] = array(
  683.                                 "slotId" => $slotInfo->getId(),
  684.                                 "prior_time" => $slotInfo->getprior_time(),
  685.                                 // "picking_time" => $slotInfo->getpicking_time(),
  686.                                 "location_code" => $loc_code,
  687.                                 "loc_name" => $loc_name,
  688.                                 // "charge" => $slotInfo->getcharge(),
  689.                                 "slotdate" => $slotInfo->getslotdate(),
  690.                                 "fromtime" => $slotInfo->getfromtime(),
  691.                                 "totime" => $slotInfo->gettotime(),
  692.                                 "maxorder" => $slotInfo->getmaxorder(),
  693.                                 "ordercount" => $slotInfo->getordercount(),
  694.                                 "delivery_mode" => $slotInfo->getdelivery_mode());
  696.                             $log_data = $api_log_info." | data:".json_encode($data);
  697.                             SELF::createApiLog($log_data);
  698.                         //}
  699.                     }
  700.                 } else $data = "No data found";
  701.             }
  702.         }
  704.         $return_data = ["success" => true, "data" => $data];
  706.         $log_data = $api_log_info." | return_data:".json_encode($return_data);
  707.         SELF::createApiLog($log_data);
  708.         
  709.         return $this->json(["success" => true, "data" => $data]);
  710.     }
  712.     /**
  713.      * @Route("/deliveryslottime/gelocslottimes/{locCode}")
  714.      */
  715.     public function gelocslottimesAction($locCode)
  716.     {
  717.         $api_log_info = "API:Retriving Delivery Slots by Location Code | locCode:".$locCode." - ".date("YmdHis")." ".time();
  718.         $log_data = "Started - ".$api_log_info;
  719.         SELF::createApiLog($log_data);
  721.         $message = SELF::verifyauthToken($api_log_info);
  722.         $log_data = $api_log_info." | message:".json_encode($message);
  723.         SELF::createApiLog($log_data);
  725.         $Is_location_up_country = $is_upcountry_configuration_applicable = '';
  727.         if($message == "No data found")
  728.         {
  729.             $today_date = date("Y-m-d");
  730.             $tomorrow_date = date('Y-m-d', strtotime($today_date . ' +1 day'));
  731.             $dates_list = array($today_date, $tomorrow_date);
  732.             
  733.             $log_data = $api_log_info." | dates_list:".json_encode($dates_list);
  734.             SELF::createApiLog($log_data);
  736.             /*---- Check Location by Location Code ---------*/
  737.             $locationData = DataObject\Locations::getBylocation_code($locCode, 1);
  738.             
  739.             $log_data = $api_log_info." | locationData:".json_encode($locationData);
  740.             SELF::createApiLog($log_data);
  742.             /*--------------- Settings info ----------------*/
  743.             $settingsInfo = SELF::getSettingInfo($api_log_info);
  745.             $log_data = $api_log_info." | settingsInfo:".json_encode($settingsInfo);
  746.             SELF::createApiLog($log_data);
  747.             /*----------- End of Settings Info -------------*/
  748.              /*--------- Getting Delivery Modes settings ----------*/
  749.             $setting_slot_time_flag = $settingsInfo['setting_slot_time_flag'];
  750.             $setting_deliveryModes = $settingsInfo['setting_deliveryModes'];
  751.             $settingDataId = $settingsInfo['settingDataId'];
  752.             // echo 'settingsInfo:<pre>';
  753.             // print_r($settingsInfo); die;
  754.             
  755.             $log_data = $api_log_info." | setting_slot_time_flag:".json_encode($setting_slot_time_flag)."| setting_deliveryModes:".json_encode($setting_deliveryModes)."| settingDataId:".json_encode($settingDataId);
  756.             SELF::createApiLog($log_data);
  758.             if(!empty($locationData) && !empty($locationData->getId()))
  759.             {
  760.                 $parentLoc_id = $locationData->getId();
  761.                 $parentLocationName = $locationData->getLocation_name();
  762.                 $parentLocationCode = $locationData->getLocation_code();
  763.                 $fastDelivery = $locationData->getfastDeliveryAvailable();
  765.                 /*------ Check Location is Up Country or not --------*/
  766.                 $Is_location_up_country = (strpos(strtolower($parentLocationName),"up country") || strpos(strtoupper($parentLocationCode),"UPCTR"))?1:0;
  768.                 $log_data = $api_log_info." | parentLoc_id:".json_encode($parentLoc_id)."| parentLocationName:".json_encode($parentLocationName)."| parentLocationCode:".json_encode($parentLocationCode);
  769.                 SELF::createApiLog($log_data);
  771.                 //------ get holidays list ------------//
  772.                 $holidaysList = DataObject\Holidays::getList();
  773.                 $holidaysList->setCondition("location_code like '%,".$parentLoc_id.",%'");
  774.                 $holidaysList->load();
  775.                 
  776.                 $holidayDates = [];
  777.                 foreach($holidaysList as $holiday)
  778.                 {
  779.                     $log_data = $api_log_info." | holiday:".json_encode($holiday);
  780.                     SELF::createApiLog($log_data);
  782.                     $holiday_locations_list = $holiday->getLocation_code();
  783.                     $holidaydate = $holiday->getHolidaydate();
  784.                     $holidayDate = date("Y-m-d", strtotime($holidaydate));
  786.                     $log_data = $api_log_info." | holiday_locations_list:".json_encode($holiday_locations_list)."| holidaydate:".json_encode($holidaydate);
  787.                     SELF::createApiLog($log_data);
  788.                     
  789.                     $holidaysenddate = $holiday->getHolidaysenddate();
  790.                     if(!empty($holidaysenddate) && $holidaysenddate){
  791.                         $holidaysenddate = date("Y-m-d", strtotime($holidaysenddate));
  792.                         $rangeDates = self::getDatesFromRange($holidayDate, $holidaysenddate);
  794.                         $log_data = $api_log_info." | holidaysenddate:".json_encode($holidaysenddate)."| rangeDates:".json_encode($rangeDates);
  795.                         SELF::createApiLog($log_data);
  796.                         
  797.                         foreach($rangeDates as $rangeDateInfo){
  798.                             array_push($holidayDates,$rangeDateInfo);
  799.                         }
  800.                     } else {
  801.                         array_push($holidayDates,$holidayDate);
  802.                     }
  803.                 }
  805.                 $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  806.                 $delSlotTimesList->setOrderKey("o_id");
  807.                 $delSlotTimesList->setOrder("desc");
  808.                 $delSlotTimesList->load();
  810.                 // foreach($dates_list as $cur_date){
  812.                     $log_data = $api_log_info." | delSlotTimesList count:".count($delSlotTimesList);
  813.                     SELF::createApiLog($log_data);
  814.                     
  815.                     if(count($delSlotTimesList) > 0){
  817.                         $cur_time = date("H:i");//"09:00";//
  819.                         $log_data = $api_log_info." | cur_time:".$cur_time;
  820.                         SELF::createApiLog($log_data);
  822.                         foreach($delSlotTimesList as $delSlotTimes)
  823.                         {
  824.                             $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  825.                             SELF::createApiLog($log_data);
  827.                             //------- Get Week Dates based on Holidays and Slot Time data ---------//
  828.                             $slot_prepare_days = ($delSlotTimes->getprepare_days())?$delSlotTimes->getprepare_days():0;
  829.                             $slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():7;
  830.                             $saturday_slot_availability = ($delSlotTimes->getsaturday_slot_availability())?$delSlotTimes->getsaturday_slot_availability():'No';
  831.                             $sunday_slot_availability = ($delSlotTimes->getsunday_slot_availability())?$delSlotTimes->getsunday_slot_availability():'No';
  833.                             $log_data = $api_log_info." | slot_prepare_days:".json_encode($slot_prepare_days)."| slot_generate_days:".json_encode($slot_generate_days)."| saturday_slot_availability:".json_encode($saturday_slot_availability)."| sunday_slot_availability:".json_encode($sunday_slot_availability);
  834.                             SELF::createApiLog($log_data);
  836.                             /*--------------------- Up Country Configuration ------------------------*/
  837.                             $is_upcountry_configuration_applicable = ($delSlotTimes->getis_upcountry_configuration_applicable())?$delSlotTimes->getis_upcountry_configuration_applicable():'No';
  838.                             $slot_upcountry_prepare_days = ($delSlotTimes->getupcountry_prepare_days())?$delSlotTimes->getupcountry_prepare_days():0;
  839.                             $upcountry_slot_generate_days = ($delSlotTimes->getupcountry_slot_generate_days())?$delSlotTimes->getupcountry_slot_generate_days():7;
  840.                             $upcountry_saturday_slot_availability = ($delSlotTimes->getupcountry_saturday_slot_availability())?$delSlotTimes->getupcountry_saturday_slot_availability():'No';
  841.                             $upcountry_sunday_slot_availability = ($delSlotTimes->getupcountry_sunday_slot_availability())?$delSlotTimes->getupcountry_sunday_slot_availability():'No';
  843.                             $log_data = $api_log_info." | is_upcountry_configuration_applicable:".json_encode($is_upcountry_configuration_applicable)."| slot_upcountry_prepare_days:".json_encode($slot_upcountry_prepare_days)."| upcountry_slot_generate_days:".json_encode($upcountry_slot_generate_days)."| upcountry_saturday_slot_availability:".json_encode($upcountry_saturday_slot_availability)."| upcountry_sunday_slot_availability:".json_encode($upcountry_sunday_slot_availability);
  844.                             SELF::createApiLog($log_data);
  846.                             $log_data = $api_log_info." | settings stg_deliveryslot_config_is_upcountry_configuration_applicable:".json_encode($settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'])."| Is_location_up_country:".json_encode($Is_location_up_country);
  847.                             SELF::createApiLog($log_data);
  849.                             if($settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'] == 'Yes' && $Is_location_up_country == 1)//if($is_upcountry_configuration_applicable == 'Yes' && $Is_location_up_country == 1)
  850.                             {                                
  851.                                 $slot_prepare_days = $slot_upcountry_prepare_days;
  852.                                 $slot_generate_days = $upcountry_slot_generate_days;
  853.                                 $saturday_slot_availability = $upcountry_saturday_slot_availability;
  854.                                 $sunday_slot_availability = $upcountry_sunday_slot_availability;
  855.                                 
  856.                                 $cur_slot_generate_days = ($delSlotTimes->getupcountry_slot_generate_days())?$delSlotTimes->getupcountry_slot_generate_days():0;
  857.                                 
  858.                                 // $slot_generate_days = ($cur_time > $settingsInfo['stg_delslot_upcountryloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_upcountryloc_lessthaneq_totime'])?$slot_generate_days+$settingsInfo['stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays']:$slot_generate_days+$settingsInfo['stg_delslot_normalloc_after_totime_extra_generate_slotdays'];
  859.                                 
  860.                                 $stg_normalloc_upcounry_slot_generate_days = ($cur_time > $settingsInfo['stg_delslot_upcountryloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_upcountryloc_lessthaneq_totime'])?$settingsInfo['stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays']:$settingsInfo['stg_delslot_upcountryloc_after_totime_extra_generate_slotdays'];
  862.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  864.                                 $log_data = $api_log_info." | slot_prepare_days:".json_encode($slot_prepare_days)."| slot_generate_days:".json_encode($slot_generate_days)."| saturday_slot_availability:".json_encode($saturday_slot_availability)."| sunday_slot_availability:".json_encode($sunday_slot_availability)."| cur_slot_generate_days:".json_encode($cur_slot_generate_days)."| stg_normalloc_upcounry_slot_generate_days:".json_encode($stg_normalloc_upcounry_slot_generate_days)."| slot_generate_days:".json_encode($slot_generate_days);
  865.                                 SELF::createApiLog($log_data);
  866.                             }
  867.                             else
  868.                             {
  869.                                 $cur_slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():0;
  871.                                 // $slot_generate_days = ($cur_time > $setting_slot_time_flag)?$slot_generate_days+1:$slot_generate_days;
  873.                                 $stg_normalloc_upcounry_slot_generate_days = ($cur_time > $settingsInfo['stg_delslot_normalloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_normalloc_lessthaneq_totime'])?$settingsInfo['stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays']:$settingsInfo['stg_delslot_normalloc_after_totime_extra_generate_slotdays'];
  875.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  877.                                 $log_data = $api_log_info." | cur_slot_generate_days:".json_encode($cur_slot_generate_days)."| stg_normalloc_upcounry_slot_generate_days:".json_encode($stg_normalloc_upcounry_slot_generate_days);
  878.                                 SELF::createApiLog($log_data);
  879.                             }
  881.                             $cur_slot_prepare_days = ($slot_prepare_days == 0)?$slot_prepare_days+$stg_normalloc_upcounry_slot_generate_days:$slot_prepare_days+$stg_normalloc_upcounry_slot_generate_days-1;
  882.                             $cur_slot_prepare_days = (!empty($fastDelivery)) ? 0 : $cur_slot_prepare_days;
  884.                             $log_data = $api_log_info." | cur_slot_prepare_days:".json_encode($cur_slot_prepare_days);
  885.                             SELF::createApiLog($log_data);
  886.                             
  887.                             $delSlotTimesAvailibility = ['slot_prepare_days'=>$cur_slot_prepare_days,'slot_generate_days'=>$slot_generate_days,'saturday_slot_availability'=>$saturday_slot_availability,'sunday_slot_availability'=>$sunday_slot_availability];
  889.                             $log_data = $api_log_info." | delSlotTimesAvailibility:".json_encode($delSlotTimesAvailibility);
  890.                             SELF::createApiLog($log_data);
  891.                             
  892.                             $weekdates = self::getWeekDates($holidayDates, date("Y-m-d"), $delSlotTimesAvailibility);
  894.                             $log_data = $api_log_info." | weekdates:".json_encode($weekdates);
  895.                             SELF::createApiLog($log_data);
  896.                             // echo $cur_time." | ".$setting_slot_time_flag;
  897.                             // echo 'delSlotTimesAvailibility<pre>:';
  898.                             // print_r($delSlotTimesAvailibility);
  899.                             // echo 'weekdates<pre>:';
  900.                             // print_r($weekdates);die;
  901.                             //------- Get Week Dates based on Holidays and Slot Time data ---------//
  903.                             // $prepare_days = $delSlotTimes->getprepare_days();
  904.                             // $delSlot_date = ($prepare_days == 0)?$tomorrow_date:date('Y-m-d', strtotime($today_date . ' +'.$prepare_days.' day'));
  905.                             $delSlot_date = ($slot_prepare_days == 0)?$tomorrow_date:date('Y-m-d', strtotime($today_date . ' +'.$slot_prepare_days.' day'));
  907.                             if(!empty($fastDelivery)){
  909.                                 date_default_timezone_set('Asia/Kolkata');
  911.                                 $delSlot_date = date('Y-m-d');
  912.                                 
  913.                                 // Get the current hour
  914.                                 $currentHour = (int)date('H');
  916.                                 // Check if the current time is greater than 6 PM
  917.                                 if ($currentHour >= 18) {
  918.                                     // Add one day to the current date
  919.                                     $delSlot_date = date('Y-m-d', strtotime($delSlot_date . ' +1 day'));
  920.                                 }
  921.                             }
  923.                             $delSlot_date1 = date("Y-m-d", strtotime($delSlot_date));
  924.                             
  925.                             $cur_time_data = explode(" ",$cur_time);
  927.                             // $slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():0;
  929.                             // $slot_generate_days_limit = ($slot_generate_days > 0)?$slot_generate_days:1;
  930.                             $slot_generate_days_limit = ($cur_slot_generate_days > 0)?$cur_slot_generate_days:1;
  932.                             $log_data = $api_log_info." | delSlot_date:".json_encode($delSlot_date)."| delSlot_date1:".json_encode($delSlot_date1)."| cur_time_data:".json_encode($cur_time_data)."| slot_generate_days_limit:".json_encode($slot_generate_days_limit);
  933.                             SELF::createApiLog($log_data);
  935.                             // echo $tomorrow_date.":".$weekdates[0];
  936.                             /* if($cur_time > $setting_slot_time_flag)//if($cur_time > '18:00')
  937.                             {
  938.                                 // if($tomorrow_date >= $weekdates[0])
  939.                                 // {
  940.                                 //     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  941.                                 // } else {
  942.                                 //     $no_of_weekdates = count($weekdates);
  943.                                 //     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[$no_of_weekdates-1]])):[$weekdates[0]];
  944.                                 // }
  945.                                 
  946.                                 $no_of_weekdates = count($weekdates);
  947.                                 // $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[$no_of_weekdates-1]])):[$weekdates[0]];
  949.                                 $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  950.                             } else {
  951.                                 $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  952.                             } */
  954.                             /* if($settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'] == 'Yes' && $Is_location_up_country == 1)
  955.                             {
  956.                                 if($cur_time > $settingsInfo['stg_delslot_upcountryloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_upcountryloc_lessthaneq_totime'])
  957.                                 {
  958.                                     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  959.                                 } else {
  960.                                     $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  961.                                 }
  962.                                 if(($slot_generate_days > 0)){
  963.                                     for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days; $ii++)
  964.                                     {
  965.                                         $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  966.                                     }
  967.                                 } else 
  968.                                 $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  969.                                 
  970.                             } else {
  971.                                 $stg_normalloc_upcounry_slot_generate_days = ($cur_time > $settingsInfo['stg_delslot_upcountryloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_upcountryloc_lessthaneq_totime'])?$settingsInfo['stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays']:$settingsInfo['stg_delslot_upcountryloc_after_totime_extra_generate_slotdays'];
  972.                             } */
  974.                             /* if(($slot_generate_days > 0)){
  975.                                 for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days; $ii++)
  976.                                 {
  977.                                     $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  978.                                 }
  979.                             } else 
  980.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]]; */
  982.                             /*
  983.                             if(($slot_generate_days > 0)){
  984.                                 if($stg_normalloc_upcounry_slot_generate_days>1)
  985.                                 {
  986.                                     for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days-1; $ii++)
  987.                                     {
  988.                                         $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  989.                                     }
  990.                                 }
  992.                                 $cur_weekdates = [];
  993.                                 if($cur_slot_generate_days > 0){
  994.                                     for($jj=0; $jj < $cur_slot_generate_days; $jj++)
  995.                                     {
  996.                                         array_push($cur_weekdates,$weekdates[$jj]);
  997.                                     }
  998.                                 }
  1000.                                 $weekdates = $cur_weekdates;
  1002.                             } else 
  1003.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1005.                             */
  1007.                             $log_data = $api_log_info." | slot_generate_days:".json_encode($slot_generate_days)."| cur_slot_generate_days:".json_encode($cur_slot_generate_days);
  1008.                             SELF::createApiLog($log_data);
  1010.                             if(($slot_generate_days > 0)){
  1011.                                 $cur_weekdates = [];
  1012.                                 if($cur_slot_generate_days > 0){
  1013.                                     for($jj=0; $jj < $cur_slot_generate_days; $jj++)
  1014.                                     {
  1015.                                         $log_data = $api_log_info." | jj:".json_encode($jj)."| cur_weekdates:".json_encode($cur_weekdates)."| weekdates:".json_encode($weekdates);
  1016.                                         SELF::createApiLog($log_data);
  1018.                                         array_push($cur_weekdates,$weekdates[$jj]);
  1019.                                     }
  1020.                                 }
  1022.                                 $weekdates = $cur_weekdates;
  1024.                             } else 
  1025.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1027.                             $log_data = $api_log_info." | stg_normalloc_upcounry_slot_generate_days:".json_encode($stg_normalloc_upcounry_slot_generate_days)."| weekdates:".json_encode($weekdates);
  1028.                             SELF::createApiLog($log_data);
  1030.                             // $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  1032.                             // echo 'weekdates:<pre>:'; print_r($weekdates);
  1033.                             
  1034.                             $slot_generate_days_date  = date('Y-m-d', strtotime($today_date . ' +'.$slot_generate_days.' day'));
  1036.                             $delivery_modes = $setting_deliveryModes;//['standard','express'];//['courier','standard','express'];
  1038.                             $locationSlotRule = new DataObject\Deliveryslotrules\Listing();
  1039.                             $locationSlotRule->setCondition(" FIND_IN_SET('".$parentLoc_id."',location_ids) ");
  1040.                             $locationSlotRule = $locationSlotRule->getData();
  1042.                             if (count($locationSlotRule)) {
  1043.                                 $delivery_modes = array();
  1044.                                 foreach ($locationSlotRule as $slv) {
  1045.                                     $delivery_modes[] = $slv->getdelivery_mode();
  1046.                                 }
  1047.                             }
  1049.                             $log_data = $api_log_info." | slot_generate_days_date:".json_encode($slot_generate_days_date)."| delivery_modes:".json_encode($delivery_modes);
  1050.                             SELF::createApiLog($log_data);
  1052.                             $delivery_mode_slots_all = [];
  1053.                             foreach($delivery_modes as $delivery_mode)
  1054.                             {
  1055.                                 $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)."| delSlotTimes Title:".json_encode($delSlotTimes->gettitle());
  1056.                                 SELF::createApiLog($log_data);
  1058.                                 if($delSlotTimes->gettitle() == 'customized' && (!in_array($delivery_mode,['standard'])))
  1059.                                 {
  1060.                                     $delivery_mode_slots_all[$delivery_mode] = [];
  1061.                                 } else if($delSlotTimes->gettitle() == 'Confectionery' && (!in_array($delivery_mode,['standard','express'])))
  1062.                                 {
  1063.                                     $delivery_mode_slots_all[$delivery_mode] = [];
  1064.                                 } else {
  1065.                                     $slotsList = DataObject\Slots::getList();
  1067.                                     if($cur_time > $setting_slot_time_flag)//if($cur_time > '18:00')
  1068.                                     {
  1069.                                         $slotsList->setCondition("slotdate >= :tomdate AND delivery_mode = :delivery_mode AND loc_id = :parentLoc_id AND slotdate IN (:slotdates)", ["slotdate" => $today_date, "prior_time" => $cur_time, "delivery_mode" => $delivery_mode, "parentLoc_id" => $parentLoc_id, "tomdate" => $delSlot_date1, "slotdates" => $weekdates]);
  1070.                                     } else {
  1071.                                         if($delivery_mode == 'standard')
  1072.                                         {
  1073.                                             $slotsList->setCondition("((slotdate = :slotdate AND fromtime <= :prior_time AND totime >= :prior_time) || slotdate >= :tomdate) AND delivery_mode = :delivery_mode AND loc_id = :parentLoc_id AND slotdate IN (:slotdates)", ["slotdate" => $today_date, "prior_time" => $cur_time, "delivery_mode" => $delivery_mode, "parentLoc_id" => $parentLoc_id, "tomdate" => $delSlot_date1, "slotdates" => $weekdates]);
  1074.                                         } else
  1075.                                         {
  1076.                                             $slotsList->setCondition("((slotdate = :slotdate AND prior_time >= :prior_time) || slotdate >= :tomdate) AND delivery_mode = :delivery_mode AND loc_id = :parentLoc_id AND slotdate IN (:slotdates)", ["slotdate" => $today_date, "prior_time" => $cur_time, "delivery_mode" => $delivery_mode, "parentLoc_id" => $parentLoc_id, "tomdate" => $delSlot_date1, "slotdates" => $weekdates]);
  1077.                                         }
  1078.                                     }
  1080.                                     $slotsList->setOrderKey("slotdate");
  1081.                                     $slotsList->setOrder("asc");
  1082.                                     $slotsList->load();
  1084.                                     // if($slot_generate_days == 3)
  1085.                                     // {
  1086.                                     //     echo '<pre>';
  1087.                                     //     print_r($slotsList); die;
  1088.                                     // }
  1090.                                     /*---------- Slots Loop Starts ----------*/
  1091.                                     $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList))."| cur_slot_generate_days:".json_encode($cur_slot_generate_days);
  1092.                                     SELF::createApiLog($log_data);
  1094.                                     $delivery_mode_slots = [];
  1095.                                     if(count($slotsList) > 0 && $cur_slot_generate_days>0){
  1096.                                         foreach($slotsList as $slot)
  1097.                                         {
  1098.                                             $log_data = $api_log_info." | slot:".json_encode($slot);
  1099.                                             SELF::createApiLog($log_data);
  1101.                                             $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1102.                                             $loc_name = $slotLocationData->getlocation_name();
  1104.                                             $delivery_mode_slot1 = array(
  1105.                                                 "slotId" => $slot->getId(),
  1106.                                                 "prior_time" => $slot->getprior_time(),
  1107.                                                 "slotdate" => date("Y-m-d", strtotime($slot->getslotdate())),//$slot->getslotdate(),//$delSlot_date1,//
  1108.                                                 "loc_name" => $loc_name,
  1109.                                                 "fromtime" => $slot->getfromtime(),
  1110.                                                 "totime" => $slot->gettotime(),
  1111.                                                 "maxorder" => $slot->getmaxorder(),
  1112.                                                 "ordercount" => $slot->getordercount(),
  1113.                                                 "delivery_mode" => $slot->getdelivery_mode(),
  1114.                                             );
  1115.                                             array_push($delivery_mode_slots, $delivery_mode_slot1);
  1117.                                             $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1)."| delivery_mode_slots:".json_encode($delivery_mode_slots);
  1118.                                             SELF::createApiLog($log_data);
  1119.                                         }
  1120.                                     }
  1121.                                     /*---------- Slots Loop Starts ----------*/
  1123.                                     $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1125.                                     $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1126.                                     SELF::createApiLog($log_data);
  1128.                                     // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1129.                                     if ($fastDelivery) {
  1130.                                         $delivery_mode_slots_all[$delivery_mode] = (!empty($delivery_mode_slots[0]) ? array($delivery_mode_slots[0]) : array());
  1131.                                     } else {
  1132.                                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1133.                                     }
  1135.                                     $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)."| delivery_mode_slots:".json_encode($delivery_mode_slots);
  1136.                                     SELF::createApiLog($log_data);
  1137.                                 }
  1138.                             }
  1140.                             $data[] = array(
  1141.                                 // "LocationName" => $parentLocationName,
  1142.                                 // "LocationCode" => $parentLocationCode,
  1143.                                 // "Is_location_up_country" => $Is_location_up_country,
  1144.                                 "is_upcountry_configuration_applicable" => $is_upcountry_configuration_applicable,
  1145.                                 "stg_normalloc_upcounry_slot_generate_days" => $stg_normalloc_upcounry_slot_generate_days,
  1146.                                 "deliverytype_id" => $delSlotTimes->gettitle(),
  1147.                                 "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1148.                                 "prepare_days" => $slot_prepare_days,//$delSlotTimes->getprepare_days(),
  1149.                                 "slot_generate_days" => $cur_slot_generate_days,//$slot_generate_days,
  1150.                                 "delSlot_date" => $delSlot_date1,
  1151.                                 "slots"=>$delivery_mode_slots_all);
  1153.                                 $log_data = $api_log_info." | data:".json_encode($data);
  1154.                                 SELF::createApiLog($log_data);
  1156.                         }
  1157.                     } else $data[] = ['message'=>$message];
  1158.                 // }
  1159.             } else $data[] = ['message'=>$message];
  1160.             
  1161.         } else $data[] = ['message'=>$message];
  1163.         $return_data = ["success" => true, "Is_location_up_country" => $Is_location_up_country, "data" => $data];
  1165.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  1166.         SELF::createApiLog($log_data);
  1168.         return $this->json(["success" => true, "Is_location_up_country" => $Is_location_up_country, "data" => $data]);
  1169.     }
  1171.     /**
  1172.      * @Route("/api/allslots")
  1173.      */
  1174.     public function allslotsAction()
  1175.     {
  1176.         $api_log_info = "API:All Available Slots - ".date("YmdHis")." ".time();
  1177.         $log_data = "Started - ".$api_log_info;
  1178.         SELF::createApiLog($log_data);
  1180.         $message = SELF::verifyauthToken($api_log_info);
  1181.         $log_data = $api_log_info." | message:".json_encode($message);
  1182.         SELF::createApiLog($log_data);
  1184.         if($message == "No data found")
  1185.         {
  1186.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1187.             $delSlotTimesList->load();
  1189.             // $delivery_modes = ['courier','standard','express'];
  1190.             // $slotsList = DataObject\Slots::getList();
  1191.             // $slotsList->setCondition("delivery_mode = 'courier'");
  1192.             // // if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1193.             // //     $slotsList->filterBydelivery_mode($courier_mode, '=');
  1194.             // // }
  1195.             // $slotsList->load();
  1197.             // echo '<pre>kk'; print_r($slotsList); die;
  1199.             $log_data = $api_log_info." | delSlotTimesList count:".json_encode(count($delSlotTimesList));
  1200.             SELF::createApiLog($log_data);
  1202.             if(count($delSlotTimesList) > 0){
  1203.                 foreach($delSlotTimesList as $delSlotTimes)
  1204.                 {
  1205.                     $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  1206.                     SELF::createApiLog($log_data);
  1208.                     $prepare_days = $delSlotTimes->getprepare_days();
  1209.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1211.                     $delSlot_date1 = date("Y-m-d");//date("Y-m-d", strtotime($delSlot_date));
  1212.                     $cur_time = date("H:i");
  1214.                     // $delSlotTimes->delSlot_date = $delSlot_date;
  1216.                     $delivery_modes = ['courier','standard','express'];
  1218.                     $log_data = $api_log_info." | prepare_days:".json_encode($prepare_days)." | delSlot_date:".json_encode($delSlot_date)." | delSlot_date1:".json_encode($delSlot_date1)." | cur_time:".json_encode($cur_time)." | delivery_modes:".json_encode($delivery_modes);
  1219.                     SELF::createApiLog($log_data);
  1221.                     $delivery_mode_slots_all = [];
  1222.                     foreach($delivery_modes as $delivery_mode)
  1223.                     {
  1224.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode);
  1225.                         SELF::createApiLog($log_data);
  1227.                         $slotsList = DataObject\Slots::getList();
  1228.                         // $slotsList->setCondition("delivery_mode = '".$delivery_mode."'");
  1229.                         if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  1230.                             $slotsList->filterBySlotdate($delSlot_date1, '>=');
  1231.                         }
  1232.                         // if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  1233.                         //     $slotsList->filterByprior_time($cur_time, '>=');
  1234.                         // }
  1235.                         if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1236.                             $slotsList->filterBydelivery_mode($delivery_mode, '>=');
  1237.                         }
  1238.                         $slotsList->setLimit(100);
  1239.                         $slotsList->setOrderKey("slotdate");
  1240.                         $slotsList->setOrder("asc");
  1241.                         $slotsList->load();
  1243.                         /*---------- Slots Loop Starts ----------*/
  1244.                         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  1245.                         SELF::createApiLog($log_data);
  1247.                         $delivery_mode_slots = [];
  1248.                         if(count($slotsList) > 0){
  1249.                             foreach($slotsList as $slot)
  1250.                             {
  1251.                                 $log_data = $api_log_info." | slot:".json_encode($slot);
  1252.                                 SELF::createApiLog($log_data);
  1253.                                 // $loc_name = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_name():'';
  1254.                                 // $loc_code = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_code():'';
  1256.                                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1257.                                 $loc_name = $slotLocationData->getlocation_name();
  1258.                                 $loc_code = $slotLocationData->getlocation_code();
  1260.                                 $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData)." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  1261.                                 SELF::createApiLog($log_data);
  1263.                                 $delivery_mode_slot1 = array(
  1264.                                     "slotId" => $slot->getId(),
  1265.                                     "prior_time" => $slot->getprior_time(),
  1266.                                     // "picking_time" => $slot->getpicking_time(),
  1267.                                     // "charge" => $slot->getcharge(),
  1268.                                     "slotdate" => $slot->getslotdate(),
  1269.                                     "loc_name" => $loc_name,
  1270.                                     "loc_code" => $loc_code,
  1271.                                     "fromtime" => $slot->getfromtime(),
  1272.                                     "totime" => $slot->gettotime(),
  1273.                                     "maxorder" => $slot->getmaxorder(),
  1274.                                     "ordercount" => $slot->getordercount(),
  1275.                                     "delivery_mode" => $slot->getdelivery_mode()
  1276.                                 );
  1278.                                 $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1);
  1279.                                 SELF::createApiLog($log_data);
  1281.                                 array_push($delivery_mode_slots, $delivery_mode_slot1);
  1283.                                 $log_data = $api_log_info." | delivery_mode_slots:".json_encode($delivery_mode_slots);
  1284.                                 SELF::createApiLog($log_data);
  1285.                             }
  1286.                         }
  1287.                         /*---------- Slots Loop Starts ----------*/
  1289.                         $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1291.                         $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1292.                         SELF::createApiLog($log_data);
  1294.                         // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1295.                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1297.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)." | delivery_mode_slots_all:".json_encode($delivery_mode_slots_all);
  1298.                         SELF::createApiLog($log_data);
  1299.                     }
  1301.                     $data[] = array(
  1302.                         "deliverytype_id" => $delSlotTimes->gettitle(),
  1303.                         "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1304.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1305.                         "delSlot_date" => $delSlot_date,
  1306.                         "slots"=>$delivery_mode_slots_all);
  1307.                     
  1308.                     $log_data = $api_log_info." | data:".json_encode($data);
  1309.                     SELF::createApiLog($log_data);
  1311.                 }
  1312.             } else $data[] = [];
  1314.         } else $data[] = ['message'=>$message];
  1315.         $data = (empty($data))?$message:$data;
  1316.                 
  1317.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  1318.         SELF::createApiLog($log_data);
  1320.         return $this->json(["success" => true, "data" => $data]);
  1321.     }
  1323.     /*------------------------------ End of Slots Related APIs -------------------------*/
  1325.     /*---------------------------------- Delivery Slot Time Related APIs ----------------------------*/
  1326.     /**
  1327.      * @Route("/deliveryslottime/getslottimes")
  1328.      */
  1329.     public function getslottimesAction()
  1330.     {
  1331.         $api_log_info = "API:Retriving all Delivery Slot times / Confencery Days - ".date("YmdHis")." ".time();
  1332.         $log_data = "Started - ".$api_log_info;
  1333.         SELF::createApiLog($log_data);
  1335.         $message = SELF::verifyauthToken($api_log_info);
  1336.         $log_data = $api_log_info." | message:".json_encode($message);
  1337.         SELF::createApiLog($log_data);
  1338.         
  1339.         if($message == "No data found")
  1340.         {
  1341.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1342.             $delSlotTimesList->load();
  1344.             $log_data = $api_log_info." | delSlotTimesList Count ; ".count($delSlotTimesList);
  1345.             SELF::createApiLog($log_data);
  1347.             if(count($delSlotTimesList) > 0){
  1348.                 foreach($delSlotTimesList as $delSlotTimes)
  1349.                 {
  1350.                     $log_data = $api_log_info." | delSlotTimes ; ".json_encode($delSlotTimes);
  1351.                     SELF::createApiLog($log_data);
  1353.                     $prepare_days = $delSlotTimes->getprepare_days();
  1354.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1356.                     $data[] = array(
  1357.                         "title" => $delSlotTimes->gettitle(),
  1358.                         "deliverytype_id" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1359.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1360.                         "delSlot_date" => $delSlot_date);
  1362.                         $log_data = $api_log_info." | data ; ".json_encode($data);
  1363.                         SELF::createApiLog($log_data);
  1365.                 }
  1366.             } else $data = "No data found";
  1367.         }else $data[] = ['message'=>$message];
  1368.         $data = (empty($data))?$message:$data;
  1370.         $log_data = "Ended - ".$api_log_info." | data ; ".json_encode($data);
  1371.         SELF::createApiLog($log_data);
  1373.         return $this->json(["success" => true, "data" => $data]);
  1374.     }
  1376.     /**
  1377.      * @Route("/deliveryslottime/getslottimeslist")
  1378.      */
  1379.     public function getslottimeslistAction()
  1380.     {
  1381.         $api_log_info = "API:Retriving all Delivery Slots - ".date("YmdHis")." ".time();
  1382.         $log_data = "Started - ".$api_log_info;
  1383.         SELF::createApiLog($log_data);
  1385.         $message = SELF::verifyauthToken($api_log_info);
  1386.         $log_data = $api_log_info." | message:".json_encode($message);
  1387.         SELF::createApiLog($log_data);
  1388.         
  1389.         if($message == "No data found")
  1390.         {
  1391.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1392.             $delSlotTimesList->load();
  1394.             // $delivery_modes = ['courier','standard','express'];
  1395.             // $slotsList = DataObject\Slots::getList();
  1396.             // $slotsList->setCondition("delivery_mode = 'courier'");
  1397.             // // if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1398.             // //     $slotsList->filterBydelivery_mode($courier_mode, '=');
  1399.             // // }
  1400.             // $slotsList->load();
  1402.             // echo '<pre>kk'; print_r($slotsList); die;
  1404.             $log_data = $api_log_info." | delSlotTimesList:".json_encode(count($delSlotTimesList));
  1405.             SELF::createApiLog($log_data);
  1407.             if(count($delSlotTimesList) > 0){
  1408.                 foreach($delSlotTimesList as $delSlotTimes)
  1409.                 {
  1410.                     $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  1411.                     SELF::createApiLog($log_data);
  1413.                     $prepare_days = $delSlotTimes->getprepare_days();
  1414.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1416.                     $delSlot_date1 = date("Y-m-d", strtotime($delSlot_date));
  1417.                     $cur_time = date("H:i");
  1419.                     // $delSlotTimes->delSlot_date = $delSlot_date;
  1421.                     $delivery_modes = ['courier','standard','express'];
  1423.                     $log_data = $api_log_info." | prepare_days:".json_encode($prepare_days)." | delSlot_date:".json_encode($delSlot_date)." | delSlot_date1:".json_encode($delSlot_date1)." | cur_time:".json_encode($cur_time)." | delivery_modes:".json_encode($delivery_modes);
  1424.                     SELF::createApiLog($log_data);
  1426.                     $delivery_mode_slots_all = [];
  1427.                     foreach($delivery_modes as $delivery_mode)
  1428.                     {
  1429.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode);
  1430.                         SELF::createApiLog($log_data);
  1432.                         $slotsList = DataObject\Slots::getList();
  1433.                         // $slotsList->setCondition("delivery_mode = '".$delivery_mode."'");
  1434.                         if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  1435.                             $slotsList->filterBySlotdate($delSlot_date1, '=');
  1436.                         }
  1437.                         if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  1438.                             $slotsList->filterByprior_time($cur_time, '>=');
  1439.                         }
  1440.                         if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1441.                             $slotsList->filterBydelivery_mode($delivery_mode, '>=');
  1442.                         }
  1443.                         $slotsList->setLimit(100);
  1444.                         $slotsList->setOrderKey("slotdate");
  1445.                         $slotsList->setOrder("asc");
  1446.                         $slotsList->load();
  1448.                         /*---------- Slots Loop Starts ----------*/
  1450.                         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  1451.                         SELF::createApiLog($log_data);
  1453.                         $delivery_mode_slots = [];
  1454.                         if(count($slotsList) > 0){
  1455.                             foreach($slotsList as $slot)
  1456.                             {
  1457.                                 $log_data = $api_log_info." | slot:".json_encode($slot);
  1458.                                 SELF::createApiLog($log_data);
  1460.                                 // $loc_name = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_name():'';
  1461.                                 // $loc_code = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_code():'';
  1463.                                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1464.                                 $loc_name = $slotLocationData->getlocation_name();
  1465.                                 $loc_code = $slotLocationData->getlocation_code();
  1467.                                 $delivery_mode_slot1 = array(
  1468.                                     "slotId" => $slot->getId(),
  1469.                                     "prior_time" => $slot->getprior_time(),
  1470.                                     // "picking_time" => $slot->getpicking_time(),
  1471.                                     // "charge" => $slot->getcharge(),
  1472.                                     "slotdate" => $slot->getslotdate(),
  1473.                                     "loc_name" => $loc_name,
  1474.                                     "loc_code" => $loc_code,
  1475.                                     "fromtime" => $slot->getfromtime(),
  1476.                                     "totime" => $slot->gettotime(),
  1477.                                     "maxorder" => $slot->getmaxorder(),
  1478.                                     "ordercount" => $slot->getordercount(),
  1479.                                     "delivery_mode" => $slot->getdelivery_mode()
  1480.                                 );
  1481.                                 array_push($delivery_mode_slots, $delivery_mode_slot1);
  1483.                                 $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1)." | delivery_mode_slots:".json_encode($delivery_mode_slots);
  1484.                                 SELF::createApiLog($log_data);
  1485.                             }
  1486.                         }
  1487.                         /*---------- Slots Loop Starts ----------*/
  1489.                         $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1491.                         $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1492.                         SELF::createApiLog($log_data);
  1494.                         // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1495.                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1497.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)." | delivery_mode_slots_all:".json_encode($delivery_mode_slots_all);
  1498.                         SELF::createApiLog($log_data);
  1499.                     }
  1501.                     $data[] = array(
  1502.                         "deliverytype_id" => $delSlotTimes->gettitle(),
  1503.                         "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1504.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1505.                         "delSlot_date" => $delSlot_date,
  1506.                         "slots"=>$delivery_mode_slots_all);
  1507.                         
  1508.                     $log_data = $api_log_info." | data:".json_encode($data);
  1509.                     SELF::createApiLog($log_data);
  1511.                 }
  1512.             } else $data[] = [];
  1514.         }else $data[] = ['message'=>$message];
  1515.         $data = (empty($data))?$message:$data;
  1517.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  1518.         SELF::createApiLog($log_data);
  1520.         return $this->json(["success" => true, "data" => $data]);
  1521.     }
  1522.     /*------------------------------ End of Delivery Slot Time Related APIs -------------------------*/
  1524.     /*----------------------------------- AWS S3 Bucket Related APIs ---------------------------*/
  1525.     /**
  1526.      * @Route("/awss3bucket/gets3bucketlist")
  1527.      */
  1528.     public function gets3bucketlistAction()
  1529.     {
  1530.         putenv('AWS_DEFAULT_REGION=us-east-2');
  1531.         putenv('AWS_ACCESS_KEY_ID=AKIAUY45FDQLWT32YTPJ');
  1532.         putenv('AWS_SECRET_ACCESS_KEY=IyaHsvQqIdeyDvUrpmlm4T/xizd5999KCpuBP8vg');
  1534.         // $output = shell_exec('aws s3 ls');
  1535.         try
  1536.         {
  1537.             $output = shell_exec('aws s3api create-bucket --bucket snap2web-13 --region us-east-2 --create-bucket-configuration LocationConstraint=us-east-2');
  1538.         } catch(Exception $e)
  1539.         {
  1540.             echo $e->getMessage(); die;
  1541.         }
  1542.         // echo "<pre>$output</pre>";
  1544.         echo '<pre>'; print_r($output); die;
  1547.         return $this->json(["success" => true, "data" => $data]);
  1548.     }
  1550.     /**
  1551.      * @Route("/awss3bucket/uploadFileToS3")
  1552.      */
  1553.     public function uploadFileToS3()
  1554.     {
  1555.         $curl = curl_init();
  1557.         curl_setopt_array($curl, array(
  1558.         CURLOPT_URL => 'https://itc-test.s3.ap-south-1.amazonaws.com/public/test.txt?X-Amz-Expires=86400&X-Amz-Date=20230320T054345Z&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAUY45FDQLWT32YTPJ%252F20230320%252Fap-south-1%252Fs3%252Faws4_request&X-Amz-SignedHeaders=host&X-Amz-Signature=8911af2498f4c48c8b0192a17fa4b8261946d1a7bb482f901091fb96760b2181',
  1559.         CURLOPT_RETURNTRANSFER => true,
  1560.         CURLOPT_ENCODING => '',
  1561.         CURLOPT_MAXREDIRS => 10,
  1562.         CURLOPT_TIMEOUT => 0,
  1563.         CURLOPT_FOLLOWLOCATION => true,
  1564.         CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1565.         CURLOPT_CUSTOMREQUEST => 'PUT',
  1566.         CURLOPT_POSTFIELDS => "<file contents here>",
  1567.         CURLOPT_HTTPHEADER => array(
  1568.             'Content-Type: text/plain'
  1569.         ),
  1570.         ));
  1572.         $response = curl_exec($curl);
  1574.         curl_close($curl);
  1575.         echo $response;
  1577.     }
  1578.     /*------------------------------ End of AWS S3 Bucket Related APIs -------------------------*/
  1580.     /**
  1581.      * @Route("/user/login", methods={"POST"})
  1582.      */
  1583.     public function userLogin(Request $request)
  1584.     {
  1585.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  1586.         $userName = (isset($reqparams['username']))?$reqparams['username']:'';
  1587.         $password = (isset($reqparams['password']))?$reqparams['password']:'';
  1588.         if($userName == '' || $password == '')
  1589.         {
  1590.             $data = "Username and Password are mandatory!";
  1591.         } else {
  1592.             $user = User::getByName($userName);
  1593.             if($user) {
  1594.                 $validateUser = \Pimcore\Tool\Authentication::authenticatePlaintext($userName,$password);
  1595.                 if($validateUser) {
  1597.                     $userInfo = ['id'=>$validateUser->getId(),
  1598.                                 'firstname'=>$validateUser->getfirstname(),
  1599.                                 'lastname'=>$validateUser->getlastname(),
  1600.                                 'email'=>$validateUser->getemail(),
  1601.                                 ];
  1603.                     $generateAuthTokenInfo = SELF::generateAuthToken($userInfo);
  1604.                     $generateAuthToken = $generateAuthTokenInfo['generateAuthToken'];
  1605.                     $jwtToken = (!empty($generateAuthTokenInfo['jwt']))?$generateAuthTokenInfo['jwt']:'';
  1606.                     $userId = $validateUser->getId(); 
  1608.                     $dbConnection = \Pimcore\Db::get();
  1610.                     $dbConnection->query("UPDATE users SET `authToken` = ? WHERE id = ?", [$generateAuthToken, $userId]);
  1612.                     $userData = User::getById($userId);
  1613.                     $authTokenVal = $dbConnection->fetchOne("SELECT authToken FROM users WHERE id = ".$userId);
  1615.                     $data = ["message"=>'Login successfull', "authToken"=>$authTokenVal];
  1617.                     if($jwtToken!='')
  1618.                         $data = ["message"=>'Login successfull', "authToken"=>$authTokenVal, "jwtToken"=>$jwtToken];
  1619.                     
  1620.                 } else {
  1621.                     $data = 'Wrong password';
  1622.                 }
  1623.             } else {
  1624.                 $data = 'User not found';
  1625.             }
  1626.         }
  1628.         return $this->json(["success" => true, "data" => $data]);
  1629.     }
  1631.     /*---------------------------------- JWT Related APIs ----------------------------*/
  1632.     /**
  1633.      * @Route("/api/gernerateJwtToken")
  1634.      */
  1635.     public function gernerateJwtTokenAction()
  1636.     {
  1637.         $id = 1024;
  1638.         $firstname = 'Tex';
  1639.         $lastname = 'Hardrock';
  1640.         $email = 'dino@stone.age';
  1642.         $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  1643.         $issuer_claim = "pimcore6.local"; // this can be the servername
  1644.         $audience_claim = "Babu";
  1645.         $issuedat_claim = time(); // issued at
  1646.         $notbefore_claim = $issuedat_claim + 10; //not before in seconds
  1647.         $expire_claim = $issuedat_claim + 60; // expire time in seconds
  1648.         $token = array(
  1649.             "iss" => $issuer_claim,
  1650.             "aud" => $audience_claim,
  1651.             "iat" => $issuedat_claim,
  1652.             "nbf" => $notbefore_claim,
  1653.             "exp" => $expire_claim,
  1654.             "data" => array(
  1655.                 "id" => $id,
  1656.                 "firstname" => $firstname,
  1657.                 "lastname" => $lastname,
  1658.                 "email" => $email
  1659.         ));
  1661.         $jwt = JWT::encode($token, $secret_key, 'HS256');
  1662.         // echo json_encode(
  1663.         //     array(
  1664.         //         "message" => "Successful login.",
  1665.         //         "jwt" => $jwt,
  1666.         //         "email" => $email,
  1667.         //         "expireAt" => $expire_claim
  1668.         //     )); die;
  1670.         $data = array(
  1671.             "message" => "Successful login.",
  1672.             "jwt" => $jwt,
  1673.             "email" => $email,
  1674.             "expireAt" => $expire_claim
  1675.         );
  1676.         return $this->json(["success" => true, "data" => $data]);
  1677.     }
  1679.     /**
  1680.      * @Route("/api/verifyJwtToken")
  1681.      */
  1682.     public function verifyJwtTokenAction()
  1683.     {
  1684.         $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  1685.         $jwt = null;
  1686.         
  1687.         $data = json_decode(file_get_contents("php://input"));
  1689.         $authHeader = $_SERVER['HTTP_AUTHORIZATION'];
  1691.         $arr = explode(" ", $authHeader);
  1693.         $jwt = $arr[1];
  1695.         if($jwt){
  1697.             try {
  1698.                 $decoded = JWT::decode($jwt, new Key($secret_key, 'HS256'));
  1700.                 // Access is granted. Add code of the operation here 
  1702.                 $data = array(
  1703.                     "message" => "Access granted"
  1704.                 );
  1705.                 return $this->json(["success" => true, "data" => $data]);
  1707.             }catch (Exception $e){
  1709.                 $data = array(
  1710.                     "message" => "Access denied"
  1711.                 );
  1712.                 return $this->json(["success" => true, "data" => $data]);
  1713.             }
  1715.         }
  1716.     }
  1718.     /*------------------------------ End of JWT Related APIs -------------------------*/
  1720.     /*---------------------------------- Personal Statement Related APIs ----------------------------*/
  1722.     /**
  1723.      * @Route("personalitystatement/getperstmtlist", methods={"POST"})
  1724.      */
  1725.     public function getperstmtlistAction(Request $request)
  1726.     {
  1727.         $api_log_info = "API:Get Personality Statements list with or without params - ".date("YmdHis")." ".time();
  1728.         $log_data = "Started - ".$api_log_info;
  1729.         SELF::createApiLog($log_data);
  1731.         $message = SELF::verifyauthToken($api_log_info);
  1733.         $log_data = $api_log_info." | message:".json_encode($message);
  1734.         SELF::createApiLog($log_data);
  1736.         // $data[] = ['message'=>$message];
  1737.         $data = [];
  1738.         if($message == "No data found")
  1739.         {
  1740.             $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  1741.             // print_r($reqparams); die;
  1742.             // print_r($request->get->all());
  1744.             $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  1745.             SELF::createApiLog($log_data);
  1747.             $title = (isset($reqparams['title']))?$reqparams['title']:'';
  1748.             $gender = (isset($reqparams['gender']))?$reqparams['gender']:'';
  1749.             $standout_fitin = (isset($reqparams['standout_fitin']))?$reqparams['standout_fitin']:'';
  1750.             $describe_yourself = (isset($reqparams['describe_yourself']))?$reqparams['describe_yourself']:'';
  1751.             $occasion = (isset($reqparams['occasion']))?$reqparams['occasion']:'';
  1752.             $priceband = (isset($reqparams['priceband']))?$reqparams['priceband']:'';
  1753.             $blank1 = (isset($reqparams['blank1']))?$reqparams['blank1']:'';
  1754.             $blank2 = (isset($reqparams['blank2']))?$reqparams['blank2']:'';
  1756.             $log_data = $api_log_info." | title:".json_encode($title)." | gender:".json_encode($gender)." | standout_fitin:".json_encode($standout_fitin)." | describe_yourself:".json_encode($describe_yourself)." | occasion:".json_encode($occasion)." | priceband:".json_encode($priceband)." | blank1:".json_encode($blank1)." | blank2:".json_encode($blank2);
  1757.             SELF::createApiLog($log_data);
  1759.             $perstmtList = DataObject\Personalitystatements::getList();
  1761.             if($title || $blank1 || $blank2 || $priceband || $gender || $standout_fitin || $describe_yourself || $occasion)
  1762.             {
  1763.                 $whr_condition = " personality_statement != '' "; $whr_condition_array = [];
  1764.                 if($title){
  1765.                     $whr_condition .= " AND personality_statement = '".$title."'";
  1766.                 }
  1767.                 if($priceband){
  1768.                     $whr_condition .= " AND priceband = '".$priceband."'";
  1769.                 }
  1770.                 if($blank1){
  1771.                     $whr_condition .= " AND blank1 = '".$blank1."'";
  1772.                 }
  1773.                 if($blank2){
  1774.                     $whr_condition .= " AND blank2 = '".$blank2."'";
  1775.                 }
  1776.                 if($gender){
  1777.                     $whr_condition .= " AND gender LIKE '%,".$gender.",%'";
  1778.                 }
  1779.                 if($standout_fitin){
  1780.                     $whr_condition .= " AND standout_fitin LIKE '%,".$standout_fitin.",%'";
  1781.                 }
  1782.                 if($describe_yourself){
  1783.                     $whr_condition .= " AND describe_yourself LIKE '%,".$describe_yourself.",%'";
  1784.                 }
  1785.                 if($occasion){
  1786.                     $whr_condition .= " AND occasion LIKE '%,".$occasion.",%'";
  1787.                 }
  1789.                 // echo "whr_condition:".$whr_condition;
  1790.                 // echo "whr_condition_array:";
  1791.                 // print_r($whr_condition_array); die;
  1793.                 $log_data = $api_log_info." | whr_condition:".json_encode($whr_condition);
  1794.                 SELF::createApiLog($log_data);
  1796.                 $perstmtList->setCondition($whr_condition);
  1797.                 
  1798.             }
  1799.             
  1800.             $perstmtList->load();
  1802.             $log_data = $api_log_info." | perstmtList count:".json_encode(count($perstmtList));
  1803.             SELF::createApiLog($log_data);
  1805.             foreach ($perstmtList as $key => $perstmtObj) {
  1807.                 $log_data = $api_log_info." | perstmtObj:".json_encode($perstmtObj);
  1808.                 SELF::createApiLog($log_data);
  1810.                 $data[] = array(
  1811.                     "id" => $perstmtObj->getId(),
  1812.                     "personality_statement" => $perstmtObj->getpersonality_statement(),
  1813.                     "standout_fitin" => $perstmtObj->getstandout_fitin(),
  1814.                     "describe_yourself" => $perstmtObj->getdescribe_yourself(),
  1815.                     "occasion" => $perstmtObj->getoccasion(),
  1816.                     "priceband" => $perstmtObj->getpriceband(),
  1817.                     "blank2" => $perstmtObj->getblank2(),
  1818.                     "blank1" => $perstmtObj->getblank1());
  1820.                 $log_data = $api_log_info." | data:".json_encode($data);
  1821.                 SELF::createApiLog($log_data);
  1822.             }
  1823.         } else $data[] = ['message'=>$message];
  1824.         $data = (empty($data))?$message:$data;
  1825.         // return $slotsList;
  1826.         $return_data = ["success" => true, "data" => $data];
  1827.         $log_data = $api_log_info." | return_data:".json_encode($return_data);
  1828.         SELF::createApiLog($log_data);
  1829.         return $this->json(["success" => true, "data" => $data]);
  1830.     }
  1832.     /**
  1833.      * @Route("personalitystatement/perstmtlist")
  1834.      */
  1835.     public function perstmtlistAction()
  1836.     {
  1837.         $api_log_info = "API:Get All Personality Statements - ".date("YmdHis")." ".time();
  1838.         $log_data = "Started - ".$api_log_info;
  1839.         SELF::createApiLog($log_data);
  1841.         $message = SELF::verifyauthToken($api_log_info);
  1842.         $log_data = $api_log_info." | message:".json_encode($message);
  1843.         SELF::createApiLog($log_data);
  1845.         if($message == "No data found")
  1846.         {
  1847.             $perstmtList = DataObject\Personalitystatements::getList();
  1848.             $perstmtList->load();
  1850.             $log_data = $api_log_info." | perstmtList count:".json_encode(count($perstmtList));
  1851.             SELF::createApiLog($log_data);
  1853.             if(count($perstmtList)>0){
  1854.                 foreach ($perstmtList as $key => $perstmtObj) {
  1856.                     $log_data = $api_log_info." | perstmtObj:".json_encode($perstmtObj);
  1857.                     SELF::createApiLog($log_data);
  1859.                     $data[] = array(
  1860.                         "id" => $perstmtObj->getId(),
  1861.                         "personality_statement" => $perstmtObj->getpersonality_statement(),
  1862.                         "standout_fitin" => $perstmtObj->getstandout_fitin(),
  1863.                         "describe_yourself" => $perstmtObj->getdescribe_yourself(),
  1864.                         "occasion" => $perstmtObj->getoccasion(),
  1865.                         "priceband" => $perstmtObj->getpriceband(),
  1866.                         "blank2" => $perstmtObj->getblank2(),
  1867.                         "blank1" => $perstmtObj->getblank1());
  1869.                     $log_data = $api_log_info." | data:".json_encode($data);
  1870.                     SELF::createApiLog($log_data);
  1871.                 }
  1872.             } else $data[] = ['message'=>$message];
  1873.         } else $data[] = ['message'=>$message];
  1875.         $return_data = ["success" => true, "data" => $data];
  1876.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  1877.         SELF::createApiLog($log_data);
  1879.         return $this->json(["success" => true, "data" => $data]);
  1880.     }
  1882.     /**
  1883.      * @Route("personalitystatement/perstmtinfo/{id}")
  1884.      */
  1885.     public function perstmtinfoAction($id)
  1886.     {
  1887.         $api_log_info = "API:Get Personality Statement Info by ID - ".date("YmdHis")." ".time();
  1888.         $log_data = "Started - ".$api_log_info;
  1889.         SELF::createApiLog($log_data);
  1891.         $log_data = $api_log_info." | ID:".$id;
  1892.         SELF::createApiLog($log_data);
  1894.         $message = SELF::verifyauthToken($api_log_info);
  1896.         $log_data = $api_log_info." | message:".json_encode($message);
  1897.         SELF::createApiLog($log_data);
  1899.         if($message == "No data found")
  1900.         {
  1901.             $perstmtObject = DataObject\Personalitystatements::getById($id);
  1903.             $log_data = $api_log_info." | perstmtObject:".json_encode($perstmtObject);
  1904.             SELF::createApiLog($log_data);
  1906.             if(!empty($perstmtObject) && $perstmtObject->getpersonality_statement()){
  1907.                 $log_data = $api_log_info." | perstmtObject getpersonality_statement:".json_encode($perstmtObject->getpersonality_statement());
  1908.                 SELF::createApiLog($log_data);
  1910.                 $data[] = array(
  1911.                     "id" => $perstmtObject->getId(),
  1912.                     "personality_statement" => $perstmtObject->getpersonality_statement(),
  1913.                     "standout_fitin" => $perstmtObject->getstandout_fitin(),
  1914.                     "describe_yourself" => $perstmtObject->getdescribe_yourself(),
  1915.                     "occasion" => $perstmtObject->getoccasion(),
  1916.                     "priceband" => $perstmtObject->getpriceband(),
  1917.                     "blank2" => $perstmtObject->getblank2(),
  1918.                     "blank1" => $perstmtObject->getblank1());
  1920.                 $log_data = $api_log_info." | data:".json_encode($data);
  1921.                 SELF::createApiLog($log_data);
  1923.             } else $data[] = ['message'=>$message];
  1924.         } else $data[] = ['message'=>$message];
  1926.         $returnData = ["success" => true, "data" => $data];
  1928.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  1929.         SELF::createApiLog($log_data);
  1931.         return $this->json(["success" => true, "data" => $data]);
  1932.     }
  1934.     /*------------------------------ End of Personal Statement Related APIs -------------------------*/
  1936.     /*---------------------------------- Shipping Rate / Delivery Fee Related APIs ----------------------------*/
  1938.     /**
  1939.      * @Route("api/shippingchargeslist")
  1940.      */
  1941.     public function shippingchargeslistAction()
  1942.     {
  1943.         $api_log_info = "API:Get Shipping Charges List - ".date("YmdHis")." ".time();
  1944.         $log_data = "Started - ".$api_log_info;
  1945.         SELF::createApiLog($log_data);
  1947.         $message = SELF::verifyauthToken($api_log_info);
  1949.         $log_data = $api_log_info." | message:".json_encode($message);
  1950.         SELF::createApiLog($log_data);
  1952.         if($message == "No data found")
  1953.         {
  1954.             $shippingchargesList = DataObject\Shippingcharges::getList();
  1955.             $shippingchargesList->load();
  1957.             $log_data = $api_log_info." | shippingchargesList count:".json_encode(count($shippingchargesList));
  1958.             SELF::createApiLog($log_data);
  1960.             if(count($shippingchargesList)>0){
  1961.                 foreach ($shippingchargesList as $key => $shippingchargeObj) {
  1963.                     $log_data = $api_log_info." | shippingchargeObj:".json_encode($shippingchargeObj);
  1964.                     SELF::createApiLog($log_data);
  1966.                     $data[] = array(
  1967.                         "id" => $shippingchargeObj->getId(),
  1968.                         "minimum_order" => $shippingchargeObj->getminimum_order(),
  1969.                         "maximum_order" => $shippingchargeObj->getmaximum_order(),
  1970.                         "discount_percentage" => $shippingchargeObj->getdiscount_percentage(),
  1971.                         "location" => $shippingchargeObj->getlocationId()->getLocation_name());
  1973.                     $log_data = $api_log_info." | data:".json_encode($data);
  1974.                     SELF::createApiLog($log_data);
  1975.                 }
  1976.             } else $data[] = ['message'=>$message];
  1977.         } else $data[] = ['message'=>$message];
  1979.         $returnData = ["success" => true, "data" => $data];
  1981.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  1982.         SELF::createApiLog($log_data);
  1984.         return $this->json(["success" => true, "data" => $data]);
  1985.     }
  1987.     /**
  1988.      * @Route("api/shippingrateslist", methods={"POST"})
  1989.      */
  1990.     public function shippingrateslistAction()
  1991.     {
  1993.         $api_log_info = "API:Shipping Rate / Delivery Fee List - ".date("YmdHis")." ".time();
  1994.         $log_data = "Started - ".$api_log_info;
  1995.         SELF::createApiLog($log_data);
  1997.         $message = SELF::verifyauthToken($api_log_info);
  1998.         $log_data = $api_log_info." | message:".json_encode($message);
  1999.         SELF::createApiLog($log_data);
  2001.         if($message == "No data found")
  2002.         {
  2003.             $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2004.             $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2005.             SELF::createApiLog($log_data);
  2007.             $weight_cart = (isset($reqparams['weight_cart']))?$reqparams['weight_cart']:'';
  2008.             $req_weight_cart = $weight_cart;
  2009.             $locationCode = (isset($reqparams['locationCode']))?$reqparams['locationCode']:'';
  2010.             $shipping_state_code = (isset($reqparams['shipping_state_code']))?$reqparams['shipping_state_code']:'';
  2011.             $pincode = (isset($reqparams['pincode']))?$reqparams['pincode']:'';
  2012.             $order_amount = (isset($reqparams['order_amount']))?$reqparams['order_amount']:'';
  2014.             $log_data = $api_log_info." | weight_cart:".json_encode($weight_cart)." | req_weight_cart:".json_encode($req_weight_cart)." | locationCode:".json_encode($locationCode)." | shipping_state_code:".json_encode($shipping_state_code)." | pincode:".json_encode($pincode)." | order_amount:".json_encode($order_amount);
  2015.             SELF::createApiLog($log_data);
  2017.             if($weight_cart == '' || $locationCode == '' || $shipping_state_code == '' || $pincode == '' || $order_amount == '')
  2018.             {
  2019.                 $data = "weight_cart, locationCode, shipping_state_code, pincode and order_amount are mandatory!";
  2021.                 $log_data = $api_log_info." | data:".json_encode($data);
  2022.                 SELF::createApiLog($log_data);
  2023.             } else {
  2024.                 /*------ Get Shipping Rate Card Class data --------*/
  2025.                 $dbConnection = \Pimcore\Db::get();
  2026.                 $shippingRatecardClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Shippingratecards' ");
  2027.                 $shippingRatecardObject = "object_".$shippingRatecardClassId;
  2029.                 $log_data = $api_log_info." | shippingRatecardObject:".json_encode($shippingRatecardObject);
  2030.                 SELF::createApiLog($log_data);
  2032.                 // $shippingRatecardId = $dbConnection->fetchOne(" select * from object_12 order by abs(no_of_kgs - ".$weight_cart.")");
  2033.                 $shippingRatecardId = $dbConnection->fetchOne(" select * from ".$shippingRatecardObject." order by abs(no_of_kgs - ".$weight_cart.")");
  2035.                 $log_data = $api_log_info." | shippingRatecardId:".json_encode($shippingRatecardId);
  2036.                 SELF::createApiLog($log_data);
  2037.                 /*----- End of ---------*/
  2038.                 /*---- Check Location by Location Code ---------*/
  2039.                 $locData = DataObject\Locations::getBylocation_code($locationCode, 1);
  2040.                 $pincodeInfo = DataObject\ItcAddPincode::getBypincode($pincode, 1);
  2041.                 $stateInfo = DataObject\States::getBystate_code($shipping_state_code, 1);
  2042.                 $shipChargeInfo = DataObject\Shippingratecards::getById($shippingRatecardId); //DataObject\Shippingratecards::getByno_of_kgs($weight_cart, 1);
  2044.                 $log_data = $api_log_info." | locData:".json_encode($locData)." | pincodeInfo:".json_encode($pincodeInfo)." | stateInfo:".json_encode($stateInfo)." | shipChargeInfo:".json_encode($shipChargeInfo);
  2045.                 SELF::createApiLog($log_data);
  2047.                 if(empty($locData) || empty($locData->getId()) || empty($pincodeInfo) || empty($pincodeInfo->getId()) || empty($shipChargeInfo) || empty($shipChargeInfo->getId()))// || empty($stateInfo) || empty($stateInfo->getId()) 
  2048.                 {
  2049.                     if(empty($locData) || empty($locData->getId()))
  2050.                         $message = "Location is not exited, please try with valid location code!";
  2051.                     
  2052.                     if(empty($pincodeInfo) || empty($pincodeInfo->getId()))
  2053.                         $message = "Pincode is not exited, please try with valid pincode!";
  2054.                 
  2055.                     if(empty($shipChargeInfo) || empty($shipChargeInfo->getId()))
  2056.                         $message = "Shipping Charge is not exited for ".$weight_cart." Kgs, please try with valid No of Kgs!";
  2058.                     $data[] = ['message'=>$message];
  2059.                     
  2060.                     $log_data = $api_log_info." | data:".json_encode($data);
  2061.                     SELF::createApiLog($log_data);
  2063.                 } else {
  2064.                     $locationId = $locData->getId();
  2065.                     $locationName = $locData->getLocation_name();
  2066.                     $message = SELF::verifyauthToken();
  2067.                     
  2068.                     $log_data = $api_log_info." | locationId:".json_encode($locationId)." | locationName:".json_encode($locationName)." | message:".json_encode($message);
  2069.                     SELF::createApiLog($log_data);
  2071.                     if($message == "No data found")
  2072.                     {
  2073.                         /*------ Check Location is Up Country or not --------*/
  2074.                         $Is_location_up_country = (strpos(strtolower($locationName),"up country"))?1:0;
  2075.                     
  2076.                         $log_data = $api_log_info." | Is_location_up_country:".json_encode($Is_location_up_country);
  2077.                         SELF::createApiLog($log_data);
  2078.         
  2079.                         /*------ Get Settings Class, Object and ID data --------*/
  2080.                         $dbConnection = \Pimcore\Db::get();
  2081.                         $settingsClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Settings' ");
  2082.                         $settingsObject = "object_".$settingsClassId;
  2083.                     
  2084.                         $log_data = $api_log_info." | settingsObject:".json_encode($settingsObject);
  2085.                         SELF::createApiLog($log_data);
  2087.                         $settingsObjectId = $dbConnection->fetchOne("select * from ".$settingsObject." order by oo_id asc");
  2088.                     
  2089.                         $log_data = $api_log_info." | settingsObjectId:".json_encode($settingsObjectId);
  2090.                         SELF::createApiLog($log_data);
  2092.                         /*---- Get Settings Data ---------*/
  2093.                         $settingsData = DataObject\Settings::getById($settingsObjectId);
  2095.                         $log_data = $api_log_info." | settingsData:".json_encode($settingsData);
  2096.                         SELF::createApiLog($log_data);
  2098.                         // echo '<pre>settingsObjectId:'.$settingsObjectId;
  2099.                         // echo '<pre>settingsData:';
  2100.                         // print_r($settingsData->getis_deliveryfee_config_applicable());
  2102.                         $is_shippingapplicable=$pincodeInfo->getis_shipping_applicable();
  2103.                     
  2104.                         $log_data = $api_log_info." | is_shippingapplicable:".json_encode($is_shippingapplicable);
  2105.                         SELF::createApiLog($log_data);
  2107.                         $pincode_data['pincode'] = $pincodeInfo->getpincode();
  2108.                         $pincode_data['state'] = $pincodeInfo->getstate();
  2109.                         $pincode_data['is_shipping_applicable'] = $pincodeInfo->getis_shipping_applicable();
  2110.                         $pincode_data['deliverytype'] = $pincodeInfo->getdeliverytype();
  2111.                     
  2112.                         $log_data = $api_log_info." | pincode_data:".json_encode($pincode_data);
  2113.                         SELF::createApiLog($log_data);
  2114.                         /*----------- End of Check Is Shipping Applicable or Not based on Pincode from Pincode Table ----------*/
  2116.                         /*------------- Get Shipping Discount Based on Is Shipping Applicable Fee Shipping Rule(Shipping Charges) Table------------*/
  2117.                         $final_cost=0; $rate_discount_perc=0; $cur_noofkgs = $shipChargeInfo->getno_of_kgs();
  2118.                         $zone_name=(!empty($stateInfo) && $stateInfo->getZoneId())?$stateInfo->getZoneId()->getzone_name():'';
  2119.                     
  2120.                         $log_data = $api_log_info." | final_cost:".json_encode($final_cost)." | rate_discount_perc:".json_encode($rate_discount_perc)." | cur_noofkgs:".json_encode($cur_noofkgs)." | zone_name:".json_encode($zone_name);
  2121.                         SELF::createApiLog($log_data);
  2122.                         /*----------- End of Get Zone based on State Code from States Table ----------*/
  2124.                         /*------------- Get Shipping rate data based on state code and weight cart ------------*/
  2125.                         $shippingratesList = DataObject\Shippingratecards::getList();
  2126.                         if ($shippingratesList->getClass()->getFieldDefinition('no_of_kgs')->isFilterable()) {
  2127.                             $shippingratesList->filterByno_of_kgs($cur_noofkgs, '=');
  2128.                         }
  2129.                         $shippingratesList->setOrderKey("no_of_kgs");
  2130.                         $shippingratesList->setOrder("desc");
  2131.                         $shippingratesList->load();
  2132.                     
  2133.                         $log_data = $api_log_info." | shippingratesList count:".json_encode(count($shippingratesList));
  2134.                         SELF::createApiLog($log_data);
  2136.                         if(count($shippingratesList)>0){
  2137.                             $ii=0;
  2138.                             foreach ($shippingratesList as $key => $shippingrateObj) {
  2139.                     
  2140.                                 $log_data = $api_log_info." | key:".json_encode($key)." | shippingrateObj:".json_encode($shippingrateObj);
  2141.                                 SELF::createApiLog($log_data);
  2143.                                 $data_key = $data_val = $data_key2 = $data_val2 = '';
  2144.                                 $data[] = array(
  2145.                                     "id" => $shippingrateObj->getId(),
  2146.                                     "no_of_kgs" => $req_weight_cart,
  2147.                                     "inter_region_cost" => $shippingrateObj->getintera_region_cost(),
  2148.                                     "j_k_cost" => $shippingrateObj->getj_and_k_cost(),
  2149.                                     "ne_and_andaman_cost" => $shippingrateObj->getne_and_andaman()
  2150.                                 );
  2151.                     
  2152.                                 $log_data = $api_log_info." | Initialise data_key, data_val, data_key2 and data_val2 values as null | data:".json_encode($data);
  2153.                                 SELF::createApiLog($log_data);
  2154.                                 
  2155.                                 if($is_shippingapplicable == 'Yes')
  2156.                                 {
  2157.                                     if($zone_name == 'J and K')
  2158.                                     {
  2159.                                         $final_cost = $shippingrateObj->getj_and_k_cost();
  2160.                                     }
  2161.                                     else if($zone_name == 'NE and Andaman')
  2162.                                     {
  2163.                                         $final_cost = $shippingrateObj->getne_and_andaman();  
  2164.                                     }
  2165.                                     else 
  2166.                                     {
  2167.                                         $final_cost = $shippingrateObj->getintera_region_cost();
  2168.                                     }
  2169.                                 }
  2171.                                 $log_data = $api_log_info." | zone_name:".json_encode($zone_name)." | final_cost:".json_encode($final_cost);
  2172.                                 SELF::createApiLog($log_data);
  2174.                                 $data[$ii]['locationCode'] = $locationCode;
  2175.                                 $data[$ii]['pincode'] = $pincode_data;
  2176.                     
  2177.                                 $log_data = $api_log_info." | ii:".json_encode($ii)." | data:".json_encode($data);
  2178.                                 SELF::createApiLog($log_data);
  2179.                                 
  2180.                             }
  2181.                             $minimum_order = $maximum_order = $discount_percentage = 0; $shippingRules = [];
  2182.                     
  2183.                             $log_data = $api_log_info." | Initialise minimum_order, maximum_order, discount_percentage and shippingRules values as null | is_shippingapplicable:".json_encode($is_shippingapplicable);
  2184.                             SELF::createApiLog($log_data);
  2185.                             
  2186.                             if($is_shippingapplicable == 'Yes')//&& $loc_code_error == ''
  2187.                             {
  2188.                                 $shippingchargesList = DataObject\Shippingcharges::getList();
  2189.                                 $shippingchargesList->setCondition("locationId__Id = ? AND (minimum_order <= ? AND maximum_order >= ?)",[$locationId, $order_amount, $order_amount]);
  2190.                                 $shippingchargesList->load();
  2191.                     
  2192.                                 $log_data = $api_log_info." | shippingchargesList count:".json_encode(count($shippingchargesList));
  2193.                                 SELF::createApiLog($log_data);
  2195.                                 if(count($shippingchargesList)>0)
  2196.                                 {
  2197.                                     foreach($shippingchargesList as $shippingchargeObj)
  2198.                                     {
  2199.                                         $log_data = $api_log_info." | shippingchargeObj:".json_encode($shippingchargeObj);
  2200.                                         SELF::createApiLog($log_data);
  2202.                                         $minimum_order = $shippingchargeObj->getminimum_order();
  2203.                                         $maximum_order = $shippingchargeObj->getmaximum_order();
  2204.                                         $discount_percentage = $shippingchargeObj->getdiscount_percentage();
  2206.                                         $log_data = $api_log_info." | minimum_order:".json_encode($minimum_order)." | maximum_order:".json_encode($maximum_order)." | discount_percentage:".json_encode($discount_percentage);
  2207.                                         SELF::createApiLog($log_data);
  2209.                                         $shippingRules['shippingRuleId'] = $shippingchargeObj->getId();
  2210.                                         $shippingRules['minimum_order_amount'] = $minimum_order;
  2211.                                         $shippingRules['maximum_order_amount'] = $maximum_order;
  2212.                                         $shippingRules['discount_percentage'] = $discount_percentage;
  2214.                                         $log_data = $api_log_info." | shippingRules:".json_encode($shippingRules);
  2215.                                         SELF::createApiLog($log_data);
  2216.                                     }
  2217.                                     $data[$ii]['shippingRules'] = $shippingRules;
  2219.                                     $log_data = $api_log_info." | ii:".json_encode($ii)." | data:".json_encode($data);
  2220.                                     SELF::createApiLog($log_data);
  2222.                                     $rate_discount_perc = ($minimum_order <= $order_amount && $maximum_order >= $order_amount)?$discount_percentage:0;
  2224.                                     $final_cost = $final_cost - (($final_cost*$rate_discount_perc)/100);
  2226.                                     $log_data = $api_log_info." | rate_discount_perc:".json_encode($rate_discount_perc)." | final_cost:".json_encode($final_cost);
  2227.                                     SELF::createApiLog($log_data);
  2228.                                 }
  2229.                                 
  2230.                             }
  2232.                             /*----------- Delivery Fee Configuration Condition --------------*/
  2234.                             $log_data = $api_log_info." | settingsData getis_deliveryfee_config_applicable:".json_encode($settingsData->getis_deliveryfee_config_applicable());
  2235.                             SELF::createApiLog($log_data);
  2237.                             if($settingsData->getis_deliveryfee_config_applicable() == 'Yes')
  2238.                             {
  2239.                                 $stg_deliveryfee_config = $settingsData->getdeliveryfee_config();
  2240.                                 $stg_deliveryfee_config_location_lessthan_charge = $settingsData->getdeliveryfee_config_location_lessthan_charge();
  2241.                                 $stg_deliveryfee_config_location_greaterthanequal_charge = $settingsData->getdeliveryfee_config_location_greaterthanequal_charge();
  2242.                                 $stg_deliveryfee_config_upcountry_lessthan_charge = $settingsData->getdeliveryfee_config_upcountry_lessthan_charge();
  2243.                                 $stg_deliveryfee_config_upcountry_greaterthanequal_charge = $settingsData->getdeliveryfee_config_upcountry_greaterthanequal_charge();
  2245.                                 $log_data = $api_log_info." | stg_deliveryfee_config:".json_encode($stg_deliveryfee_config)." | stg_deliveryfee_config_location_lessthan_charge:".json_encode($stg_deliveryfee_config_location_lessthan_charge)." | stg_deliveryfee_config_location_greaterthanequal_charge:".json_encode($stg_deliveryfee_config_location_greaterthanequal_charge)." | stg_deliveryfee_config_upcountry_lessthan_charge:".json_encode($stg_deliveryfee_config_upcountry_lessthan_charge)." | stg_deliveryfee_config_upcountry_greaterthanequal_charge:".json_encode($stg_deliveryfee_config_upcountry_greaterthanequal_charge);
  2246.                                 SELF::createApiLog($log_data);
  2248.                                 if($Is_location_up_country == 0 && $order_amount < $stg_deliveryfee_config && $stg_deliveryfee_config_location_lessthan_charge != -1) $final_cost = $stg_deliveryfee_config_location_lessthan_charge;
  2249.                                 else if($Is_location_up_country == 0 && $order_amount >= $stg_deliveryfee_config && $stg_deliveryfee_config_location_greaterthanequal_charge != -1) $final_cost = $stg_deliveryfee_config_location_greaterthanequal_charge;
  2250.                                 else if($Is_location_up_country == 1 && $order_amount < $stg_deliveryfee_config && $stg_deliveryfee_config_upcountry_lessthan_charge != -1) $final_cost = $stg_deliveryfee_config_upcountry_lessthan_charge;
  2251.                                 else if($Is_location_up_country == 1 && $order_amount >= $stg_deliveryfee_config && $stg_deliveryfee_config_upcountry_greaterthanequal_charge != -1) $final_cost = $stg_deliveryfee_config_upcountry_greaterthanequal_charge;
  2252.                                 else $final_cost = $final_cost;
  2254.                                 $log_data = $api_log_info." | final_cost:".json_encode($final_cost);
  2255.                                 SELF::createApiLog($log_data);
  2256.                             }
  2257.                             
  2258.                             $data[$ii]['final_cost'] = $final_cost;
  2260.                             // 2 hours fast delivery code
  2261.                             if($is_shippingapplicable == 'Yes')
  2262.                             {
  2263.                                 $fdsett = DataObject\FastDeliverySetting::getList();
  2264.                                 $fdsett->setCondition("locationId__Id = ?",[$locationId]);
  2265.                                 $fdsett->load();
  2267.                                 $data[$ii]['platform_fee'] = 0;
  2268.                                 $data[$ii]['low_order_fee'] = 0;
  2270.                                 if(count($fdsett->getData()) > 0) {
  2271.                                     $fdsett = $fdsett->getData()[0];
  2273.                                     $data[$ii]['platform_fee'] = $fdsett->getplatFormFee();
  2274.                                     $cartValue = $fdsett->getcartValue();
  2276.                                     if($cartValue > $order_amount) {
  2277.                                         $data[$ii]['low_order_fee'] = $fdsett->getminLowOrderFee();
  2278.                                     } else {
  2279.                                         $data[$ii]['low_order_fee'] = $fdsett->getlowOrderFee();
  2280.                                     }
  2281.                                 }
  2282.                             }
  2284.                             $log_data = $api_log_info." | final_cost:".json_encode($final_cost)." | ii:".json_encode($ii)." | data:".json_encode($data);
  2285.                             SELF::createApiLog($log_data);
  2287.                         } else $data[] = ['message'=>$message];
  2288.                         /*----------- End of Get Shipping rate data based on state code and weight cart ----------*/
  2290.                     } else $data[] = ['message'=>$message];
  2291.                 }
  2292.             }
  2293.         } else $data[] = ['message'=>$message];
  2295.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2296.         SELF::createApiLog($log_data);
  2298.         return $this->json(["success" => true, "data" => $data]);
  2299.     }
  2301.     /*------------------------------ End of Shipping Rate / Delivery Fee Related APIs -------------------------*/
  2303.     /*---------------------------------- Factory Related APIs ----------------------------*/
  2305.     /**
  2306.      * @Route("/factory/getfactories")
  2307.      */
  2308.     public function getfactories()
  2309.     {
  2310.         $api_log_info = "API:Get All Factories - ".date("YmdHis")." ".time();
  2311.         $log_data = "Started - ".$api_log_info;
  2312.         SELF::createApiLog($log_data);
  2314.         $message = SELF::verifyauthToken($api_log_info);
  2316.         $log_data = $api_log_info." | message:".json_encode($message);
  2317.         SELF::createApiLog($log_data);
  2319.         if($message == "No data found")
  2320.         {
  2321.             $factoriesList = DataObject\Factories::getList();
  2322.             $factoriesList->load();
  2324.             $log_data = $api_log_info." | factoriesList count:".json_encode(count($factoriesList));
  2325.             SELF::createApiLog($log_data);
  2327.             if(count($factoriesList) > 0){
  2328.                 foreach ($factoriesList as $key => $blog) {
  2330.                     $log_data = $api_log_info." | key:".json_encode($key)." | blog:".json_encode($blog);
  2331.                     SELF::createApiLog($log_data);
  2333.                     $bestbefore_date = '';
  2335.                     if($blog->getbestbefore()){
  2336.                         $bestbefore_dt = date("m/d/y", strtotime($blog->getbestbefore()));
  2337.                         $bestbefore_date = Carbon::createFromFormat('m/d/y', $bestbefore_dt);
  2339.                         $log_data = $api_log_info." | bestbefore_dt:".json_encode($bestbefore_dt)." | bestbefore_date:".json_encode($bestbefore_date);
  2340.                         SELF::createApiLog($log_data);
  2341.                     }
  2342.                     $data[] = array(
  2343.                         "code" => $blog->getcode(),
  2344.                         "name" => $blog->getname(),
  2345.                         "address" => $blog->getaddress(),
  2346.                         "street" => $blog->getstreet(),
  2347.                         "landmark" => $blog->getlandmark(),
  2348.                         "city" => $blog->getcity(),
  2349.                         "state" => $blog->getstate(),
  2350.                         "country" => $blog->getcountry(),
  2351.                         "pincode" => $blog->getpincode(),
  2352.                         "bestbefore" => $bestbefore_date);
  2354.                     $log_data = $api_log_info." | data:".json_encode($data);
  2355.                     SELF::createApiLog($log_data);
  2356.                 }
  2357.             } else $data[] = ['message'=>$message];
  2358.         } else $data[] = ['message'=>$message];
  2360.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2361.         SELF::createApiLog($log_data);
  2362.         
  2363.         return $this->json(["success" => true, "data" => $data]);
  2364.     }
  2366.     /**
  2367.      * @Route("api/getfactorydata", methods={"POST"})
  2368.      */
  2369.     public function getfactorydataAction(Request $request)
  2370.     {
  2371.         $api_log_info = "API:Get factory Info by Code - ".date("YmdHis")." ".time();
  2372.         $log_data = "Started - ".$api_log_info;
  2373.         SELF::createApiLog($log_data);
  2375.         $factorycode = $request->get('factorycode');
  2377.         $log_data = $api_log_info." | factorycode:".json_encode($factorycode);
  2378.         SELF::createApiLog($log_data);
  2380.         if($factorycode == "")
  2381.         {
  2382.             $data = "Factory Code is mandatory!";
  2384.             $log_data = $api_log_info." | data:".json_encode($data);
  2385.             SELF::createApiLog($log_data);
  2386.         } else 
  2387.         {
  2388.             $data = SELF::verifyauthToken($api_log_info);
  2390.             $log_data = $api_log_info." | data:".json_encode($data);
  2391.             SELF::createApiLog($log_data);
  2393.             if($data == "No data found")
  2394.             {
  2395.                 /*---- Check Factory by Code ---------*/
  2396.                 $factoryData = DataObject\Factories::getBycode($factorycode, 1);
  2398.                 $log_data = $api_log_info." | factoryData:".json_encode($factoryData);
  2399.                 SELF::createApiLog($log_data);
  2401.                 if(!empty($factoryData) && $factoryData->getId()){
  2402.                         
  2403.                     $log_data = $api_log_info." | factoryData getId:".json_encode($factoryData->getId());
  2404.                     SELF::createApiLog($log_data);
  2406.                     $data = array(
  2407.                         "id" => $factoryData->getId(),
  2408.                         "code" => $factoryData->getCode(),
  2409.                         "name" => $factoryData->getname(),
  2410.                         "address" => $factoryData->getaddress(),
  2411.                         "street" => $factoryData->getstreet(),
  2412.                         "landmark" => $factoryData->getlandmark(),
  2413.                         "city" => $factoryData->getcity(),
  2414.                         "state" => $factoryData->getstate(),
  2415.                         "country" => $factoryData->getcountry(),
  2416.                         "pincode" => $factoryData->getpincode(),
  2417.                         "bestbefore" => $factoryData->getbestbefore());
  2419.                     $log_data = $api_log_info." | data:".json_encode($data);
  2420.                     SELF::createApiLog($log_data);
  2421.                 } else {
  2422.                     $data = "No data found!";
  2423.                     $log_data = $api_log_info." | data:".json_encode($data);
  2424.                     SELF::createApiLog($log_data);
  2425.                 }
  2426.             }
  2427.         }
  2429.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2430.         SELF::createApiLog($log_data);
  2432.         return $this->json(["success" => true, "data" => $data]);
  2433.     }
  2435.     /**
  2436.      * @Route("api/getfactoriesdata", methods={"POST"})
  2437.      */
  2438.     public function getfactoriesdataAction(Request $request)
  2439.     {
  2440.         $api_log_info = "API:Get Factories list by multiple Factory codes - ".date("YmdHis")." ".time();
  2441.         $log_data = "Started - ".$api_log_info;
  2442.         SELF::createApiLog($log_data);
  2444.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2446.         $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2447.         SELF::createApiLog($log_data);
  2449.         $factorycodes = (isset($reqparams['factorycodes']))?$reqparams['factorycodes']:'';
  2451.         $log_data = $api_log_info." | factorycodes:".json_encode($factorycodes);
  2452.         SELF::createApiLog($log_data);
  2454.         // $factorycode = $request->get('factorycode');
  2456.         if($factorycodes == "")
  2457.         {
  2458.             $data = "Factory Code(s) is(are) mandatory!";
  2460.             $log_data = $api_log_info." | data:".json_encode($data);
  2461.             SELF::createApiLog($log_data);
  2462.         } else 
  2463.         {
  2464.             $data = SELF::verifyauthToken($api_log_info);
  2466.             $log_data = $api_log_info." | data:".json_encode($data);
  2467.             SELF::createApiLog($log_data);
  2469.             if($data == "No data found")
  2470.             {
  2471.                 /*---- Check Factory by Code ---------*/
  2472.                 $factoriesData = new DataObject\Factories\Listing();
  2473.                 $factoriesData->setCondition("code IN (?)", [$factorycodes]);
  2474.                 $factoriesData->load();
  2476.                 $log_data = $api_log_info." | factoriesData count:".json_encode(count($factoriesData));
  2477.                 SELF::createApiLog($log_data);
  2479.                 if(!empty($factoriesData) && count($factoriesData)>0){
  2480.                     $data = [];
  2481.                     foreach($factoriesData as $factoryData){
  2483.                         $log_data = $api_log_info." | factoryData:".json_encode($factoryData);
  2484.                         SELF::createApiLog($log_data);
  2486.                         $curdata = array(
  2487.                             "id" => $factoryData->getId(),
  2488.                             "code" => $factoryData->getCode(),
  2489.                             "name" => $factoryData->getname(),
  2490.                             "address" => $factoryData->getaddress(),
  2491.                             "street" => $factoryData->getstreet(),
  2492.                             "landmark" => $factoryData->getlandmark(),
  2493.                             "city" => $factoryData->getcity(),
  2494.                             "state" => $factoryData->getstate(),
  2495.                             "country" => $factoryData->getcountry(),
  2496.                             "pincode" => $factoryData->getpincode(),
  2497.                             "bestbefore" => $factoryData->getbestbefore());
  2499.                         $log_data = $api_log_info." | curdata:".json_encode($curdata);
  2500.                         SELF::createApiLog($log_data);
  2502.                         array_push($data, $curdata);
  2504.                     }
  2505.                 } else {
  2506.                     $data = "No data found!";
  2507.                     $log_data = $api_log_info." | data:".json_encode($data);
  2508.                     SELF::createApiLog($log_data);
  2509.                 }
  2510.             }
  2511.         }
  2513.         $return_data = ["success" => true, "data" => $data];
  2515.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2516.         SELF::createApiLog($log_data);
  2518.         return $this->json(["success" => true, "data" => $data]);
  2519.     }
  2521.     /*------------------------------ End of Factory Related APIs -------------------------*/
  2523.     /*---------------------------------- Faq Related APIs ----------------------------*/
  2524.     /**
  2525.      * @param Request $request
  2526.      * 
  2527.      * @Route("/faqApi1",methods={"POST"})
  2528.      * 
  2529.      * @return Response
  2530.      * 
  2531.      */
  2532.     
  2533.      public function faqApi1Action(Request $request)
  2534.      {
  2535.         $api_log_info = "API:Get Faq List by locationcode with or without type - ".date("YmdHis")." ".time();
  2536.         $log_data = "Started - ".$api_log_info;
  2537.         SELF::createApiLog($log_data);
  2539.         $data = SELF::verifyauthToken($api_log_info);
  2541.         $log_data = $api_log_info." | data:".json_encode($data);
  2542.         SELF::createApiLog($log_data);
  2544.         if($data == "No data found")
  2545.         {
  2546.             $locationcode = (!empty($request->get('location_code')))?$request->get('location_code'):'';
  2548.             if($locationcode == "")
  2549.             {
  2550.                 $data = "Location Code is mandatory";
  2551.             } else {
  2552.                 $getlocationInfo = DataObject\Locations::getBylocation_code($locationcode, 1);
  2554.                 $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2555.                 SELF::createApiLog($log_data);
  2557.                 if((!empty($getlocationInfo))){
  2558.                     $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2559.                     $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2561.                     $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2562.                     SELF::createApiLog($log_data);
  2564.                     $faqType = (!empty($request->get('type')) && $request->get('type') == 'All')?'':((!empty($request->get('type')) && $request->get('type') != 'All')?$request->get('type'):'General');
  2566.                     $log_data = $api_log_info." | locationcode:".json_encode($locationcode)." | faqType:".json_encode($faqType);
  2567.                     SELF::createApiLog($log_data);
  2569.                     $faqTypes_list = ['','All','General', 'Loyalty'];
  2570.                     if(!in_array($faqType, $faqTypes_list)){
  2571.                         $data = "You are entered Type is Invalid, Please try again";
  2573.                         $return_data = ["success" => true, "data" => $data];
  2575.                         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2576.                         SELF::createApiLog($log_data);
  2577.                         
  2578.                         return $this->json(["success" => true, "data" => $data]);
  2579.                     }
  2580.             
  2581.                     $entries = new DataObject\ItcAddFaq\Listing();
  2583.                     $whr_condition = " faqQuestion!= '' ";
  2584.                     if($locationcode != '')
  2585.                     $whr_condition .= " AND location_code= '".$loc_name."' ";
  2586.                     if($faqType != '')
  2587.                     $whr_condition .= " AND faqType= '".$faqType."' ";
  2589.                     // if($locationcode != '')
  2590.                     // $entries->setCondition("location_name = :location_name", ["location_name" => $locationcode]);
  2591.                     // if($faqType != '')
  2592.                     // $entries->setCondition("faqType = :faqType", ["faqType" => $faqType]);
  2593.                     $entries->setCondition($whr_condition);
  2594.                     $entries->load();
  2596.                     $log_data = $api_log_info." | faq entries count :".json_encode(count($entries));
  2597.                     SELF::createApiLog($log_data);
  2599.                     $data = (count($entries)>0)?array():"No data found";
  2601.                     foreach($entries as $key => $entrie){
  2603.                         $log_data = $api_log_info." | faq key :".json_encode($key)." | faq entrie :".json_encode($entrie);
  2604.                         SELF::createApiLog($log_data);
  2605.             
  2606.                         if($entrie->getlocation_code()){
  2607.                             $locationInfo = DataObject\Locations::getBylocation_name($entrie->getlocation_code(), 1);
  2609.                             $log_data = $api_log_info." | locationInfo :".json_encode($locationInfo);
  2610.                             SELF::createApiLog($log_data);
  2611.                             
  2612.                             $loc_name = (!empty($locationInfo->getlocation_name()))?$locationInfo->getlocation_name():'';
  2613.                             $loc_code = (!empty($locationInfo->getlocation_code()))?$locationInfo->getlocation_code():'';
  2615.                             $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2616.                             SELF::createApiLog($log_data);
  2617.                         }
  2618.                         $data[] = array("faqId" => $entrie->getfaqId(),
  2619.                                 "location_code" => $loc_code,
  2620.                                 "location_name" => $loc_name,
  2621.                                 "faqQuestion" => $entrie->getfaqQuestion(),
  2622.                                 "faqAnswer" => $entrie->getfaqAnswer(),
  2623.                                 "Type" => $entrie->getfaqType(),
  2624.                         );
  2626.                         $log_data = $api_log_info." | data :".json_encode($data);
  2627.                         SELF::createApiLog($log_data);
  2628.                     }
  2630.                 } else {
  2631.                     $data = "Invalid Location Code, Please enter valid Location Code";
  2632.                     $log_data = $api_log_info." | data :".json_encode($data);
  2633.                     SELF::createApiLog($log_data);
  2634.                 }
  2635.             }
  2636.         }
  2638.         $return_data = ["success" => true, "data" => $data];
  2640.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2641.         SELF::createApiLog($log_data);
  2642.         
  2643.         return $this->json(["success" => true, "data" => $data]);
  2644.         
  2645.      }
  2646.      /**
  2647.      * @param Request $request
  2648.      * 
  2649.      * @Route("/faqApi",methods={"POST"})
  2650.      * 
  2651.      * @return Response
  2652.      * 
  2653.      */
  2654.      public function faqApiAction(Request $request)
  2655.      {
  2656.         $api_log_info = "API:Get Faq List by locationcode with or without type - ".date("YmdHis")." ".time();
  2657.         $log_data = "Started - ".$api_log_info;
  2658.         SELF::createApiLog($log_data);
  2660.         $data = SELF::verifyauthToken($api_log_info);
  2662.         $log_data = $api_log_info." | data:".json_encode($data);
  2663.         SELF::createApiLog($log_data);
  2665.         if($data == "No data found")
  2666.         {
  2667.             $locationcode = (!empty($request->get('location_code')))?$request->get('location_code'):'';
  2669.             // if($locationcode == "")
  2670.             // {
  2671.             //     $data = "Location Code is mandatory";
  2672.             // } else {
  2674.                 $getlocationInfo = (isset($locationcode) && $locationcode!='')?DataObject\Locations::getBylocation_code($locationcode, 1):[];
  2676.                 $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2677.                 SELF::createApiLog($log_data);
  2679.                 // if((!empty($getlocationInfo))){
  2681.                     $loc_name = (!empty($getlocationInfo) && !empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2682.                     $loc_code = (!empty($getlocationInfo) && !empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2684.                     $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2685.                     SELF::createApiLog($log_data);
  2687.                     $faqType = (!empty($request->get('type')) && $request->get('type') == 'All')?'':((!empty($request->get('type')) && $request->get('type') != 'All')?$request->get('type'):'General');
  2689.                     $log_data = $api_log_info." | locationcode:".json_encode($locationcode)." | faqType:".json_encode($faqType);
  2690.                     SELF::createApiLog($log_data);
  2692.                     $faqTypes_list = ['','All','General', 'Loyalty'];
  2693.                     if(!in_array($faqType, $faqTypes_list)){
  2694.                         $data = "You are entered Type is Invalid, Please try again";
  2696.                         $return_data = ["success" => true, "data" => $data];
  2698.                         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2699.                         SELF::createApiLog($log_data);
  2700.                         
  2701.                         return $this->json(["success" => true, "data" => $data]);
  2702.                     }
  2703.             
  2704.                     $entries = new DataObject\ItcAddFaq\Listing();
  2706.                     $whr_condition = " faqQuestion!= '' ";
  2707.                     if($locationcode != '')
  2708.                     $whr_condition .= " AND location_code= '".$loc_name."' ";
  2709.                     if($faqType != '')
  2710.                     $whr_condition .= " AND faqType= '".$faqType."' ";
  2712.                     // if($locationcode != '')
  2713.                     // $entries->setCondition("location_name = :location_name", ["location_name" => $locationcode]);
  2714.                     // if($faqType != '')
  2715.                     // $entries->setCondition("faqType = :faqType", ["faqType" => $faqType]);
  2716.                     $entries->setCondition($whr_condition);
  2717.                     $entries->load();
  2719.                     $log_data = $api_log_info." | faq entries count :".json_encode(count($entries));
  2720.                     SELF::createApiLog($log_data);
  2722.                     $data = (count($entries)>0)?array():"No data found";
  2724.                     foreach($entries as $key => $entrie){
  2726.                         $log_data = $api_log_info." | faq key :".json_encode($key)." | faq entrie :".json_encode($entrie);
  2727.                         SELF::createApiLog($log_data);
  2728.             
  2729.                         if($entrie->getlocation_code()){
  2730.                             $locationInfo = DataObject\Locations::getBylocation_name($entrie->getlocation_code(), 1);
  2732.                             $log_data = $api_log_info." | locationInfo :".json_encode($locationInfo);
  2733.                             SELF::createApiLog($log_data);
  2734.                             
  2735.                             $loc_name = (!empty($locationInfo->getlocation_name()))?$locationInfo->getlocation_name():'';
  2736.                             $loc_code = (!empty($locationInfo->getlocation_code()))?$locationInfo->getlocation_code():'';
  2738.                             $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2739.                             SELF::createApiLog($log_data);
  2740.                         }
  2741.                         $data[] = array("faqId" => $entrie->getfaqId(),
  2742.                                 "location_code" => $loc_code,
  2743.                                 "location_name" => $loc_name,
  2744.                                 "faqQuestion" => $entrie->getfaqQuestion(),
  2745.                                 "faqAnswer" => $entrie->getfaqAnswer(),
  2746.                                 "Type" => $entrie->getfaqType(),
  2747.                         );
  2749.                         $log_data = $api_log_info." | data :".json_encode($data);
  2750.                         SELF::createApiLog($log_data);
  2751.                     }
  2753.                 // } else {
  2754.                 //     $data = "Invalid Location Code, Please enter valid Location Code";
  2755.                 //     $log_data = $api_log_info." | data :".json_encode($data);
  2756.                 //     SELF::createApiLog($log_data);
  2757.                 // }
  2758.             // }
  2759.         }
  2761.         $return_data = ["success" => true, "data" => $data];
  2763.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2764.         SELF::createApiLog($log_data);
  2765.         
  2766.         return $this->json(["success" => true, "data" => $data]);
  2767.         
  2768.      }
  2769.     /*------------------------------ End of Faq Related APIs -------------------------*/
  2771.     /*--------------------------------- Pincode Related APIs -----------------------------*/
  2772.     /**
  2773.      * @param Request $request
  2774.      * 
  2775.      * @Route("/wearhouseDetectionApi",methods={"POST"})
  2776.      * 
  2777.      * @return Response
  2778.      * 
  2779.      */
  2781.      public function wearhouseDetectionApiAction(Request $request)
  2782.      { 
  2783.         $api_log_info = "API:Get Wearhouse data by Pincode - ".date("YmdHis")." ".time();
  2784.         $log_data = "Started - ".$api_log_info;
  2785.         SELF::createApiLog($log_data);
  2787.         $message = SELF::verifyauthToken();
  2789.         $log_data = $api_log_info." | message:".json_encode($message);
  2790.         SELF::createApiLog($log_data);
  2791.  
  2792.         if($message == "No data found")
  2793.         {
  2794.             if($request->get('pincode')){
  2795.                 $pincode = $request->get('pincode');
  2797.                 $log_data = $api_log_info." | pincode:".json_encode($pincode);
  2798.                 SELF::createApiLog($log_data);
  2800.                 // $entries = new DataObject\ItcAddPincode\Listing();
  2801.                 // $entries->setCondition("pincode = :name", ["name" => $pincode]);
  2802.                 // $entries->load();
  2804.                 $getpincodeInfo = DataObject\ItcAddPincode::getBypincode($pincode, 1);
  2806.                 $log_data = $api_log_info." | getpincodeInfo :".json_encode($getpincodeInfo);
  2807.                 SELF::createApiLog($log_data);
  2809.                 if((!empty($getpincodeInfo))){
  2811.                     $loc_name = $loc_code = '';
  2813.                     $location_name = (!empty($getpincodeInfo->getlocation_code()))?$getpincodeInfo->getlocation_code():"";
  2815.                     $log_data = $api_log_info." | location_name:".json_encode($location_name);
  2816.                     SELF::createApiLog($log_data);
  2818.                     if(!empty($location_name)){
  2819.                         $getlocationInfo = DataObject\Locations::getBylocation_name($location_name, 1);
  2821.                         $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2822.                         SELF::createApiLog($log_data);
  2824.                         if((!empty($getlocationInfo))){
  2825.                             $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2826.                             $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2827.                         } 
  2829.                         $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2830.                         SELF::createApiLog($log_data);                     
  2831.                     }
  2833.                     $data = array("pincode" => $getpincodeInfo->getpincode(),
  2834.                                     "store_code" => $loc_code,
  2835.                                     "location_name" => $loc_name,
  2836.                                     "city_name" => $getpincodeInfo->getcity(),
  2837.                                     "state" => $getpincodeInfo->getstate(),
  2838.                                     "delivery_type" => $getpincodeInfo->getdeliverytype(),
  2839.                                     "is_shipping_applicable" => $getpincodeInfo->getis_shipping_applicable(),
  2840.                                     "merichakki_available" => $getpincodeInfo->getmerichakki_available(),
  2841.                                     "nammachakki_available" => $getpincodeInfo->getnammachakki_available(),
  2842.                                     "vin_instance" => $getpincodeInfo->getvin_instance(),
  2843.                                 );
  2845.                 } else {
  2846.                     $data = "You are entered Pincode is Invalid, Please try again";
  2847.                 }
  2848.                 $log_data = $api_log_info." | data :".json_encode($data);
  2849.                 SELF::createApiLog($log_data);  
  2851.             }elseif($request->get('city_name')){
  2852.                 $city = $request->get('city_name');
  2854.                 $log_data = $api_log_info." | city :".json_encode($city);
  2855.                 SELF::createApiLog($log_data);  
  2857.                 $entries = new DataObject\ItcAddPincode\Listing();
  2858.                 $entries->setCondition("city = :name OR location_code = :name", ["name" => $city,"location_code" => $city]);
  2859.                 $entries->setLimit(1);
  2860.                 $entries->load();
  2862.                 $log_data = $api_log_info." | entries count :".json_encode(count($entries));
  2863.                 SELF::createApiLog($log_data);  
  2865.                 foreach($entries as $key => $entrie){
  2867.                     $log_data = $api_log_info." | entrie :".json_encode($entrie);
  2868.                     SELF::createApiLog($log_data); 
  2870.                     $loc_name = $loc_code = '';
  2872.                     $location_name = (!empty($entrie->getlocation_code()))?$entrie->getlocation_code():"";
  2874.                     $log_data = $api_log_info." | location_name:".json_encode($location_name);
  2875.                     SELF::createApiLog($log_data);
  2877.                     if(!empty($location_name)){
  2878.                         $getlocationInfo = DataObject\Locations::getBylocation_name($location_name, 1);
  2880.                         $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2881.                         SELF::createApiLog($log_data);
  2883.                         if((!empty($getlocationInfo))){
  2884.                             $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2885.                             $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2886.                         } 
  2888.                         $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2889.                         SELF::createApiLog($log_data);                     
  2890.                     }
  2892.                     $data = array("pincode" => $entrie->getpincode(),
  2893.                                     "store_code" => $loc_code,
  2894.                                     "location_name" => $loc_name,
  2895.                                     "city_name" => $entrie->getcity(),
  2896.                                     "state" => $entrie->getstate(),
  2897.                                     "delivery_type" => $entrie->getdeliverytype(),
  2898.                                     "is_shipping_applicable" => $entrie->getis_shipping_applicable(),
  2899.                                     "merichakki_available" => $entrie->getmerichakki_available(),
  2900.                                     "nammachakki_available" => $entrie->getnammachakki_available(),
  2901.                                     "vin_instance" => $entrie->getvin_instance(),
  2902.                                 );
  2903.                 }
  2904.             }  else {
  2905.                 $data = "Pincode is mandatory";
  2906.             }      
  2907.         } 
  2908.         else
  2909.             $data[] = ['message'=>$message];
  2911.         if(!empty($data)){
  2913.             $success = (empty($data['pincode'])) ? false : true;
  2914.             if ($success) {
  2915.                 return $this->json(["success" => $success, "data" => $data]);
  2916.             } else {
  2917.                 return $this->json(["success" => $success, 'message' => $data]);
  2918.             }
  2919.         }else{
  2920.             return $this->json(["success" => false, "message" => "Service not available"]);
  2921.         }
  2922.       
  2923.      }
  2924.     /*------------------------------ End of Pincode Related APIs -------------------------*/
  2925.     /*---------------------------------- Voucher Related APIs ----------------------------*/
  2926.     /**
  2927.      * @Route("api/getvouchersdata", methods={"POST"})
  2928.      */
  2929.     public function getvouchersdataAction(Request $request)
  2930.     {
  2931.         $api_log_info = "API:Get Vouchers list by multiple voucher codes - ".date("YmdHis")." ".time();
  2932.         $log_data = "Started - ".$api_log_info;
  2933.         SELF::createApiLog($log_data);
  2935.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2937.         $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2938.         SELF::createApiLog($log_data);
  2940.         $vouchercodes = (isset($reqparams['vouchercodes']))?$reqparams['vouchercodes']:'';
  2941.         $vouchertype = (isset($reqparams['vouchertype']))?$reqparams['vouchertype']:'';
  2943.         $log_data = $api_log_info." | vouchercodes:".json_encode($vouchercodes)." | vouchertype:".json_encode($vouchertype);
  2944.         SELF::createApiLog($log_data);
  2946.         // $factorycode = $request->get('factorycode');
  2948.         if(($vouchercodes == "" || !is_array($vouchercodes)) && ($vouchertype == '' || ($vouchertype && !in_array($vouchertype, ["Master", "all"]))))
  2949.         {
  2950.             
  2951.             $data = "Voucher Code(s) OR Voucher Type is(are) mandatory, Voucher Type must be like Master OR all!";
  2953.             $log_data = $api_log_info." | data:".json_encode($data);
  2954.             SELF::createApiLog($log_data);
  2955.         } else 
  2956.         {
  2957.             // die;
  2958.             $data = SELF::verifyauthToken($api_log_info);
  2960.             $log_data = $api_log_info." | data:".json_encode($data);
  2961.             SELF::createApiLog($log_data);
  2963.             if($data == "No data found")
  2964.             {
  2965.                 $vouchertype = ($vouchertype == 'all')?'Voucher':$vouchertype;
  2967.                 /*---- Get Master Voucher data by Master Voucher Code ---------*/
  2968.                 $master_voucher = "Master_Voucher";
  2969.                 $masterVoucherData = DataObject\Vouchers::getByvoucher_code($master_voucher, 1);
  2970.                 
  2971.                 $projectUrl  = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off' ? 'https://' : 'http://';
  2972.                 $projectUrl .= $_SERVER['SERVER_NAME'];
  2973.                 $log_data = $api_log_info." | projectUrl:".json_encode($projectUrl);
  2974.                 SELF::createApiLog($log_data);
  2976.                 /*---- Check Factory by Code ---------*/
  2977.                 $vouchersData = new DataObject\Vouchers\Listing();
  2978.                 if($vouchercodes)
  2979.                 $vouchersData->setCondition("voucher_code IN (?)", [$vouchercodes]);
  2980.                 else if($vouchertype)
  2981.                 $vouchersData->setCondition("voucher_type IN (?)", [$vouchertype]);
  2982.                 $vouchersData->load();
  2984.                 $log_data = $api_log_info." | vouchersData count:".json_encode(count($vouchersData));
  2985.                 SELF::createApiLog($log_data);
  2987.                 if(!empty($vouchersData) && count($vouchersData)>0){
  2988.                     $data = [];
  2989.                     foreach($vouchersData as $voucherData){
  2991.                         $log_data = $api_log_info." | voucherData:".json_encode($voucherData);
  2992.                         SELF::createApiLog($log_data);
  2994.                         $voucher_logo_path = ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getvoucher_logo():$voucherData->getvoucher_logo();
  2995.                         $voucher_logo_path = $projectUrl."/uploads/".$voucher_logo_path;
  2996.                         $voucher_background_image_path = $projectUrl."/uploads/".($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getvoucher_background_image():$voucherData->getvoucher_background_image();
  2997.                         $voucher_background_image_path = $projectUrl."/uploads/".$voucher_background_image_path;
  2999.                         $curdata = array(
  3000.                             "id" => $voucherData->getId(),
  3001.                             "voucher_code" => $voucherData->getvoucher_code(),
  3002.                             "about_offer" => ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getabout_offer():$voucherData->getabout_offer(),
  3003.                             "avail_offer" => ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getavail_offer():$voucherData->getavail_offer(),
  3004.                             "voucher_logo_path" => $voucher_logo_path,
  3005.                             "voucher_background_image_path" => $voucher_background_image_path);
  3007.                         $log_data = $api_log_info." | curdata:".json_encode($curdata);
  3008.                         SELF::createApiLog($log_data);
  3010.                         array_push($data, $curdata);
  3012.                     }
  3013.                 } else {
  3014.                     $data = "No data found!";
  3015.                     $log_data = $api_log_info." | data:".json_encode($data);
  3016.                     SELF::createApiLog($log_data);
  3017.                 }
  3018.             }
  3019.         }
  3021.         $return_data = ["success" => true, "data" => $data];
  3023.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  3024.         SELF::createApiLog($log_data);
  3026.         return $this->json(["success" => true, "data" => $data]);
  3027.     }
  3028.     /*------------------------------ End of Voucher Related APIs -------------------------*/
  3030.     /*---------------------------------- Log Related APIs ----------------------------*/
  3031.     /**
  3032.      * @Route("/api/log_info/{date?}")
  3033.      */
  3034.     public function log_infoAction($date)
  3035.     {
  3036.         // $date = ($date == '')?date("Y-m-d", strtotime("-1 day")):$date;
  3037.         $date = ($date == '')?date("Y-m-d"):$date;
  3038.         if($date == '')
  3039.         {
  3040.             $data = "Date is mandatory!";
  3041.         } else {
  3042.             $file = '../var/log/slot-api-log_'.$date.'.txt';
  3043.             if(file_exists($file)){
  3044.                 $myfile = fopen($file, "r") or die("Unable to open file!");
  3045.                 $data = fread($myfile,filesize($file));
  3046.                 fclose($myfile);
  3047.             } else {
  3048.                 $data = "The file is not exited!";
  3049.             }
  3050.         }
  3051.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3052.     }
  3054.     /**
  3055.      * @Route("/api/log_info_data")
  3056.      */
  3057.     public function log_info_dataAction(Request $requet)
  3058.     {
  3059.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3061.         $date = (isset($reqparams['date']))?$reqparams['date']:'';
  3062.         $from_line = (isset($reqparams['from_line']))?$reqparams['from_line']:'';
  3063.         $to_line = (isset($reqparams['to_line']))?$reqparams['to_line']:'';
  3065.         $date = ($date == '')?date("Y-m-d"):$date;
  3066.         if($date == '' || $from_line == '' || $to_line == '')
  3067.         {
  3068.             $data = "Date, from_line and to_line are mandatory!";
  3069.         } else {
  3070.             $file = '../var/log/slot-api-log_'.$date.'.txt';
  3071.             if(file_exists($file)){
  3072.                 $splitdata = array_slice(file($file), $from_line, $to_line);
  3073.                 echo $data = implode('', $splitdata); die;
  3074.             } else {
  3075.                 $data = "The file is not exited!";
  3076.             }
  3077.         }
  3078.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3079.     }
  3081.     /**
  3082.      * @Route("/api/delete_log_file/{date}")
  3083.      */
  3084.     public function delete_log_fileAction($date)
  3085.     {
  3086.         if($date == '')
  3087.         {
  3088.             $data = "Date is mandatory!";
  3089.         } else {
  3091.             $message = SELF::verifyauthToken();
  3092.         
  3093.             if($message == "No data found")
  3094.             {
  3095.                 $file = '../var/log/slot-api-log_'.$date.'.txt';
  3096.                 if(file_exists($file)){
  3097.                     unlink($file);
  3098.                     $data = "Deleted the file successfully!";
  3099.                 } else {
  3100.                     $data = "The file is not exited!";
  3101.                 }
  3102.             }else $data[] = ['message'=>$message];
  3103.         }
  3104.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3105.     }
  3107.     /**
  3108.      * @Route("/api/delete_log_files")
  3109.      */
  3110.     public function delete_log_filesAction(Request $request)
  3111.     {
  3112.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3114.         $fromdate = (isset($reqparams['fromdate']))?$reqparams['fromdate']:'';
  3115.         $todate = (isset($reqparams['todate']))?$reqparams['todate']:'';
  3117.         if($fromdate == '' || $todate == '')
  3118.         {
  3119.             $data = "From Date and To Date are mandatory!";
  3120.         } else {
  3121.             $message = SELF::verifyauthToken();
  3122.         
  3123.             if($message == "No data found")
  3124.             {
  3125.                 $rangeDates = SELF::getDatesFromRange($fromdate, $todate);
  3126.                 // echo 'rangeDates:<pre>';
  3127.                 // print_r($rangeDates); die;
  3128.                 foreach($rangeDates as $rangeDateInfo){
  3129.                     $file = '../var/log/slot-api-log_'.$rangeDateInfo.'.txt';
  3130.                     if(file_exists($file)){
  3131.                         unlink($file);
  3132.                         $data = "Deleted the file successfully!";
  3133.                     } else {
  3134.                         $data = (isset($data) && $data == "Deleted the file successfully!")?$data:"The file is not exited!";
  3135.                     }
  3136.                 }
  3137.             }else $data[] = ['message'=>$message];
  3138.         }
  3139.         return $this->json(["success" => true, "fromdate" => $fromdate, "todate" => $todate, "data" => $data]);
  3140.     }
  3143.     /**
  3144.      * @Route("/api/get_log_files")
  3145.      */
  3146.     public function get_log_filesAction(Request $request)
  3147.     {
  3148.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3150.         $fromdate = (isset($reqparams['fromdate']))?$reqparams['fromdate']:'';
  3151.         $todate = (isset($reqparams['todate']))?$reqparams['todate']:'';
  3153.         $filenames = [];
  3155.         if($fromdate == '' || $todate == '')
  3156.         {
  3157.             $data = "From Date and To Date are mandatory!";
  3158.         } else {
  3159.             $message = SELF::verifyauthToken();
  3160.         
  3161.             if($message == "No data found")
  3162.             {
  3163.                 $rangeDates = SELF::getDatesFromRange($fromdate, $todate);
  3164.                 // echo 'rangeDates:<pre>';
  3165.                 // print_r($rangeDates); die;
  3166.                 foreach($rangeDates as $rangeDateInfo){
  3167.                     $file = '../var/log/slot-api-log_'.$rangeDateInfo.'.txt';
  3168.                     if(file_exists($file)){
  3169.                         array_push($filenames, 'slot-api-log_'.$rangeDateInfo.'.txt');
  3170.                     } else {
  3171.                         $msg = (!empty($filenames))?'':"The file is not exited!";
  3172.                     }
  3173.                 }
  3175.                 $data = (!empty($filenames))?$filenames:$msg;
  3177.             }else $data[] = ['message'=>$message];
  3178.         }
  3179.         return $this->json(["success" => true, "fromdate" => $fromdate, "todate" => $todate, "data" => $data]);
  3180.     }
  3181.     /*------------------------------ End of Log Related APIs -------------------------*/
  3183.     /**
  3184.      * @Route("/location/locationslist")
  3185.      */
  3186.     public function locationslist()
  3187.     {
  3188.         $log_data = "Started - API:Get All Locations";
  3189.         SELF::createApiLog($log_data);
  3191.         $message = SELF::verifyauthToken();
  3193.         $log_data = "API:Get All Locations | message:".json_encode($message);
  3194.         SELF::createApiLog($log_data);
  3196.         if($message == "No data found")
  3197.         {
  3198.             $locationsList = DataObject\Locations::getList();
  3199.             $locationsList->load();
  3201.             $log_data = "API:Get All Locations | locationsList count :".json_encode(count($locationsList));
  3202.             SELF::createApiLog($log_data);
  3204.             if(count($locationsList) > 0){
  3205.                 foreach ($locationsList as $key => $location) {
  3207.                     $log_data = "API:Get All Locations | location :".json_encode($location);
  3208.                     SELF::createApiLog($log_data);
  3210.                     $data[] = array(
  3211.                         "Id" => $location->getId(),
  3212.                         "location_name" => $location->getLocation_name(),
  3213.                         "location_code" => $location->getLocation_code());
  3215.                     $log_data = "API:Get All Locations | data :".json_encode($data);
  3216.                     SELF::createApiLog($log_data);
  3217.                 }
  3218.             } else $data[] = ['message'=>$message];
  3219.         } else $data[] = ['message'=>$message];
  3221.         $log_data = "Ended - API:Get All Locations | data :".json_encode($data);
  3222.         SELF::createApiLog($log_data);
  3223.         
  3224.         return $this->json(["success" => true, "data" => $data]);
  3225.     }
  3227.     /*--------------- Authentication related methods ----------------*/
  3228.     public function generateAuthToken($userInfo=[])
  3229.     {
  3230.         /*------------- Generate MDF encode --------------*/
  3231.         $generateAuthToken = md5(time());
  3233.         $jwtdata = array(
  3234.             "generateAuthToken" => $generateAuthToken
  3235.         );
  3237.         /*------------- Generate JWT Token ---------------*/
  3238.         $jwt_check = 0;
  3239.         if(!empty($userInfo)){
  3240.             $id = $userInfo['id'];//1024;
  3241.             $firstname = $userInfo['firstname'];//'Tex';
  3242.             $lastname = $userInfo['lastname'];//'Hardrock';
  3243.             $email = $userInfo['email'];//'dino@stone.age';
  3245.             $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  3246.             $issuer_claim = "pimcore6.local"; // this can be the servername
  3247.             $audience_claim = "Babu";
  3248.             $issuedat_claim = time(); // issued at
  3249.             $notbefore_claim = $issuedat_claim + 10; //not before in seconds
  3250.             $expire_claim = $issuedat_claim + 60*5; // expire time in seconds
  3251.             $token = array(
  3252.                 "iss" => $issuer_claim,
  3253.                 "aud" => $audience_claim,
  3254.                 "iat" => $issuedat_claim,
  3255.                 "nbf" => $notbefore_claim,
  3256.                 "exp" => $expire_claim,
  3257.                 "data" => array(
  3258.                     "id" => $id,
  3259.                     "firstname" => $firstname,
  3260.                     "lastname" => $lastname,
  3261.                     "email" => $email
  3262.             ));
  3264.             $jwt = JWT::encode($token, $secret_key, 'HS256');
  3265.             
  3266.             $jwtdata = array(
  3267.                 "generateAuthToken" => $generateAuthToken,
  3268.                 "jwt" => $jwt,
  3269.                 "email" => $email,
  3270.                 "expireAt" => $expire_claim
  3271.             );
  3272.         }
  3273.         return $jwtdata;
  3274.     }
  3276.     public function verifyauthToken1()
  3277.     {
  3278.         $message = "No data found"; $tokenCheck = 0;
  3279.         $headers=array();
  3280.         foreach (getallheaders() as $name => $value) {
  3281.             $headers[$name] = $value;
  3282.             if($name == 'Authtoken') $tokenCheck = 1;
  3283.         }
  3284.         if($tokenCheck == 0){
  3285.             $message = "Authentication Token is missing";;
  3286.         } else {
  3287.             $Authtoken = $headers['Authtoken'];
  3288.         
  3289.             $dbConnection = \Pimcore\Db::get();
  3290.             $authTokencheck = $dbConnection->fetchOne("SELECT id FROM users WHERE authToken = '".$Authtoken."' ");
  3292.             if(empty($authTokencheck)){
  3293.                 $message = "Authentication Token is mismatch";
  3294.             } else {
  3296.             }
  3297.         }
  3299.         return $message;
  3300.     }
  3302.     public function verifyauthToken2()
  3303.     {
  3304.         $api_key = 'api-key';
  3305.         $api_key_value = 'cGltY29yZWFwaWtleXZhbHVl';//base64encode('pimcoreapikeyvalue);
  3307.         $message = "No data found"; $tokenCheck = 0; $apikeyCheck = 0; $jwtCheck = 0;$tokenMsg = ''; $apikeyMsg = ''; $jwtMsg = '';
  3308.         $headers=array();
  3309.         foreach (getallheaders() as $name => $value) {
  3310.             $headers[$name] = $value;
  3311.             if($name == 'Authtoken') $tokenCheck = 1;
  3312.             if($name == 'Api-Key') $apikeyCheck = 1;
  3313.             if($name == 'Authorization') $jwtCheck = 1;
  3314.         }
  3316.         // echo 'arr:<pre>';
  3317.         // print_r($headers); 
  3318.         // die;
  3319.         if($tokenCheck == 0 && $apikeyCheck == 0 && $jwtCheck == 0){
  3320.             $message = "Fill any one of the Authentication Token, Api-Key Or JWT token!";;
  3321.         } else {
  3322.             $tokenCheck_valid = 0; $apikeyCheck_valid = 0; $jwtTokenCheck_valid = 0;
  3324.             /*--------------------- Validating Auth Token -----------------*/
  3325.             if($tokenCheck == 1)
  3326.             {
  3327.                 $Authtoken = $headers['Authtoken'];
  3328.         
  3329.                 $dbConnection = \Pimcore\Db::get();
  3330.                 $authTokencheck = $dbConnection->fetchOne("SELECT id FROM users WHERE authToken = '".$Authtoken."' ");
  3332.                 if(empty($authTokencheck)){
  3333.                     $tokenMsg = "Authentication Token is mismatch";
  3334.                 } else {
  3335.                     $tokenCheck_valid = 1;
  3336.                 }
  3337.             }
  3339.             /*--------------------- Validating Api Key -----------------*/
  3340.             if($apikeyCheck == 1)
  3341.             {
  3342.                 $AuthApikey = $headers['Api-Key'];
  3344.                 if(empty($AuthApikey)){
  3345.                     $apikeyMsg = "Key is mismatch";
  3346.                 } else if($AuthApikey != $api_key_value){
  3347.                     $apikeyMsg = "key is mismatch";
  3348.                 } else {
  3349.                     $apikeyCheck_valid = 1;
  3350.                 }
  3351.             }
  3353.             /*--------------------- Validating JWT Token -----------------*/
  3354.             if($jwtCheck == 1)
  3355.             {
  3356.                 $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  3357.                 $jwt = null;
  3359.                 $authHeader = $_SERVER['HTTP_AUTHORIZATION'];
  3361.                 $arr = explode(" ", $authHeader);
  3362.                 $jwt = $arr[1];
  3364.                 if($jwt){
  3365.                     try {
  3366.                         $decoded = JWT::decode($jwt, new Key($secret_key, 'HS256'));
  3367.                         $jwtTokenCheck_valid = 1;
  3368.                     }catch (ExpiredException $e){
  3369.                         $jwtMsg = "Expired JWT Token!";//$e->getMessage();
  3370.                     }catch (Exception $e){
  3371.                         $jwtTokenCheck_valid = 0;
  3372.                         $jwtMsg = "Expired JWT Token!";//$e->getMessage();
  3373.                     }
  3374.                 } else {
  3375.                     $jwtMsg = "JWT Token is missing";
  3376.                 }
  3377.             }
  3379.             $message = '';
  3380.             if($tokenMsg != '' || $apikeyMsg != '' || $jwtMsg != '')
  3381.             {
  3382.                 $message = ($tokenMsg != '')?"Token Message:".$message.$tokenMsg:$message;
  3383.                 $message = ($apikeyMsg != '')?"".$message." | Api-Key Message:".$apikeyMsg:$message;
  3384.                 $message = ($jwtMsg != '')?"".$message." | JWT Message:".$jwtMsg:$message;
  3385.             }
  3387.             $message = ($tokenCheck_valid == 1 || $apikeyCheck_valid == 1 || $jwtTokenCheck_valid == 1)?"No data found":$message;
  3388.         }
  3390.         return $message;
  3391.     }
  3393.     public function verifyauthToken($api_log_info='')
  3394.     {        
  3395.         $start_method_log_info = "Verify Auth Token Method";
  3396.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Started - ".$start_method_log_info:"Started - ".$start_method_log_info;
  3397.         $log_data = $api_log_method_info;
  3398.         SELF::createApiLog($log_data);
  3400.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | ".$start_method_log_info:$start_method_log_info;
  3402.         $api_key = 'api-key';
  3403.         $api_key_value = 'cGltY29yZWFwaWtleXZhbHVl';//base64encode('pimcoreapikeyvalue);
  3405.         $message = "No data found"; $apikeyCheck = 0; $apikeyMsg = '';
  3406.         $headers=array();
  3407.         foreach (getallheaders() as $name => $value) {
  3408.             $headers[$name] = $value;
  3409.             if($name == 'Api-Key') $apikeyCheck = 1;
  3410.         }
  3411.         
  3412.         if($apikeyCheck == 0){
  3413.             $message = "Api-Key is mandatory!";;
  3414.         } else {
  3415.             $apikeyCheck_valid = 0;
  3417.             /*--------------------- Validating Api Key -----------------*/
  3418.             if($apikeyCheck == 1)
  3419.             {
  3420.                 $AuthApikey = $headers['Api-Key'];
  3422.                 if(empty($AuthApikey)){
  3423.                     $message = "Key is empty, Api-Key is mandatory";
  3424.                 } else if($AuthApikey != $api_key_value){
  3425.                     $message = "key is mismatch";
  3426.                 } else {
  3427.                     $apikeyCheck_valid = 1;
  3428.                 }
  3429.             }
  3430.         }
  3432.         $apikeyCheck_valid = 1;
  3433.         $message = "No data found";
  3435.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Ended - ".$start_method_log_info:"Ended - ".$start_method_log_info;
  3436.         $log_data = $api_log_method_info." | message:".$message;
  3437.         SELF::createApiLog($log_data);
  3439.         return $message;
  3440.     }
  3441.     /*--------------- End of Authentication related methods ------------*/
  3443.     /*-------------------------- Sub methods ---------------------------*/
  3444.     public function generateObjFolder($folderName,$location_code){
  3446.         $yr = date("Y");
  3447.         $mt = date("M");
  3448.         $dy = date("d");
  3450.         $path = "/".$folderName."/".$yr."/".$mt."/".$dy;
  3451.         $path = "/".$folderName."/".$location_code;
  3453.         $object = DataObject::getByPath($path);
  3454.         if(!$object){
  3455.             $path1 = "/".$folderName."/".$yr."/".$mt;
  3456.             $object1 = DataObject::getByPath($path1);
  3457.             if(!$object1){
  3458.                 $path2 = "/".$folderName."/".$yr;
  3459.                 $object2 = DataObject::getByPath($path2);                
  3460.                 if(!$object2){
  3461.                     $path3 = "/".$folderName;
  3462.                     $object3 = DataObject::getByPath($path3);                
  3463.                     if(!$object3){
  3464.                         $createAssetFolder = DoService::createFolderByPath($path3);
  3465.                         $createAssetFolder = DoService::createFolderByPath($path2);
  3466.                         $createAssetFolder = DoService::createFolderByPath($path1);
  3467.                         $createAssetFolder = DoService::createFolderByPath($path);
  3468.                         $objParentId = $createAssetFolder->getId();
  3469.                     }else {
  3470.                         $createAssetFolder = DoService::createFolderByPath($path2);
  3471.                         $createAssetFolder = DoService::createFolderByPath($path1);
  3472.                         $createAssetFolder = DoService::createFolderByPath($path);
  3473.                         $objParentId = $createAssetFolder->getId();
  3474.                     }
  3476.                 }else {
  3477.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3478.                     $createAssetFolder = DoService::createFolderByPath($path);
  3479.                     $objParentId = $createAssetFolder->getId();
  3480.                 }
  3482.             } else {
  3483.                 $createAssetFolder = DoService::createFolderByPath($path);
  3484.                 $objParentId = $createAssetFolder->getId();
  3485.             }
  3486.         } else
  3487.         $objParentId = $object->getId();
  3489.         return $objParentId;
  3490.     }
  3492.     public function generateSlotObjFolder($folderName,$delivery_mode,$location_code){
  3494.         $yr = date("Y");
  3495.         $mt = date("M");
  3496.         $dy = date("d");
  3498.         $path = "/".$folderName."/".$delivery_mode."/".$location_code;//."/".$date.'-'.$location_code;
  3500.         $object = DataObject::getByPath($path);
  3501.         if(!$object){
  3502.             $path1 = "/".$folderName."/".$delivery_mode;//."/".$location_code."/".$date;
  3503.             $object1 = DataObject::getByPath($path1);
  3504.             if(!$object1){
  3505.                 $path2 = "/".$folderName;//."/".$delivery_mode."/".$location_code;
  3506.                 $object2 = DataObject::getByPath($path2);                
  3507.                 if(!$object2){
  3508.                     $createAssetFolder = DoService::createFolderByPath($path2);
  3509.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3510.                     $createAssetFolder = DoService::createFolderByPath($path);
  3511.                     $objParentId = $createAssetFolder->getId();
  3512.                 }else {
  3513.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3514.                     $createAssetFolder = DoService::createFolderByPath($path);
  3515.                     $objParentId = $createAssetFolder->getId();
  3516.                 }
  3517.             } else {
  3518.                 $createAssetFolder = DoService::createFolderByPath($path);
  3519.                 $objParentId = $createAssetFolder->getId();
  3520.             }
  3521.         } else
  3522.         $objParentId = $object->getId();
  3524.         return $objParentId;
  3525.     }
  3527.     public function getWeekDates($holidaysList, $todaydate, $delSlotTimesAvailibility){
  3528.         $jj=0; $weekdates = [];
  3530.         $slot_prepare_days = $delSlotTimesAvailibility['slot_prepare_days'];
  3531.         $slot_generate_days = $delSlotTimesAvailibility['slot_generate_days'];
  3532.         $saturday_slot_availability = $delSlotTimesAvailibility['saturday_slot_availability'];
  3533.         $sunday_slot_availability = $delSlotTimesAvailibility['sunday_slot_availability'];
  3535.         $todaydate = date('Y-m-d', strtotime($todaydate . ' +'.$slot_prepare_days.' day'));
  3537.         $totDays = $slot_generate_days+7;
  3539.         for($ii=1; $ii<$totDays; $ii++)
  3540.         {
  3541.             if($jj >= $slot_generate_days) break;
  3542.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3544.                 $weekDay = date('w', strtotime($todaydate));
  3545.                 if(($weekDay == 0 && $sunday_slot_availability == 'Yes') || ($weekDay == 6 && $saturday_slot_availability == 'Yes') || !in_array($weekDay, [0,6]))
  3546.                 {
  3547.                     $weekdates[] = $todaydate;
  3548.                     $jj=$jj+1;
  3549.                 }
  3550.             }
  3551.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3552.         }
  3554.         // echo '<pre>'; print_r($weekdates); die;
  3556.         return $weekdates;
  3557.     }
  3559.     public function getSettingInfo($api_log_info='')
  3560.     {
  3561.         $start_method_log_info = "Setting info Method";
  3562.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Started - ".$start_method_log_info:"Started - ".$start_method_log_info;
  3563.         $log_data = $api_log_method_info;
  3564.         SELF::createApiLog($log_data);
  3566.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | ".$start_method_log_info:$start_method_log_info;
  3568.         /*------ Get Settings Class data --------*/
  3569.         $dbConnection = \Pimcore\Db::get();
  3570.         $settingsClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Settings' ");
  3571.         $settingsObject = "object_".$settingsClassId;
  3572.         
  3573.         $log_data = $api_log_method_info." | settingsObject:".json_encode($settingsObject);
  3574.         SELF::createApiLog($log_data);
  3575.         
  3576.         $settingsId = $dbConnection->fetchOne(" select * from ".$settingsObject." WHERE setting_flag = 1");
  3577.         
  3578.         $log_data = $api_log_method_info." | settingsId:".json_encode($settingsId);
  3579.         SELF::createApiLog($log_data);
  3580.         /*----- End of Get Settings Class data ---------*/
  3582.         /*--------------- Settings info ----------------*/
  3583.         $settingsInfo = DataObject\Settings::getById($settingsId);
  3584.         
  3585.         $log_data = $api_log_method_info." | settingsInfo:".json_encode($settingsInfo);
  3586.         SELF::createApiLog($log_data);
  3588.         $settingDataId = $settingsInfo->getId();
  3589.         $setting_deliveryModes = $settingsInfo->getdelivery_modes();
  3590.         $setting_slot_time_flag = (!empty($settingsInfo->getslottime()))?$settingsInfo->getslottime():"18:00";
  3592.         $stg_deliveryslot_config_is_upcountry_configuration_applicable = ($settingsInfo->getdeliveryslot_config_is_upcountry_configuration_applicable())?$settingsInfo->getdeliveryslot_config_is_upcountry_configuration_applicable():'No';
  3594.         $stg_delslot_normalloc_morethan_fromtime = ($settingsInfo->getdelslot_normalloc_morethan_fromtime())?$settingsInfo->getdelslot_normalloc_morethan_fromtime():"00:00";
  3595.         $stg_delslot_normalloc_lessthaneq_totime = ($settingsInfo->getdelslot_normalloc_lessthaneq_totime())?$settingsInfo->getdelslot_normalloc_lessthaneq_totime():"18:00";
  3596.         $stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays = ($settingsInfo->getdelslot_normalloc_bw_from_to_time_extra_generate_slotdays())?$settingsInfo->getdelslot_normalloc_bw_from_to_time_extra_generate_slotdays():1;
  3597.         $stg_delslot_normalloc_after_totime_extra_generate_slotdays = ($settingsInfo->getdelslot_normalloc_after_totime_extra_generate_slotdays())?$settingsInfo->getdelslot_normalloc_after_totime_extra_generate_slotdays():2;
  3599.         $stg_normalloc_slot_generate_days = ($stg_delslot_normalloc_after_totime_extra_generate_slotdays>$stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays)?$stg_delslot_normalloc_after_totime_extra_generate_slotdays:$stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays;
  3601.         $stg_delslot_upcountryloc_morethan_fromtime = ($settingsInfo->getdelslot_upcountryloc_morethan_fromtime())?$settingsInfo->getdelslot_upcountryloc_morethan_fromtime():"00:00";
  3602.         $stg_delslot_upcountryloc_lessthaneq_totime = ($settingsInfo->getdelslot_upcountryloc_lessthaneq_totime())?$settingsInfo->getdelslot_upcountryloc_lessthaneq_totime():"11:00";
  3603.         $stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays = ($settingsInfo->getdelslot_upcountryloc_bw_from_to_time_extra_generate_slotdays())?$settingsInfo->getdelslot_upcountryloc_bw_from_to_time_extra_generate_slotdays():4;
  3604.         $stg_delslot_upcountryloc_after_totime_extra_generate_slotdays = ($settingsInfo->getdelslot_upcountryloc_after_totime_extra_generate_slotdays())?$settingsInfo->getdelslot_upcountryloc_after_totime_extra_generate_slotdays():5;
  3606.         $stg_upcountryloc_slot_generate_days = ($stg_delslot_upcountryloc_after_totime_extra_generate_slotdays>$stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays)?$stg_delslot_upcountryloc_after_totime_extra_generate_slotdays:$stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays;
  3608.         $stg_is_deliveryfee_config_applicable = $settingsInfo->getis_deliveryfee_config_applicable();
  3609.         $stg_deliveryfee_config = $settingsInfo->getdeliveryfee_config();
  3610.         $stg_deliveryfee_config = $settingsInfo->getdeliveryfee_config();
  3611.         $stg_deliveryfee_config_location_lessthan_charge = $settingsInfo->getdeliveryfee_config_location_lessthan_charge();
  3612.         $stg_deliveryfee_config_location_greaterthanequal_charge = $settingsInfo->getdeliveryfee_config_location_greaterthanequal_charge();
  3613.         $stg_deliveryfee_config_upcountry_lessthan_charge = $settingsInfo->getdeliveryfee_config_upcountry_lessthan_charge();
  3614.         $stg_deliveryfee_config_upcountry_greaterthanequal_charge = $settingsInfo->getdeliveryfee_config_upcountry_greaterthanequal_charge();
  3615.         /*----------- End of Settings Info -------------*/
  3617.         $settingsdata = ['settingDataId'=>$settingDataId,
  3618.                         'setting_deliveryModes'=>$setting_deliveryModes,
  3619.                         'setting_slot_time_flag'=>$setting_slot_time_flag,
  3620.                         'stg_deliveryslot_config_is_upcountry_configuration_applicable'=>$stg_deliveryslot_config_is_upcountry_configuration_applicable,
  3621.                         'stg_delslot_normalloc_morethan_fromtime'=>$stg_delslot_normalloc_morethan_fromtime,
  3622.                         'stg_delslot_normalloc_lessthaneq_totime'=>$stg_delslot_normalloc_lessthaneq_totime,
  3623.                         'stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays,
  3624.                         'stg_delslot_normalloc_after_totime_extra_generate_slotdays'=>$stg_delslot_normalloc_after_totime_extra_generate_slotdays,
  3625.                         'stg_normalloc_slot_generate_days'=>$stg_normalloc_slot_generate_days,
  3626.                         'stg_delslot_upcountryloc_morethan_fromtime'=>$stg_delslot_upcountryloc_morethan_fromtime,
  3627.                         'stg_delslot_upcountryloc_lessthaneq_totime'=>$stg_delslot_upcountryloc_lessthaneq_totime,
  3628.                         'stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays,
  3629.                         'stg_delslot_upcountryloc_after_totime_extra_generate_slotdays'=>$stg_delslot_upcountryloc_after_totime_extra_generate_slotdays,
  3630.                         'stg_upcountryloc_slot_generate_days'=>$stg_upcountryloc_slot_generate_days,
  3631.                         'stg_is_deliveryfee_config_applicable'=>$stg_is_deliveryfee_config_applicable,
  3632.                         'stg_deliveryfee_config'=>$stg_deliveryfee_config,
  3633.                         'stg_deliveryfee_config_location_lessthan_charge'=>$stg_deliveryfee_config_location_lessthan_charge,
  3634.                         'stg_deliveryfee_config_location_greaterthanequal_charge'=>$stg_deliveryfee_config_location_greaterthanequal_charge,
  3635.                         'stg_deliveryfee_config_upcountry_lessthan_charge'=>$stg_deliveryfee_config_upcountry_lessthan_charge,
  3636.                         'stg_deliveryfee_config_upcountry_greaterthanequal_charge'=>$stg_deliveryfee_config_upcountry_greaterthanequal_charge,
  3637.                         ];
  3638.         
  3640.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Ended - ".$start_method_log_info:"Ended - ".$start_method_log_info;
  3641.         $log_data = $api_log_method_info." | settingsdata:".json_encode($settingsdata);
  3642.         SELF::createApiLog($log_data);
  3643.         
  3644.         return $settingsdata;
  3645.     }
  3647.     function getDatesFromRange($start, $end, $dateformat="Y-m-d"){
  3648.         $dates = array($start);
  3649.         while(end($dates) < $end){
  3650.             $dates[] = date($dateformat, strtotime(end($dates).' +1 day'));
  3651.         }
  3652.         return $dates;
  3653.     }
  3655.     public function getSlotTimeDates($slot_generate_days, $todaydate){
  3656.         $jj=0; $weekdates = [];
  3658.         for($ii=1; $ii<15; $ii++)
  3659.         {
  3660.             if($jj >= 7) break;
  3661.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3662.                 $weekdates[] = $todaydate;
  3663.                 $jj=$jj+1;
  3664.             }
  3665.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3666.         }
  3668.         // echo '<pre>'; print_r($weekdates); die;
  3670.         return $weekdates;
  3671.     }
  3673.     public function getWorkingDate($slot_generate_days, $todaydate){
  3674.         $jj=0; $weekdates = [];
  3676.         for($ii=1; $ii<$slot_generate_days; $ii++)
  3677.         {
  3678.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3679.                 $weekdates[] = $todaydate;
  3680.                 $jj=$jj+1;
  3681.             }
  3682.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3683.         }
  3685.         // echo '<pre>'; print_r($weekdates); die;
  3687.         return $weekdates;
  3688.     }
  3690.     public function createApiLog($content)
  3691.     {
  3692.         $file = '../var/log/slot-api-log_'.date("Y-m-d").'.txt';
  3693.         // chmod($file, 0755);
  3695.         // if(!is_file($file)){
  3696.             // $contents = 'This is a test!';           // Some simple example content.
  3697.             // file_put_contents($file, $content);     // Save our content to the file.
  3698.             file_put_contents($file, date("Y-m-d H:i:s")." | ".$content."\n", FILE_APPEND);
  3699.             chmod($file, 0755);
  3700.         // }
  3701.     }
  3702.     /*----------------------- End of Sub methods -----------------------*/
  3703.     
  3704. }