src/Controller/DeliveryslotapiController.php line 2482

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.         date_default_timezone_set('Asia/Kolkata');
  719.         $api_log_info = "API:Retriving Delivery Slots by Location Code | locCode:".$locCode." - ".date("YmdHis")." ".time();
  720.         $log_data = "Started - ".$api_log_info;
  721.         SELF::createApiLog($log_data);
  723.         $message = SELF::verifyauthToken($api_log_info);
  724.         $log_data = $api_log_info." | message:".json_encode($message);
  725.         SELF::createApiLog($log_data);
  727.         $Is_location_up_country = $is_upcountry_configuration_applicable = '';
  729.         if($message == "No data found")
  730.         {
  731.             $today_date = date("Y-m-d");
  732.             $tomorrow_date = date('Y-m-d', strtotime($today_date . ' +1 day'));
  733.             $dates_list = array($today_date, $tomorrow_date);
  734.             
  735.             $log_data = $api_log_info." | dates_list:".json_encode($dates_list);
  736.             SELF::createApiLog($log_data);
  738.             /*---- Check Location by Location Code ---------*/
  739.             $locationData = DataObject\Locations::getBylocation_code($locCode, 1);
  740.             
  741.             $log_data = $api_log_info." | locationData:".json_encode($locationData);
  742.             SELF::createApiLog($log_data);
  744.             /*--------------- Settings info ----------------*/
  745.             $settingsInfo = SELF::getSettingInfo($api_log_info);
  747.             $log_data = $api_log_info." | settingsInfo:".json_encode($settingsInfo);
  748.             SELF::createApiLog($log_data);
  749.             /*----------- End of Settings Info -------------*/
  750.              /*--------- Getting Delivery Modes settings ----------*/
  751.             $setting_slot_time_flag = $settingsInfo['setting_slot_time_flag'];
  752.             $setting_deliveryModes = $settingsInfo['setting_deliveryModes'];
  753.             $settingDataId = $settingsInfo['settingDataId'];
  754.             // echo 'settingsInfo:<pre>';
  755.             // print_r($settingsInfo); die;
  756.             
  757.             $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);
  758.             SELF::createApiLog($log_data);
  760.             if(!empty($locationData) && !empty($locationData->getId()))
  761.             {
  762.                 $parentLoc_id = $locationData->getId();
  763.                 $parentLocationName = $locationData->getLocation_name();
  764.                 $parentLocationCode = $locationData->getLocation_code();
  765.                 $fastDelivery = $locationData->getfastDeliveryAvailable();
  766.                 $location_type = $locationData->getlocation_type();
  768.                 /*------ Check Location is Up Country or not --------*/
  769.                 $Is_location_up_country = (strpos(strtolower($parentLocationName),"up country") || strpos(strtoupper($parentLocationCode),"UPCTR"))?1:0;
  771.                 $log_data = $api_log_info." | parentLoc_id:".json_encode($parentLoc_id)."| parentLocationName:".json_encode($parentLocationName)."| parentLocationCode:".json_encode($parentLocationCode);
  772.                 SELF::createApiLog($log_data);
  774.                 //------ get holidays list ------------//
  775.                 $holidaysList = DataObject\Holidays::getList();
  776.                 $holidaysList->setCondition("location_code like '%,".$parentLoc_id.",%'");
  777.                 $holidaysList->load();
  778.                 
  779.                 $holidayDates = [];
  780.                 foreach($holidaysList as $holiday)
  781.                 {
  782.                     $log_data = $api_log_info." | holiday:".json_encode($holiday);
  783.                     SELF::createApiLog($log_data);
  785.                     $holiday_locations_list = $holiday->getLocation_code();
  786.                     $holidaydate = $holiday->getHolidaydate();
  787.                     $holidayDate = date("Y-m-d", strtotime($holidaydate));
  789.                     $log_data = $api_log_info." | holiday_locations_list:".json_encode($holiday_locations_list)."| holidaydate:".json_encode($holidaydate);
  790.                     SELF::createApiLog($log_data);
  791.                     
  792.                     $holidaysenddate = $holiday->getHolidaysenddate();
  793.                     if(!empty($holidaysenddate) && $holidaysenddate){
  794.                         $holidaysenddate = date("Y-m-d", strtotime($holidaysenddate));
  795.                         $rangeDates = self::getDatesFromRange($holidayDate, $holidaysenddate);
  797.                         $log_data = $api_log_info." | holidaysenddate:".json_encode($holidaysenddate)."| rangeDates:".json_encode($rangeDates);
  798.                         SELF::createApiLog($log_data);
  799.                         
  800.                         foreach($rangeDates as $rangeDateInfo){
  801.                             array_push($holidayDates,$rangeDateInfo);
  802.                         }
  803.                     } else {
  804.                         array_push($holidayDates,$holidayDate);
  805.                     }
  806.                 }
  808.                 $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  809.                 $delSlotTimesList->setOrderKey("o_id");
  810.                 $delSlotTimesList->setOrder("desc");
  811.                 $delSlotTimesList->load();
  813.                 // foreach($dates_list as $cur_date){
  815.                     $log_data = $api_log_info." | delSlotTimesList count:".count($delSlotTimesList);
  816.                     SELF::createApiLog($log_data);
  817.                     
  818.                     if(count($delSlotTimesList) > 0){
  820.                         $cur_time = date("H:i");//"09:00";//
  822.                         $log_data = $api_log_info." | cur_time:".$cur_time;
  823.                         SELF::createApiLog($log_data);
  825.                         foreach($delSlotTimesList as $delSlotTimes)
  826.                         {
  827.                             $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  828.                             SELF::createApiLog($log_data);
  830.                             //------- Get Week Dates based on Holidays and Slot Time data ---------//
  831.                             $slot_prepare_days = ($delSlotTimes->getprepare_days())?$delSlotTimes->getprepare_days():0;
  832.                             $slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():7;
  833.                             $saturday_slot_availability = ($delSlotTimes->getsaturday_slot_availability())?$delSlotTimes->getsaturday_slot_availability():'No';
  834.                             $sunday_slot_availability = ($delSlotTimes->getsunday_slot_availability())?$delSlotTimes->getsunday_slot_availability():'No';
  836.                             $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);
  837.                             SELF::createApiLog($log_data);
  839.                             /*--------------------- Up Country Configuration ------------------------*/
  840.                             $is_upcountry_configuration_applicable = ($delSlotTimes->getis_upcountry_configuration_applicable())?$delSlotTimes->getis_upcountry_configuration_applicable():'No';
  841.                             $slot_upcountry_prepare_days = ($delSlotTimes->getupcountry_prepare_days())?$delSlotTimes->getupcountry_prepare_days():0;
  842.                             $upcountry_slot_generate_days = ($delSlotTimes->getupcountry_slot_generate_days())?$delSlotTimes->getupcountry_slot_generate_days():7;
  843.                             $upcountry_saturday_slot_availability = ($delSlotTimes->getupcountry_saturday_slot_availability())?$delSlotTimes->getupcountry_saturday_slot_availability():'No';
  844.                             $upcountry_sunday_slot_availability = ($delSlotTimes->getupcountry_sunday_slot_availability())?$delSlotTimes->getupcountry_sunday_slot_availability():'No';
  846.                             $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);
  847.                             SELF::createApiLog($log_data);
  849.                             /*--------------------- Darkstore Configuration ------------------------*/
  850.                             $is_darkstore_configuration_applicable = ($delSlotTimes->getis_darkstore_configuration_applicable())?$delSlotTimes->getis_darkstore_configuration_applicable():'No';
  851.                             $slot_darkstore_prepare_days = ($delSlotTimes->getdarkstore_prepare_days())?$delSlotTimes->getdarkstore_prepare_days():0;
  852.                             $darkstore_slot_generate_days = ($delSlotTimes->getdarkstore_slot_generate_days())?$delSlotTimes->getdarkstore_slot_generate_days():7;
  853.                             $darkstore_saturday_slot_availability = ($delSlotTimes->getdarkstore_saturday_slot_availability())?$delSlotTimes->getdarkstore_saturday_slot_availability():'No';
  854.                             $darkstore_sunday_slot_availability = ($delSlotTimes->getdarkstore_sunday_slot_availability())?$delSlotTimes->getdarkstore_sunday_slot_availability():'No';
  856.                             $log_data = $api_log_info." | is_darkstore_configuration_applicable:".json_encode($is_darkstore_configuration_applicable)."| slot_darkstore_prepare_days:".json_encode($slot_darkstore_prepare_days)."| darkstore_slot_generate_days:".json_encode($darkstore_slot_generate_days)."| darkstore_saturday_slot_availability:".json_encode($darkstore_saturday_slot_availability)."| darkstore_sunday_slot_availability:".json_encode($darkstore_sunday_slot_availability);
  857.                             SELF::createApiLog($log_data);
  859.                             $log_data = $api_log_info." | settings stg_deliveryslot_config_is_darkstore_configuration_applicable:".json_encode($settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'])."| location_type:".json_encode($location_type);
  860.                             SELF::createApiLog($log_data);
  862.                             // echo '<pre>';
  863.                             // print_r($settingsInfo);die;
  865.                             // echo $settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'];
  866.                             // echo "<br>";
  867.                             // echo $location_type;
  868.                             // die;
  870.                             if($settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'] == 'Yes' && $location_type == 'Darkstore')
  871.                             {                                
  872.                                 $slot_prepare_days = $slot_darkstore_prepare_days;
  873.                                 $slot_generate_days = $darkstore_slot_generate_days;
  874.                                 $saturday_slot_availability = $darkstore_saturday_slot_availability;
  875.                                 $sunday_slot_availability = $darkstore_sunday_slot_availability;
  876.                                 
  877.                                 $cur_slot_generate_days = ($delSlotTimes->getdarkstore_slot_generate_days())?$delSlotTimes->getdarkstore_slot_generate_days():0;
  878.                                 
  879.                                 $stg_normalloc_upcounry_slot_generate_days = ($cur_time > $settingsInfo['stg_delslot_darkstoreloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_darkstoreloc_lessthaneq_totime'])?$settingsInfo['stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays']:$settingsInfo['stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays'];
  881.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  883.                                 $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);
  884.                                 SELF::createApiLog($log_data);
  885.                             } else 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)
  886.                             {                                
  887.                                 $slot_prepare_days = $slot_upcountry_prepare_days;
  888.                                 $slot_generate_days = $upcountry_slot_generate_days;
  889.                                 $saturday_slot_availability = $upcountry_saturday_slot_availability;
  890.                                 $sunday_slot_availability = $upcountry_sunday_slot_availability;
  891.                                 
  892.                                 $cur_slot_generate_days = ($delSlotTimes->getupcountry_slot_generate_days())?$delSlotTimes->getupcountry_slot_generate_days():0;
  893.                                 
  894.                                 // $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'];
  895.                                 
  896.                                 $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'];
  898.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  900.                                 $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);
  901.                                 SELF::createApiLog($log_data);
  902.                             } else {
  903.                                 $cur_slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():0;
  905.                                 // $slot_generate_days = ($cur_time > $setting_slot_time_flag)?$slot_generate_days+1:$slot_generate_days;
  907.                                 $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'];
  909.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  911.                                 $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);
  912.                                 SELF::createApiLog($log_data);
  913.                             }
  915.                             $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;
  916.                             $cur_slot_prepare_days = (!empty($fastDelivery)) ? 0 : $cur_slot_prepare_days;
  918.                             $log_data = $api_log_info." | cur_slot_prepare_days:".json_encode($cur_slot_prepare_days);
  919.                             SELF::createApiLog($log_data);
  920.                             
  921.                             $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];
  923.                             $log_data = $api_log_info." | delSlotTimesAvailibility:".json_encode($delSlotTimesAvailibility);
  924.                             SELF::createApiLog($log_data);
  925.                             
  926.                             $weekdates = self::getWeekDates($holidayDates, date("Y-m-d"), $delSlotTimesAvailibility);
  928.                             $log_data = $api_log_info." | weekdates:".json_encode($weekdates);
  929.                             SELF::createApiLog($log_data);
  930.                             // echo $cur_time." | ".$setting_slot_time_flag;
  931.                             // echo 'delSlotTimesAvailibility<pre>:';
  932.                             // print_r($delSlotTimesAvailibility);
  933.                             // echo 'weekdates<pre>:';
  934.                             // print_r($weekdates);die;
  935.                             //------- Get Week Dates based on Holidays and Slot Time data ---------//
  937.                             // $prepare_days = $delSlotTimes->getprepare_days();
  938.                             // $delSlot_date = ($prepare_days == 0)?$tomorrow_date:date('Y-m-d', strtotime($today_date . ' +'.$prepare_days.' day'));
  939.                             if($settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'] == 'Yes' && $location_type == 'Darkstore')
  940.                             {
  941.                                 $delSlot_date = ($slot_prepare_days == 0)?date('Y-m-d'):date('Y-m-d', strtotime($today_date . ' +'.$slot_prepare_days.' day'));
  942.                             } else {
  943.                                 $delSlot_date = ($slot_prepare_days == 0)?$tomorrow_date:date('Y-m-d', strtotime($today_date . ' +'.$slot_prepare_days.' day'));
  944.                             }
  946.                             if(!empty($fastDelivery)){
  948.                                 date_default_timezone_set('Asia/Kolkata');
  950.                                 $delSlot_date = date('Y-m-d');
  951.                                 
  952.                                 // Get the current hour
  953.                                 $currentHour = (int)date('H');
  955.                                 // Check if the current time is greater than 6 PM
  956.                                 if ($currentHour >= 18) {
  957.                                     // Add one day to the current date
  958.                                     $delSlot_date = date('Y-m-d', strtotime($delSlot_date . ' +1 day'));
  959.                                 }
  960.                             }
  962.                             $delSlot_date1 = date("Y-m-d", strtotime($delSlot_date));
  963.                             
  964.                             $cur_time_data = explode(" ",$cur_time);
  966.                             // $slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():0;
  968.                             // $slot_generate_days_limit = ($slot_generate_days > 0)?$slot_generate_days:1;
  969.                             $slot_generate_days_limit = ($cur_slot_generate_days > 0)?$cur_slot_generate_days:1;
  971.                             $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);
  972.                             SELF::createApiLog($log_data);
  974.                             // echo $tomorrow_date.":".$weekdates[0];
  975.                             /* if($cur_time > $setting_slot_time_flag)//if($cur_time > '18:00')
  976.                             {
  977.                                 // if($tomorrow_date >= $weekdates[0])
  978.                                 // {
  979.                                 //     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  980.                                 // } else {
  981.                                 //     $no_of_weekdates = count($weekdates);
  982.                                 //     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[$no_of_weekdates-1]])):[$weekdates[0]];
  983.                                 // }
  984.                                 
  985.                                 $no_of_weekdates = count($weekdates);
  986.                                 // $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[$no_of_weekdates-1]])):[$weekdates[0]];
  988.                                 $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  989.                             } else {
  990.                                 $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  991.                             } */
  993.                             /* if($settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'] == 'Yes' && $Is_location_up_country == 1)
  994.                             {
  995.                                 if($cur_time > $settingsInfo['stg_delslot_upcountryloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_upcountryloc_lessthaneq_totime'])
  996.                                 {
  997.                                     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  998.                                 } else {
  999.                                     $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  1000.                                 }
  1001.                                 if(($slot_generate_days > 0)){
  1002.                                     for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days; $ii++)
  1003.                                     {
  1004.                                         $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  1005.                                     }
  1006.                                 } else 
  1007.                                 $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1008.                                 
  1009.                             } else {
  1010.                                 $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'];
  1011.                             } */
  1013.                             /* if(($slot_generate_days > 0)){
  1014.                                 for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days; $ii++)
  1015.                                 {
  1016.                                     $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  1017.                                 }
  1018.                             } else 
  1019.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]]; */
  1021.                             /*
  1022.                             if(($slot_generate_days > 0)){
  1023.                                 if($stg_normalloc_upcounry_slot_generate_days>1)
  1024.                                 {
  1025.                                     for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days-1; $ii++)
  1026.                                     {
  1027.                                         $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  1028.                                     }
  1029.                                 }
  1031.                                 $cur_weekdates = [];
  1032.                                 if($cur_slot_generate_days > 0){
  1033.                                     for($jj=0; $jj < $cur_slot_generate_days; $jj++)
  1034.                                     {
  1035.                                         array_push($cur_weekdates,$weekdates[$jj]);
  1036.                                     }
  1037.                                 }
  1039.                                 $weekdates = $cur_weekdates;
  1041.                             } else 
  1042.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1044.                             */
  1046.                             $log_data = $api_log_info." | slot_generate_days:".json_encode($slot_generate_days)."| cur_slot_generate_days:".json_encode($cur_slot_generate_days);
  1047.                             SELF::createApiLog($log_data);
  1049.                             if(($slot_generate_days > 0)){
  1050.                                 $cur_weekdates = [];
  1051.                                 if($cur_slot_generate_days > 0){
  1052.                                     for($jj=0; $jj < $cur_slot_generate_days; $jj++)
  1053.                                     {
  1054.                                         $log_data = $api_log_info." | jj:".json_encode($jj)."| cur_weekdates:".json_encode($cur_weekdates)."| weekdates:".json_encode($weekdates);
  1055.                                         SELF::createApiLog($log_data);
  1057.                                         array_push($cur_weekdates,$weekdates[$jj]);
  1058.                                     }
  1059.                                 }
  1061.                                 $weekdates = $cur_weekdates;
  1063.                             } else 
  1064.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1066.                             $log_data = $api_log_info." | stg_normalloc_upcounry_slot_generate_days:".json_encode($stg_normalloc_upcounry_slot_generate_days)."| weekdates:".json_encode($weekdates);
  1067.                             SELF::createApiLog($log_data);
  1069.                             // $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  1071.                             // echo 'weekdates:<pre>:'; print_r($weekdates);
  1072.                             
  1073.                             $slot_generate_days_date  = date('Y-m-d', strtotime($today_date . ' +'.$slot_generate_days.' day'));
  1075.                             $delivery_modes = $setting_deliveryModes;//['standard','express'];//['courier','standard','express'];
  1077.                             $locationSlotRule = new DataObject\Deliveryslotrules\Listing();
  1078.                             $locationSlotRule->setCondition(" FIND_IN_SET('".$parentLoc_id."',location_ids) ");
  1079.                             $locationSlotRule = $locationSlotRule->getData();
  1081.                             if (count($locationSlotRule)) {
  1082.                                 $delivery_modes = array();
  1083.                                 foreach ($locationSlotRule as $slv) {
  1084.                                     $delivery_modes[] = $slv->getdelivery_mode();
  1085.                                 }
  1086.                             }
  1088.                             $log_data = $api_log_info." | slot_generate_days_date:".json_encode($slot_generate_days_date)."| delivery_modes:".json_encode($delivery_modes);
  1089.                             SELF::createApiLog($log_data);
  1091.                             $delivery_mode_slots_all = [];
  1092.                             foreach($delivery_modes as $delivery_mode)
  1093.                             {
  1094.                                 $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)."| delSlotTimes Title:".json_encode($delSlotTimes->gettitle());
  1095.                                 SELF::createApiLog($log_data);
  1097.                                 if($delSlotTimes->gettitle() == 'customized' && (!in_array($delivery_mode,['standard'])))
  1098.                                 {
  1099.                                     $delivery_mode_slots_all[$delivery_mode] = [];
  1100.                                 } else if($delSlotTimes->gettitle() == 'Confectionery' && (!in_array($delivery_mode,['standard','express'])))
  1101.                                 {
  1102.                                     $delivery_mode_slots_all[$delivery_mode] = [];
  1103.                                 } else {
  1104.                                     $slotsList = DataObject\Slots::getList();
  1106.                                     if($cur_time > $setting_slot_time_flag)//if($cur_time > '18:00')
  1107.                                     {
  1108.                                         $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]);
  1109.                                     } else {
  1110.                                         if($delivery_mode == 'standard')
  1111.                                         {
  1112.                                             $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]);
  1113.                                         } else
  1114.                                         {
  1115.                                             $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]);
  1116.                                         }
  1117.                                     }
  1119.                                     $slotsList->setOrderKey("slotdate");
  1120.                                     $slotsList->setOrder("asc");
  1121.                                     $slotsList->load();
  1123.                                     // if($slot_generate_days == 3)
  1124.                                     // {
  1125.                                     //     echo '<pre>';
  1126.                                     //     print_r($slotsList); die;
  1127.                                     // }
  1129.                                     /*---------- Slots Loop Starts ----------*/
  1130.                                     $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList))."| cur_slot_generate_days:".json_encode($cur_slot_generate_days);
  1131.                                     SELF::createApiLog($log_data);
  1133.                                     $delivery_mode_slots = [];
  1134.                                     if(count($slotsList) > 0 && $cur_slot_generate_days>0){
  1135.                                         foreach($slotsList as $slot)
  1136.                                         {
  1137.                                             $log_data = $api_log_info." | slot:".json_encode($slot);
  1138.                                             SELF::createApiLog($log_data);
  1140.                                             $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1141.                                             $loc_name = $slotLocationData->getlocation_name();
  1143.                                             $delivery_mode_slot1 = array(
  1144.                                                 "slotId" => $slot->getId(),
  1145.                                                 "prior_time" => $slot->getprior_time(),
  1146.                                                 "slotdate" => date("Y-m-d", strtotime($slot->getslotdate())),//$slot->getslotdate(),//$delSlot_date1,//
  1147.                                                 "loc_name" => $loc_name,
  1148.                                                 "fromtime" => $slot->getfromtime(),
  1149.                                                 "totime" => $slot->gettotime(),
  1150.                                                 "maxorder" => $slot->getmaxorder(),
  1151.                                                 "ordercount" => $slot->getordercount(),
  1152.                                                 "delivery_mode" => $slot->getdelivery_mode(),
  1153.                                             );
  1154.                                             array_push($delivery_mode_slots, $delivery_mode_slot1);
  1156.                                             $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1)."| delivery_mode_slots:".json_encode($delivery_mode_slots);
  1157.                                             SELF::createApiLog($log_data);
  1158.                                         }
  1159.                                     }
  1160.                                     /*---------- Slots Loop Starts ----------*/
  1162.                                     $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1164.                                     $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1165.                                     SELF::createApiLog($log_data);
  1167.                                     // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1168.                                     if ($fastDelivery) {
  1169.                                         if ($delivery_mode == 'standard') {
  1170.                                             $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1171.                                         } else {
  1172.                                             $delivery_mode_slots_all[$delivery_mode] = (!empty($delivery_mode_slots[0]) ? array($delivery_mode_slots[0]) : array());
  1173.                                         }
  1174.                                     } else {
  1175.                                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1176.                                     }
  1178.                                     $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)."| delivery_mode_slots:".json_encode($delivery_mode_slots);
  1179.                                     SELF::createApiLog($log_data);
  1180.                                 }
  1181.                             }
  1183.                             $data[] = array(
  1184.                                 // "LocationName" => $parentLocationName,
  1185.                                 // "LocationCode" => $parentLocationCode,
  1186.                                 // "Is_location_up_country" => $Is_location_up_country,
  1187.                                 "location_type" => $location_type,
  1188.                                 "is_upcountry_configuration_applicable" => $is_upcountry_configuration_applicable,
  1189.                                 "stg_normalloc_upcounry_slot_generate_days" => $stg_normalloc_upcounry_slot_generate_days,
  1190.                                 "deliverytype_id" => $delSlotTimes->gettitle(),
  1191.                                 "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1192.                                 "prepare_days" => $slot_prepare_days,//$delSlotTimes->getprepare_days(),
  1193.                                 "slot_generate_days" => $cur_slot_generate_days,//$slot_generate_days,
  1194.                                 "delSlot_date" => $delSlot_date1,
  1195.                                 "slots"=>$delivery_mode_slots_all);
  1197.                                 $log_data = $api_log_info." | data:".json_encode($data);
  1198.                                 SELF::createApiLog($log_data);
  1200.                         }
  1201.                     } else $data[] = ['message'=>$message];
  1202.                 // }
  1203.             } else $data[] = ['message'=>$message];
  1204.             
  1205.         } else $data[] = ['message'=>$message];
  1207.         $return_data = ["success" => true, "Is_location_up_country" => $Is_location_up_country, "data" => $data];
  1209.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  1210.         SELF::createApiLog($log_data);
  1212.         return $this->json(["success" => true, "Is_location_up_country" => $Is_location_up_country, "data" => $data]);
  1213.     }
  1215.     /**
  1216.      * @Route("/api/allslots")
  1217.      */
  1218.     public function allslotsAction()
  1219.     {
  1220.         $api_log_info = "API:All Available Slots - ".date("YmdHis")." ".time();
  1221.         $log_data = "Started - ".$api_log_info;
  1222.         SELF::createApiLog($log_data);
  1224.         $message = SELF::verifyauthToken($api_log_info);
  1225.         $log_data = $api_log_info." | message:".json_encode($message);
  1226.         SELF::createApiLog($log_data);
  1228.         if($message == "No data found")
  1229.         {
  1230.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1231.             $delSlotTimesList->load();
  1233.             // $delivery_modes = ['courier','standard','express'];
  1234.             // $slotsList = DataObject\Slots::getList();
  1235.             // $slotsList->setCondition("delivery_mode = 'courier'");
  1236.             // // if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1237.             // //     $slotsList->filterBydelivery_mode($courier_mode, '=');
  1238.             // // }
  1239.             // $slotsList->load();
  1241.             // echo '<pre>kk'; print_r($slotsList); die;
  1243.             $log_data = $api_log_info." | delSlotTimesList count:".json_encode(count($delSlotTimesList));
  1244.             SELF::createApiLog($log_data);
  1246.             if(count($delSlotTimesList) > 0){
  1247.                 foreach($delSlotTimesList as $delSlotTimes)
  1248.                 {
  1249.                     $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  1250.                     SELF::createApiLog($log_data);
  1252.                     $prepare_days = $delSlotTimes->getprepare_days();
  1253.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1255.                     $delSlot_date1 = date("Y-m-d");//date("Y-m-d", strtotime($delSlot_date));
  1256.                     $cur_time = date("H:i");
  1258.                     // $delSlotTimes->delSlot_date = $delSlot_date;
  1260.                     $delivery_modes = ['courier','standard','express'];
  1262.                     $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);
  1263.                     SELF::createApiLog($log_data);
  1265.                     $delivery_mode_slots_all = [];
  1266.                     foreach($delivery_modes as $delivery_mode)
  1267.                     {
  1268.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode);
  1269.                         SELF::createApiLog($log_data);
  1271.                         $slotsList = DataObject\Slots::getList();
  1272.                         // $slotsList->setCondition("delivery_mode = '".$delivery_mode."'");
  1273.                         if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  1274.                             $slotsList->filterBySlotdate($delSlot_date1, '>=');
  1275.                         }
  1276.                         // if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  1277.                         //     $slotsList->filterByprior_time($cur_time, '>=');
  1278.                         // }
  1279.                         if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1280.                             $slotsList->filterBydelivery_mode($delivery_mode, '>=');
  1281.                         }
  1282.                         $slotsList->setLimit(100);
  1283.                         $slotsList->setOrderKey("slotdate");
  1284.                         $slotsList->setOrder("asc");
  1285.                         $slotsList->load();
  1287.                         /*---------- Slots Loop Starts ----------*/
  1288.                         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  1289.                         SELF::createApiLog($log_data);
  1291.                         $delivery_mode_slots = [];
  1292.                         if(count($slotsList) > 0){
  1293.                             foreach($slotsList as $slot)
  1294.                             {
  1295.                                 $log_data = $api_log_info." | slot:".json_encode($slot);
  1296.                                 SELF::createApiLog($log_data);
  1297.                                 // $loc_name = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_name():'';
  1298.                                 // $loc_code = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_code():'';
  1300.                                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1301.                                 $loc_name = $slotLocationData->getlocation_name();
  1302.                                 $loc_code = $slotLocationData->getlocation_code();
  1304.                                 $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData)." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  1305.                                 SELF::createApiLog($log_data);
  1307.                                 $delivery_mode_slot1 = array(
  1308.                                     "slotId" => $slot->getId(),
  1309.                                     "prior_time" => $slot->getprior_time(),
  1310.                                     // "picking_time" => $slot->getpicking_time(),
  1311.                                     // "charge" => $slot->getcharge(),
  1312.                                     "slotdate" => $slot->getslotdate(),
  1313.                                     "loc_name" => $loc_name,
  1314.                                     "loc_code" => $loc_code,
  1315.                                     "fromtime" => $slot->getfromtime(),
  1316.                                     "totime" => $slot->gettotime(),
  1317.                                     "maxorder" => $slot->getmaxorder(),
  1318.                                     "ordercount" => $slot->getordercount(),
  1319.                                     "delivery_mode" => $slot->getdelivery_mode()
  1320.                                 );
  1322.                                 $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1);
  1323.                                 SELF::createApiLog($log_data);
  1325.                                 array_push($delivery_mode_slots, $delivery_mode_slot1);
  1327.                                 $log_data = $api_log_info." | delivery_mode_slots:".json_encode($delivery_mode_slots);
  1328.                                 SELF::createApiLog($log_data);
  1329.                             }
  1330.                         }
  1331.                         /*---------- Slots Loop Starts ----------*/
  1333.                         $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1335.                         $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1336.                         SELF::createApiLog($log_data);
  1338.                         // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1339.                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1341.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)." | delivery_mode_slots_all:".json_encode($delivery_mode_slots_all);
  1342.                         SELF::createApiLog($log_data);
  1343.                     }
  1345.                     $data[] = array(
  1346.                         "deliverytype_id" => $delSlotTimes->gettitle(),
  1347.                         "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1348.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1349.                         "delSlot_date" => $delSlot_date,
  1350.                         "slots"=>$delivery_mode_slots_all);
  1351.                     
  1352.                     $log_data = $api_log_info." | data:".json_encode($data);
  1353.                     SELF::createApiLog($log_data);
  1355.                 }
  1356.             } else $data[] = [];
  1358.         } else $data[] = ['message'=>$message];
  1359.         $data = (empty($data))?$message:$data;
  1360.                 
  1361.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  1362.         SELF::createApiLog($log_data);
  1364.         return $this->json(["success" => true, "data" => $data]);
  1365.     }
  1367.     /*------------------------------ End of Slots Related APIs -------------------------*/
  1369.     /*---------------------------------- Delivery Slot Time Related APIs ----------------------------*/
  1370.     /**
  1371.      * @Route("/deliveryslottime/getslottimes")
  1372.      */
  1373.     public function getslottimesAction()
  1374.     {
  1375.         $api_log_info = "API:Retriving all Delivery Slot times / Confencery Days - ".date("YmdHis")." ".time();
  1376.         $log_data = "Started - ".$api_log_info;
  1377.         SELF::createApiLog($log_data);
  1379.         $message = SELF::verifyauthToken($api_log_info);
  1380.         $log_data = $api_log_info." | message:".json_encode($message);
  1381.         SELF::createApiLog($log_data);
  1382.         
  1383.         if($message == "No data found")
  1384.         {
  1385.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1386.             $delSlotTimesList->load();
  1388.             $log_data = $api_log_info." | delSlotTimesList Count ; ".count($delSlotTimesList);
  1389.             SELF::createApiLog($log_data);
  1391.             if(count($delSlotTimesList) > 0){
  1392.                 foreach($delSlotTimesList as $delSlotTimes)
  1393.                 {
  1394.                     $log_data = $api_log_info." | delSlotTimes ; ".json_encode($delSlotTimes);
  1395.                     SELF::createApiLog($log_data);
  1397.                     $prepare_days = $delSlotTimes->getprepare_days();
  1398.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1400.                     $data[] = array(
  1401.                         "title" => $delSlotTimes->gettitle(),
  1402.                         "deliverytype_id" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1403.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1404.                         "delSlot_date" => $delSlot_date);
  1406.                         $log_data = $api_log_info." | data ; ".json_encode($data);
  1407.                         SELF::createApiLog($log_data);
  1409.                 }
  1410.             } else $data = "No data found";
  1411.         }else $data[] = ['message'=>$message];
  1412.         $data = (empty($data))?$message:$data;
  1414.         $log_data = "Ended - ".$api_log_info." | data ; ".json_encode($data);
  1415.         SELF::createApiLog($log_data);
  1417.         return $this->json(["success" => true, "data" => $data]);
  1418.     }
  1420.     /**
  1421.      * @Route("/deliveryslottime/getslottimeslist")
  1422.      */
  1423.     public function getslottimeslistAction()
  1424.     {
  1425.         $api_log_info = "API:Retriving all Delivery Slots - ".date("YmdHis")." ".time();
  1426.         $log_data = "Started - ".$api_log_info;
  1427.         SELF::createApiLog($log_data);
  1429.         $message = SELF::verifyauthToken($api_log_info);
  1430.         $log_data = $api_log_info." | message:".json_encode($message);
  1431.         SELF::createApiLog($log_data);
  1432.         
  1433.         if($message == "No data found")
  1434.         {
  1435.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1436.             $delSlotTimesList->load();
  1438.             // $delivery_modes = ['courier','standard','express'];
  1439.             // $slotsList = DataObject\Slots::getList();
  1440.             // $slotsList->setCondition("delivery_mode = 'courier'");
  1441.             // // if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1442.             // //     $slotsList->filterBydelivery_mode($courier_mode, '=');
  1443.             // // }
  1444.             // $slotsList->load();
  1446.             // echo '<pre>kk'; print_r($slotsList); die;
  1448.             $log_data = $api_log_info." | delSlotTimesList:".json_encode(count($delSlotTimesList));
  1449.             SELF::createApiLog($log_data);
  1451.             if(count($delSlotTimesList) > 0){
  1452.                 foreach($delSlotTimesList as $delSlotTimes)
  1453.                 {
  1454.                     $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  1455.                     SELF::createApiLog($log_data);
  1457.                     $prepare_days = $delSlotTimes->getprepare_days();
  1458.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1460.                     $delSlot_date1 = date("Y-m-d", strtotime($delSlot_date));
  1461.                     $cur_time = date("H:i");
  1463.                     // $delSlotTimes->delSlot_date = $delSlot_date;
  1465.                     $delivery_modes = ['courier','standard','express'];
  1467.                     $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);
  1468.                     SELF::createApiLog($log_data);
  1470.                     $delivery_mode_slots_all = [];
  1471.                     foreach($delivery_modes as $delivery_mode)
  1472.                     {
  1473.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode);
  1474.                         SELF::createApiLog($log_data);
  1476.                         $slotsList = DataObject\Slots::getList();
  1477.                         // $slotsList->setCondition("delivery_mode = '".$delivery_mode."'");
  1478.                         if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  1479.                             $slotsList->filterBySlotdate($delSlot_date1, '=');
  1480.                         }
  1481.                         if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  1482.                             $slotsList->filterByprior_time($cur_time, '>=');
  1483.                         }
  1484.                         if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1485.                             $slotsList->filterBydelivery_mode($delivery_mode, '>=');
  1486.                         }
  1487.                         $slotsList->setLimit(100);
  1488.                         $slotsList->setOrderKey("slotdate");
  1489.                         $slotsList->setOrder("asc");
  1490.                         $slotsList->load();
  1492.                         /*---------- Slots Loop Starts ----------*/
  1494.                         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  1495.                         SELF::createApiLog($log_data);
  1497.                         $delivery_mode_slots = [];
  1498.                         if(count($slotsList) > 0){
  1499.                             foreach($slotsList as $slot)
  1500.                             {
  1501.                                 $log_data = $api_log_info." | slot:".json_encode($slot);
  1502.                                 SELF::createApiLog($log_data);
  1504.                                 // $loc_name = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_name():'';
  1505.                                 // $loc_code = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_code():'';
  1507.                                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1508.                                 $loc_name = $slotLocationData->getlocation_name();
  1509.                                 $loc_code = $slotLocationData->getlocation_code();
  1511.                                 $delivery_mode_slot1 = array(
  1512.                                     "slotId" => $slot->getId(),
  1513.                                     "prior_time" => $slot->getprior_time(),
  1514.                                     // "picking_time" => $slot->getpicking_time(),
  1515.                                     // "charge" => $slot->getcharge(),
  1516.                                     "slotdate" => $slot->getslotdate(),
  1517.                                     "loc_name" => $loc_name,
  1518.                                     "loc_code" => $loc_code,
  1519.                                     "fromtime" => $slot->getfromtime(),
  1520.                                     "totime" => $slot->gettotime(),
  1521.                                     "maxorder" => $slot->getmaxorder(),
  1522.                                     "ordercount" => $slot->getordercount(),
  1523.                                     "delivery_mode" => $slot->getdelivery_mode()
  1524.                                 );
  1525.                                 array_push($delivery_mode_slots, $delivery_mode_slot1);
  1527.                                 $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1)." | delivery_mode_slots:".json_encode($delivery_mode_slots);
  1528.                                 SELF::createApiLog($log_data);
  1529.                             }
  1530.                         }
  1531.                         /*---------- Slots Loop Starts ----------*/
  1533.                         $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1535.                         $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1536.                         SELF::createApiLog($log_data);
  1538.                         // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1539.                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1541.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)." | delivery_mode_slots_all:".json_encode($delivery_mode_slots_all);
  1542.                         SELF::createApiLog($log_data);
  1543.                     }
  1545.                     $data[] = array(
  1546.                         "deliverytype_id" => $delSlotTimes->gettitle(),
  1547.                         "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1548.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1549.                         "delSlot_date" => $delSlot_date,
  1550.                         "slots"=>$delivery_mode_slots_all);
  1551.                         
  1552.                     $log_data = $api_log_info." | data:".json_encode($data);
  1553.                     SELF::createApiLog($log_data);
  1555.                 }
  1556.             } else $data[] = [];
  1558.         }else $data[] = ['message'=>$message];
  1559.         $data = (empty($data))?$message:$data;
  1561.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  1562.         SELF::createApiLog($log_data);
  1564.         return $this->json(["success" => true, "data" => $data]);
  1565.     }
  1566.     /*------------------------------ End of Delivery Slot Time Related APIs -------------------------*/
  1568.     /*----------------------------------- AWS S3 Bucket Related APIs ---------------------------*/
  1569.     /**
  1570.      * @Route("/awss3bucket/gets3bucketlist")
  1571.      */
  1572.     public function gets3bucketlistAction()
  1573.     {
  1574.         putenv('AWS_DEFAULT_REGION=us-east-2');
  1575.         putenv('AWS_ACCESS_KEY_ID=AKIAUY45FDQLWT32YTPJ');
  1576.         putenv('AWS_SECRET_ACCESS_KEY=IyaHsvQqIdeyDvUrpmlm4T/xizd5999KCpuBP8vg');
  1578.         // $output = shell_exec('aws s3 ls');
  1579.         try
  1580.         {
  1581.             $output = shell_exec('aws s3api create-bucket --bucket snap2web-13 --region us-east-2 --create-bucket-configuration LocationConstraint=us-east-2');
  1582.         } catch(Exception $e)
  1583.         {
  1584.             echo $e->getMessage(); die;
  1585.         }
  1586.         // echo "<pre>$output</pre>";
  1588.         echo '<pre>'; print_r($output); die;
  1591.         return $this->json(["success" => true, "data" => $data]);
  1592.     }
  1594.     /**
  1595.      * @Route("/awss3bucket/uploadFileToS3")
  1596.      */
  1597.     public function uploadFileToS3()
  1598.     {
  1599.         $curl = curl_init();
  1601.         curl_setopt_array($curl, array(
  1602.         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',
  1603.         CURLOPT_RETURNTRANSFER => true,
  1604.         CURLOPT_ENCODING => '',
  1605.         CURLOPT_MAXREDIRS => 10,
  1606.         CURLOPT_TIMEOUT => 0,
  1607.         CURLOPT_FOLLOWLOCATION => true,
  1608.         CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1609.         CURLOPT_CUSTOMREQUEST => 'PUT',
  1610.         CURLOPT_POSTFIELDS => "<file contents here>",
  1611.         CURLOPT_HTTPHEADER => array(
  1612.             'Content-Type: text/plain'
  1613.         ),
  1614.         ));
  1616.         $response = curl_exec($curl);
  1618.         curl_close($curl);
  1619.         echo $response;
  1621.     }
  1622.     /*------------------------------ End of AWS S3 Bucket Related APIs -------------------------*/
  1624.     /**
  1625.      * @Route("/user/login", methods={"POST"})
  1626.      */
  1627.     public function userLogin(Request $request)
  1628.     {
  1629.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  1630.         $userName = (isset($reqparams['username']))?$reqparams['username']:'';
  1631.         $password = (isset($reqparams['password']))?$reqparams['password']:'';
  1632.         if($userName == '' || $password == '')
  1633.         {
  1634.             $data = "Username and Password are mandatory!";
  1635.         } else {
  1636.             $user = User::getByName($userName);
  1637.             if($user) {
  1638.                 $validateUser = \Pimcore\Tool\Authentication::authenticatePlaintext($userName,$password);
  1639.                 if($validateUser) {
  1641.                     $userInfo = ['id'=>$validateUser->getId(),
  1642.                                 'firstname'=>$validateUser->getfirstname(),
  1643.                                 'lastname'=>$validateUser->getlastname(),
  1644.                                 'email'=>$validateUser->getemail(),
  1645.                                 ];
  1647.                     $generateAuthTokenInfo = SELF::generateAuthToken($userInfo);
  1648.                     $generateAuthToken = $generateAuthTokenInfo['generateAuthToken'];
  1649.                     $jwtToken = (!empty($generateAuthTokenInfo['jwt']))?$generateAuthTokenInfo['jwt']:'';
  1650.                     $userId = $validateUser->getId(); 
  1652.                     $dbConnection = \Pimcore\Db::get();
  1654.                     $dbConnection->query("UPDATE users SET `authToken` = ? WHERE id = ?", [$generateAuthToken, $userId]);
  1656.                     $userData = User::getById($userId);
  1657.                     $authTokenVal = $dbConnection->fetchOne("SELECT authToken FROM users WHERE id = ".$userId);
  1659.                     $data = ["message"=>'Login successfull', "authToken"=>$authTokenVal];
  1661.                     if($jwtToken!='')
  1662.                         $data = ["message"=>'Login successfull', "authToken"=>$authTokenVal, "jwtToken"=>$jwtToken];
  1663.                     
  1664.                 } else {
  1665.                     $data = 'Wrong password';
  1666.                 }
  1667.             } else {
  1668.                 $data = 'User not found';
  1669.             }
  1670.         }
  1672.         return $this->json(["success" => true, "data" => $data]);
  1673.     }
  1675.     /*---------------------------------- JWT Related APIs ----------------------------*/
  1676.     /**
  1677.      * @Route("/api/gernerateJwtToken")
  1678.      */
  1679.     public function gernerateJwtTokenAction()
  1680.     {
  1681.         $id = 1024;
  1682.         $firstname = 'Tex';
  1683.         $lastname = 'Hardrock';
  1684.         $email = 'dino@stone.age';
  1686.         $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  1687.         $issuer_claim = "pimcore6.local"; // this can be the servername
  1688.         $audience_claim = "Babu";
  1689.         $issuedat_claim = time(); // issued at
  1690.         $notbefore_claim = $issuedat_claim + 10; //not before in seconds
  1691.         $expire_claim = $issuedat_claim + 60; // expire time in seconds
  1692.         $token = array(
  1693.             "iss" => $issuer_claim,
  1694.             "aud" => $audience_claim,
  1695.             "iat" => $issuedat_claim,
  1696.             "nbf" => $notbefore_claim,
  1697.             "exp" => $expire_claim,
  1698.             "data" => array(
  1699.                 "id" => $id,
  1700.                 "firstname" => $firstname,
  1701.                 "lastname" => $lastname,
  1702.                 "email" => $email
  1703.         ));
  1705.         $jwt = JWT::encode($token, $secret_key, 'HS256');
  1706.         // echo json_encode(
  1707.         //     array(
  1708.         //         "message" => "Successful login.",
  1709.         //         "jwt" => $jwt,
  1710.         //         "email" => $email,
  1711.         //         "expireAt" => $expire_claim
  1712.         //     )); die;
  1714.         $data = array(
  1715.             "message" => "Successful login.",
  1716.             "jwt" => $jwt,
  1717.             "email" => $email,
  1718.             "expireAt" => $expire_claim
  1719.         );
  1720.         return $this->json(["success" => true, "data" => $data]);
  1721.     }
  1723.     /**
  1724.      * @Route("/api/verifyJwtToken")
  1725.      */
  1726.     public function verifyJwtTokenAction()
  1727.     {
  1728.         $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  1729.         $jwt = null;
  1730.         
  1731.         $data = json_decode(file_get_contents("php://input"));
  1733.         $authHeader = $_SERVER['HTTP_AUTHORIZATION'];
  1735.         $arr = explode(" ", $authHeader);
  1737.         $jwt = $arr[1];
  1739.         if($jwt){
  1741.             try {
  1742.                 $decoded = JWT::decode($jwt, new Key($secret_key, 'HS256'));
  1744.                 // Access is granted. Add code of the operation here 
  1746.                 $data = array(
  1747.                     "message" => "Access granted"
  1748.                 );
  1749.                 return $this->json(["success" => true, "data" => $data]);
  1751.             }catch (Exception $e){
  1753.                 $data = array(
  1754.                     "message" => "Access denied"
  1755.                 );
  1756.                 return $this->json(["success" => true, "data" => $data]);
  1757.             }
  1759.         }
  1760.     }
  1762.     /*------------------------------ End of JWT Related APIs -------------------------*/
  1764.     /*---------------------------------- Personal Statement Related APIs ----------------------------*/
  1766.     /**
  1767.      * @Route("personalitystatement/getperstmtlist", methods={"POST"})
  1768.      */
  1769.     public function getperstmtlistAction(Request $request)
  1770.     {
  1771.         $api_log_info = "API:Get Personality Statements list with or without params - ".date("YmdHis")." ".time();
  1772.         $log_data = "Started - ".$api_log_info;
  1773.         SELF::createApiLog($log_data);
  1775.         $message = SELF::verifyauthToken($api_log_info);
  1777.         $log_data = $api_log_info." | message:".json_encode($message);
  1778.         SELF::createApiLog($log_data);
  1780.         // $data[] = ['message'=>$message];
  1781.         $data = [];
  1782.         if($message == "No data found")
  1783.         {
  1784.             $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  1785.             // print_r($reqparams); die;
  1786.             // print_r($request->get->all());
  1788.             $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  1789.             SELF::createApiLog($log_data);
  1791.             $title = (isset($reqparams['title']))?$reqparams['title']:'';
  1792.             $gender = (isset($reqparams['gender']))?$reqparams['gender']:'';
  1793.             $standout_fitin = (isset($reqparams['standout_fitin']))?$reqparams['standout_fitin']:'';
  1794.             $describe_yourself = (isset($reqparams['describe_yourself']))?$reqparams['describe_yourself']:'';
  1795.             $occasion = (isset($reqparams['occasion']))?$reqparams['occasion']:'';
  1796.             $priceband = (isset($reqparams['priceband']))?$reqparams['priceband']:'';
  1797.             $blank1 = (isset($reqparams['blank1']))?$reqparams['blank1']:'';
  1798.             $blank2 = (isset($reqparams['blank2']))?$reqparams['blank2']:'';
  1800.             $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);
  1801.             SELF::createApiLog($log_data);
  1803.             $perstmtList = DataObject\Personalitystatements::getList();
  1805.             if($title || $blank1 || $blank2 || $priceband || $gender || $standout_fitin || $describe_yourself || $occasion)
  1806.             {
  1807.                 $whr_condition = " personality_statement != '' "; $whr_condition_array = [];
  1808.                 if($title){
  1809.                     $whr_condition .= " AND personality_statement = '".$title."'";
  1810.                 }
  1811.                 if($priceband){
  1812.                     $whr_condition .= " AND priceband = '".$priceband."'";
  1813.                 }
  1814.                 if($blank1){
  1815.                     $whr_condition .= " AND blank1 = '".$blank1."'";
  1816.                 }
  1817.                 if($blank2){
  1818.                     $whr_condition .= " AND blank2 = '".$blank2."'";
  1819.                 }
  1820.                 if($gender){
  1821.                     $whr_condition .= " AND gender LIKE '%,".$gender.",%'";
  1822.                 }
  1823.                 if($standout_fitin){
  1824.                     $whr_condition .= " AND standout_fitin LIKE '%,".$standout_fitin.",%'";
  1825.                 }
  1826.                 if($describe_yourself){
  1827.                     $whr_condition .= " AND describe_yourself LIKE '%,".$describe_yourself.",%'";
  1828.                 }
  1829.                 if($occasion){
  1830.                     $whr_condition .= " AND occasion LIKE '%,".$occasion.",%'";
  1831.                 }
  1833.                 // echo "whr_condition:".$whr_condition;
  1834.                 // echo "whr_condition_array:";
  1835.                 // print_r($whr_condition_array); die;
  1837.                 $log_data = $api_log_info." | whr_condition:".json_encode($whr_condition);
  1838.                 SELF::createApiLog($log_data);
  1840.                 $perstmtList->setCondition($whr_condition);
  1841.                 
  1842.             }
  1843.             
  1844.             $perstmtList->load();
  1846.             $log_data = $api_log_info." | perstmtList count:".json_encode(count($perstmtList));
  1847.             SELF::createApiLog($log_data);
  1849.             foreach ($perstmtList as $key => $perstmtObj) {
  1851.                 $log_data = $api_log_info." | perstmtObj:".json_encode($perstmtObj);
  1852.                 SELF::createApiLog($log_data);
  1854.                 $data[] = array(
  1855.                     "id" => $perstmtObj->getId(),
  1856.                     "personality_statement" => $perstmtObj->getpersonality_statement(),
  1857.                     "standout_fitin" => $perstmtObj->getstandout_fitin(),
  1858.                     "describe_yourself" => $perstmtObj->getdescribe_yourself(),
  1859.                     "occasion" => $perstmtObj->getoccasion(),
  1860.                     "priceband" => $perstmtObj->getpriceband(),
  1861.                     "blank2" => $perstmtObj->getblank2(),
  1862.                     "blank1" => $perstmtObj->getblank1());
  1864.                 $log_data = $api_log_info." | data:".json_encode($data);
  1865.                 SELF::createApiLog($log_data);
  1866.             }
  1867.         } else $data[] = ['message'=>$message];
  1868.         $data = (empty($data))?$message:$data;
  1869.         // return $slotsList;
  1870.         $return_data = ["success" => true, "data" => $data];
  1871.         $log_data = $api_log_info." | return_data:".json_encode($return_data);
  1872.         SELF::createApiLog($log_data);
  1873.         return $this->json(["success" => true, "data" => $data]);
  1874.     }
  1876.     /**
  1877.      * @Route("personalitystatement/perstmtlist")
  1878.      */
  1879.     public function perstmtlistAction()
  1880.     {
  1881.         $api_log_info = "API:Get All Personality Statements - ".date("YmdHis")." ".time();
  1882.         $log_data = "Started - ".$api_log_info;
  1883.         SELF::createApiLog($log_data);
  1885.         $message = SELF::verifyauthToken($api_log_info);
  1886.         $log_data = $api_log_info." | message:".json_encode($message);
  1887.         SELF::createApiLog($log_data);
  1889.         if($message == "No data found")
  1890.         {
  1891.             $perstmtList = DataObject\Personalitystatements::getList();
  1892.             $perstmtList->load();
  1894.             $log_data = $api_log_info." | perstmtList count:".json_encode(count($perstmtList));
  1895.             SELF::createApiLog($log_data);
  1897.             if(count($perstmtList)>0){
  1898.                 foreach ($perstmtList as $key => $perstmtObj) {
  1900.                     $log_data = $api_log_info." | perstmtObj:".json_encode($perstmtObj);
  1901.                     SELF::createApiLog($log_data);
  1903.                     $data[] = array(
  1904.                         "id" => $perstmtObj->getId(),
  1905.                         "personality_statement" => $perstmtObj->getpersonality_statement(),
  1906.                         "standout_fitin" => $perstmtObj->getstandout_fitin(),
  1907.                         "describe_yourself" => $perstmtObj->getdescribe_yourself(),
  1908.                         "occasion" => $perstmtObj->getoccasion(),
  1909.                         "priceband" => $perstmtObj->getpriceband(),
  1910.                         "blank2" => $perstmtObj->getblank2(),
  1911.                         "blank1" => $perstmtObj->getblank1());
  1913.                     $log_data = $api_log_info." | data:".json_encode($data);
  1914.                     SELF::createApiLog($log_data);
  1915.                 }
  1916.             } else $data[] = ['message'=>$message];
  1917.         } else $data[] = ['message'=>$message];
  1919.         $return_data = ["success" => true, "data" => $data];
  1920.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  1921.         SELF::createApiLog($log_data);
  1923.         return $this->json(["success" => true, "data" => $data]);
  1924.     }
  1926.     /**
  1927.      * @Route("personalitystatement/perstmtinfo/{id}")
  1928.      */
  1929.     public function perstmtinfoAction($id)
  1930.     {
  1931.         $api_log_info = "API:Get Personality Statement Info by ID - ".date("YmdHis")." ".time();
  1932.         $log_data = "Started - ".$api_log_info;
  1933.         SELF::createApiLog($log_data);
  1935.         $log_data = $api_log_info." | ID:".$id;
  1936.         SELF::createApiLog($log_data);
  1938.         $message = SELF::verifyauthToken($api_log_info);
  1940.         $log_data = $api_log_info." | message:".json_encode($message);
  1941.         SELF::createApiLog($log_data);
  1943.         if($message == "No data found")
  1944.         {
  1945.             $perstmtObject = DataObject\Personalitystatements::getById($id);
  1947.             $log_data = $api_log_info." | perstmtObject:".json_encode($perstmtObject);
  1948.             SELF::createApiLog($log_data);
  1950.             if(!empty($perstmtObject) && $perstmtObject->getpersonality_statement()){
  1951.                 $log_data = $api_log_info." | perstmtObject getpersonality_statement:".json_encode($perstmtObject->getpersonality_statement());
  1952.                 SELF::createApiLog($log_data);
  1954.                 $data[] = array(
  1955.                     "id" => $perstmtObject->getId(),
  1956.                     "personality_statement" => $perstmtObject->getpersonality_statement(),
  1957.                     "standout_fitin" => $perstmtObject->getstandout_fitin(),
  1958.                     "describe_yourself" => $perstmtObject->getdescribe_yourself(),
  1959.                     "occasion" => $perstmtObject->getoccasion(),
  1960.                     "priceband" => $perstmtObject->getpriceband(),
  1961.                     "blank2" => $perstmtObject->getblank2(),
  1962.                     "blank1" => $perstmtObject->getblank1());
  1964.                 $log_data = $api_log_info." | data:".json_encode($data);
  1965.                 SELF::createApiLog($log_data);
  1967.             } else $data[] = ['message'=>$message];
  1968.         } else $data[] = ['message'=>$message];
  1970.         $returnData = ["success" => true, "data" => $data];
  1972.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  1973.         SELF::createApiLog($log_data);
  1975.         return $this->json(["success" => true, "data" => $data]);
  1976.     }
  1978.     /*------------------------------ End of Personal Statement Related APIs -------------------------*/
  1980.     /*---------------------------------- Shipping Rate / Delivery Fee Related APIs ----------------------------*/
  1982.     /**
  1983.      * @Route("api/shippingchargeslist")
  1984.      */
  1985.     public function shippingchargeslistAction()
  1986.     {
  1987.         $api_log_info = "API:Get Shipping Charges List - ".date("YmdHis")." ".time();
  1988.         $log_data = "Started - ".$api_log_info;
  1989.         SELF::createApiLog($log_data);
  1991.         $message = SELF::verifyauthToken($api_log_info);
  1993.         $log_data = $api_log_info." | message:".json_encode($message);
  1994.         SELF::createApiLog($log_data);
  1996.         if($message == "No data found")
  1997.         {
  1998.             $shippingchargesList = DataObject\Shippingcharges::getList();
  1999.             $shippingchargesList->load();
  2001.             $log_data = $api_log_info." | shippingchargesList count:".json_encode(count($shippingchargesList));
  2002.             SELF::createApiLog($log_data);
  2004.             if(count($shippingchargesList)>0){
  2005.                 foreach ($shippingchargesList as $key => $shippingchargeObj) {
  2007.                     $log_data = $api_log_info." | shippingchargeObj:".json_encode($shippingchargeObj);
  2008.                     SELF::createApiLog($log_data);
  2010.                     $data[] = array(
  2011.                         "id" => $shippingchargeObj->getId(),
  2012.                         "minimum_order" => $shippingchargeObj->getminimum_order(),
  2013.                         "maximum_order" => $shippingchargeObj->getmaximum_order(),
  2014.                         "discount_percentage" => $shippingchargeObj->getdiscount_percentage(),
  2015.                         "location" => $shippingchargeObj->getlocationId()->getLocation_name());
  2017.                     $log_data = $api_log_info." | data:".json_encode($data);
  2018.                     SELF::createApiLog($log_data);
  2019.                 }
  2020.             } else $data[] = ['message'=>$message];
  2021.         } else $data[] = ['message'=>$message];
  2023.         $returnData = ["success" => true, "data" => $data];
  2025.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  2026.         SELF::createApiLog($log_data);
  2028.         return $this->json(["success" => true, "data" => $data]);
  2029.     }
  2031.     /**
  2032.      * @Route("api/shippingrateslist", methods={"POST"})
  2033.      */
  2034.     public function shippingrateslistAction()
  2035.     {
  2037.         $api_log_info = "API:Shipping Rate / Delivery Fee List - ".date("YmdHis")." ".time();
  2038.         $log_data = "Started - ".$api_log_info;
  2039.         SELF::createApiLog($log_data);
  2041.         $message = SELF::verifyauthToken($api_log_info);
  2042.         $log_data = $api_log_info." | message:".json_encode($message);
  2043.         SELF::createApiLog($log_data);
  2045.         if($message == "No data found")
  2046.         {
  2047.             $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2048.             $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2049.             SELF::createApiLog($log_data);
  2051.             $weight_cart = (isset($reqparams['weight_cart']))?$reqparams['weight_cart']:'';
  2052.             $req_weight_cart = $weight_cart;
  2053.             $locationCode = (isset($reqparams['locationCode']))?$reqparams['locationCode']:'';
  2054.             $shipping_state_code = (isset($reqparams['shipping_state_code']))?$reqparams['shipping_state_code']:'';
  2055.             $pincode = (isset($reqparams['pincode']))?$reqparams['pincode']:'';
  2056.             $order_amount = (isset($reqparams['order_amount']))?$reqparams['order_amount']:'';
  2058.             $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);
  2059.             SELF::createApiLog($log_data);
  2061.             if($weight_cart == '' || $locationCode == '' || $shipping_state_code == '' || $pincode == '' || $order_amount == '')
  2062.             {
  2063.                 $data = "weight_cart, locationCode, shipping_state_code, pincode and order_amount are mandatory!";
  2065.                 $log_data = $api_log_info." | data:".json_encode($data);
  2066.                 SELF::createApiLog($log_data);
  2067.             } else {
  2068.                 /*------ Get Shipping Rate Card Class data --------*/
  2069.                 $dbConnection = \Pimcore\Db::get();
  2070.                 $shippingRatecardClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Shippingratecards' ");
  2071.                 $shippingRatecardObject = "object_".$shippingRatecardClassId;
  2073.                 $log_data = $api_log_info." | shippingRatecardObject:".json_encode($shippingRatecardObject);
  2074.                 SELF::createApiLog($log_data);
  2076.                 // $shippingRatecardId = $dbConnection->fetchOne(" select * from object_12 order by abs(no_of_kgs - ".$weight_cart.")");
  2077.                 $shippingRatecardId = $dbConnection->fetchOne(" select * from ".$shippingRatecardObject." order by abs(no_of_kgs - ".$weight_cart.")");
  2079.                 $log_data = $api_log_info." | shippingRatecardId:".json_encode($shippingRatecardId);
  2080.                 SELF::createApiLog($log_data);
  2081.                 /*----- End of ---------*/
  2082.                 /*---- Check Location by Location Code ---------*/
  2083.                 $locData = DataObject\Locations::getBylocation_code($locationCode, 1);
  2084.                 $pincodeInfo = DataObject\ItcAddPincode::getBypincode($pincode, 1);
  2085.                 $stateInfo = DataObject\States::getBystate_code($shipping_state_code, 1);
  2086.                 $shipChargeInfo = DataObject\Shippingratecards::getById($shippingRatecardId); //DataObject\Shippingratecards::getByno_of_kgs($weight_cart, 1);
  2088.                 $log_data = $api_log_info." | locData:".json_encode($locData)." | pincodeInfo:".json_encode($pincodeInfo)." | stateInfo:".json_encode($stateInfo)." | shipChargeInfo:".json_encode($shipChargeInfo);
  2089.                 SELF::createApiLog($log_data);
  2091.                 if(empty($locData) || empty($locData->getId()) || empty($pincodeInfo) || empty($pincodeInfo->getId()) || empty($shipChargeInfo) || empty($shipChargeInfo->getId()))// || empty($stateInfo) || empty($stateInfo->getId()) 
  2092.                 {
  2093.                     if(empty($locData) || empty($locData->getId()))
  2094.                         $message = "Location is not exited, please try with valid location code!";
  2095.                     
  2096.                     if(empty($pincodeInfo) || empty($pincodeInfo->getId()))
  2097.                         $message = "Pincode is not exited, please try with valid pincode!";
  2098.                 
  2099.                     if(empty($shipChargeInfo) || empty($shipChargeInfo->getId()))
  2100.                         $message = "Shipping Charge is not exited for ".$weight_cart." Kgs, please try with valid No of Kgs!";
  2102.                     $data[] = ['message'=>$message];
  2103.                     
  2104.                     $log_data = $api_log_info." | data:".json_encode($data);
  2105.                     SELF::createApiLog($log_data);
  2107.                 } else {
  2108.                     $locationId = $locData->getId();
  2109.                     $locationName = $locData->getLocation_name();
  2110.                     $message = SELF::verifyauthToken();
  2111.                     
  2112.                     $log_data = $api_log_info." | locationId:".json_encode($locationId)." | locationName:".json_encode($locationName)." | message:".json_encode($message);
  2113.                     SELF::createApiLog($log_data);
  2115.                     if($message == "No data found")
  2116.                     {
  2117.                         /*------ Check Location is Up Country or not --------*/
  2118.                         $Is_location_up_country = (strpos(strtolower($locationName),"up country"))?1:0;
  2119.                     
  2120.                         $log_data = $api_log_info." | Is_location_up_country:".json_encode($Is_location_up_country);
  2121.                         SELF::createApiLog($log_data);
  2122.         
  2123.                         /*------ Get Settings Class, Object and ID data --------*/
  2124.                         $dbConnection = \Pimcore\Db::get();
  2125.                         $settingsClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Settings' ");
  2126.                         $settingsObject = "object_".$settingsClassId;
  2127.                     
  2128.                         $log_data = $api_log_info." | settingsObject:".json_encode($settingsObject);
  2129.                         SELF::createApiLog($log_data);
  2131.                         $settingsObjectId = $dbConnection->fetchOne("select * from ".$settingsObject." order by oo_id asc");
  2132.                     
  2133.                         $log_data = $api_log_info." | settingsObjectId:".json_encode($settingsObjectId);
  2134.                         SELF::createApiLog($log_data);
  2136.                         /*---- Get Settings Data ---------*/
  2137.                         $settingsData = DataObject\Settings::getById($settingsObjectId);
  2139.                         $log_data = $api_log_info." | settingsData:".json_encode($settingsData);
  2140.                         SELF::createApiLog($log_data);
  2142.                         // echo '<pre>settingsObjectId:'.$settingsObjectId;
  2143.                         // echo '<pre>settingsData:';
  2144.                         // print_r($settingsData->getis_deliveryfee_config_applicable());
  2146.                         $is_shippingapplicable=$pincodeInfo->getis_shipping_applicable();
  2147.                     
  2148.                         $log_data = $api_log_info." | is_shippingapplicable:".json_encode($is_shippingapplicable);
  2149.                         SELF::createApiLog($log_data);
  2151.                         $pincode_data['pincode'] = $pincodeInfo->getpincode();
  2152.                         $pincode_data['state'] = $pincodeInfo->getstate();
  2153.                         $pincode_data['is_shipping_applicable'] = $pincodeInfo->getis_shipping_applicable();
  2154.                         $pincode_data['deliverytype'] = $pincodeInfo->getdeliverytype();
  2155.                     
  2156.                         $log_data = $api_log_info." | pincode_data:".json_encode($pincode_data);
  2157.                         SELF::createApiLog($log_data);
  2158.                         /*----------- End of Check Is Shipping Applicable or Not based on Pincode from Pincode Table ----------*/
  2160.                         /*------------- Get Shipping Discount Based on Is Shipping Applicable Fee Shipping Rule(Shipping Charges) Table------------*/
  2161.                         $final_cost=0; $rate_discount_perc=0; $cur_noofkgs = $shipChargeInfo->getno_of_kgs();
  2162.                         $zone_name=(!empty($stateInfo) && $stateInfo->getZoneId())?$stateInfo->getZoneId()->getzone_name():'';
  2163.                     
  2164.                         $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);
  2165.                         SELF::createApiLog($log_data);
  2166.                         /*----------- End of Get Zone based on State Code from States Table ----------*/
  2168.                         /*------------- Get Shipping rate data based on state code and weight cart ------------*/
  2169.                         $shippingratesList = DataObject\Shippingratecards::getList();
  2170.                         if ($shippingratesList->getClass()->getFieldDefinition('no_of_kgs')->isFilterable()) {
  2171.                             $shippingratesList->filterByno_of_kgs($cur_noofkgs, '=');
  2172.                         }
  2173.                         $shippingratesList->setOrderKey("no_of_kgs");
  2174.                         $shippingratesList->setOrder("desc");
  2175.                         $shippingratesList->load();
  2176.                     
  2177.                         $log_data = $api_log_info." | shippingratesList count:".json_encode(count($shippingratesList));
  2178.                         SELF::createApiLog($log_data);
  2180.                         if(count($shippingratesList)>0){
  2181.                             $ii=0;
  2182.                             foreach ($shippingratesList as $key => $shippingrateObj) {
  2183.                     
  2184.                                 $log_data = $api_log_info." | key:".json_encode($key)." | shippingrateObj:".json_encode($shippingrateObj);
  2185.                                 SELF::createApiLog($log_data);
  2187.                                 $data_key = $data_val = $data_key2 = $data_val2 = '';
  2188.                                 $data[] = array(
  2189.                                     "id" => $shippingrateObj->getId(),
  2190.                                     "no_of_kgs" => $req_weight_cart,
  2191.                                     "inter_region_cost" => $shippingrateObj->getintera_region_cost(),
  2192.                                     "j_k_cost" => $shippingrateObj->getj_and_k_cost(),
  2193.                                     "ne_and_andaman_cost" => $shippingrateObj->getne_and_andaman()
  2194.                                 );
  2195.                     
  2196.                                 $log_data = $api_log_info." | Initialise data_key, data_val, data_key2 and data_val2 values as null | data:".json_encode($data);
  2197.                                 SELF::createApiLog($log_data);
  2198.                                 
  2199.                                 if($is_shippingapplicable == 'Yes')
  2200.                                 {
  2201.                                     if($zone_name == 'J and K')
  2202.                                     {
  2203.                                         $final_cost = $shippingrateObj->getj_and_k_cost();
  2204.                                     }
  2205.                                     else if($zone_name == 'NE and Andaman')
  2206.                                     {
  2207.                                         $final_cost = $shippingrateObj->getne_and_andaman();  
  2208.                                     }
  2209.                                     else 
  2210.                                     {
  2211.                                         $final_cost = $shippingrateObj->getintera_region_cost();
  2212.                                     }
  2213.                                 }
  2215.                                 $log_data = $api_log_info." | zone_name:".json_encode($zone_name)." | final_cost:".json_encode($final_cost);
  2216.                                 SELF::createApiLog($log_data);
  2218.                                 $data[$ii]['locationCode'] = $locationCode;
  2219.                                 $data[$ii]['pincode'] = $pincode_data;
  2220.                     
  2221.                                 $log_data = $api_log_info." | ii:".json_encode($ii)." | data:".json_encode($data);
  2222.                                 SELF::createApiLog($log_data);
  2223.                                 
  2224.                             }
  2225.                             $minimum_order = $maximum_order = $discount_percentage = 0; $shippingRules = [];
  2226.                     
  2227.                             $log_data = $api_log_info." | Initialise minimum_order, maximum_order, discount_percentage and shippingRules values as null | is_shippingapplicable:".json_encode($is_shippingapplicable);
  2228.                             SELF::createApiLog($log_data);
  2229.                             
  2230.                             if($is_shippingapplicable == 'Yes')//&& $loc_code_error == ''
  2231.                             {
  2232.                                 $shippingchargesList = DataObject\Shippingcharges::getList();
  2233.                                 $shippingchargesList->setCondition("locationId__Id = ? AND (minimum_order <= ? AND maximum_order >= ?)",[$locationId, $order_amount, $order_amount]);
  2234.                                 $shippingchargesList->load();
  2235.                     
  2236.                                 $log_data = $api_log_info." | shippingchargesList count:".json_encode(count($shippingchargesList));
  2237.                                 SELF::createApiLog($log_data);
  2239.                                 if(count($shippingchargesList)>0)
  2240.                                 {
  2241.                                     foreach($shippingchargesList as $shippingchargeObj)
  2242.                                     {
  2243.                                         $log_data = $api_log_info." | shippingchargeObj:".json_encode($shippingchargeObj);
  2244.                                         SELF::createApiLog($log_data);
  2246.                                         $minimum_order = $shippingchargeObj->getminimum_order();
  2247.                                         $maximum_order = $shippingchargeObj->getmaximum_order();
  2248.                                         $discount_percentage = $shippingchargeObj->getdiscount_percentage();
  2250.                                         $log_data = $api_log_info." | minimum_order:".json_encode($minimum_order)." | maximum_order:".json_encode($maximum_order)." | discount_percentage:".json_encode($discount_percentage);
  2251.                                         SELF::createApiLog($log_data);
  2253.                                         $shippingRules['shippingRuleId'] = $shippingchargeObj->getId();
  2254.                                         $shippingRules['minimum_order_amount'] = $minimum_order;
  2255.                                         $shippingRules['maximum_order_amount'] = $maximum_order;
  2256.                                         $shippingRules['discount_percentage'] = $discount_percentage;
  2258.                                         $log_data = $api_log_info." | shippingRules:".json_encode($shippingRules);
  2259.                                         SELF::createApiLog($log_data);
  2260.                                     }
  2261.                                     $data[$ii]['shippingRules'] = $shippingRules;
  2263.                                     $log_data = $api_log_info." | ii:".json_encode($ii)." | data:".json_encode($data);
  2264.                                     SELF::createApiLog($log_data);
  2266.                                     $rate_discount_perc = ($minimum_order <= $order_amount && $maximum_order >= $order_amount)?$discount_percentage:0;
  2268.                                     $final_cost = $final_cost - (($final_cost*$rate_discount_perc)/100);
  2270.                                     $log_data = $api_log_info." | rate_discount_perc:".json_encode($rate_discount_perc)." | final_cost:".json_encode($final_cost);
  2271.                                     SELF::createApiLog($log_data);
  2272.                                 }
  2273.                                 
  2274.                             }
  2276.                             /*----------- Delivery Fee Configuration Condition --------------*/
  2278.                             $log_data = $api_log_info." | settingsData getis_deliveryfee_config_applicable:".json_encode($settingsData->getis_deliveryfee_config_applicable());
  2279.                             SELF::createApiLog($log_data);
  2281.                             if($settingsData->getis_deliveryfee_config_applicable() == 'Yes')
  2282.                             {
  2283.                                 $stg_deliveryfee_config = $settingsData->getdeliveryfee_config();
  2284.                                 $stg_deliveryfee_config_location_lessthan_charge = $settingsData->getdeliveryfee_config_location_lessthan_charge();
  2285.                                 $stg_deliveryfee_config_location_greaterthanequal_charge = $settingsData->getdeliveryfee_config_location_greaterthanequal_charge();
  2286.                                 $stg_deliveryfee_config_upcountry_lessthan_charge = $settingsData->getdeliveryfee_config_upcountry_lessthan_charge();
  2287.                                 $stg_deliveryfee_config_upcountry_greaterthanequal_charge = $settingsData->getdeliveryfee_config_upcountry_greaterthanequal_charge();
  2289.                                 $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);
  2290.                                 SELF::createApiLog($log_data);
  2292.                                 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;
  2293.                                 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;
  2294.                                 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;
  2295.                                 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;
  2296.                                 else $final_cost = $final_cost;
  2298.                                 $log_data = $api_log_info." | final_cost:".json_encode($final_cost);
  2299.                                 SELF::createApiLog($log_data);
  2300.                             }
  2301.                             
  2302.                             $data[$ii]['final_cost'] = $final_cost;
  2304.                             // 2 hours fast delivery code
  2305.                             if($is_shippingapplicable == 'Yes')
  2306.                             {
  2307.                                 $fdsett = DataObject\FastDeliverySetting::getList();
  2308.                                 $fdsett->setCondition("locationId__Id = ?",[$locationId]);
  2309.                                 $fdsett->load();
  2311.                                 $data[$ii]['platform_fee'] = 0;
  2312.                                 $data[$ii]['low_order_fee'] = 0;
  2314.                                 if(count($fdsett->getData()) > 0) {
  2315.                                     $fdsett = $fdsett->getData()[0];
  2317.                                     $data[$ii]['platform_fee'] = $fdsett->getplatFormFee();
  2318.                                     $cartValue = $fdsett->getcartValue();
  2320.                                     if($cartValue > $order_amount) {
  2321.                                         $data[$ii]['low_order_fee'] = $fdsett->getminLowOrderFee();
  2322.                                     } else {
  2323.                                         $data[$ii]['low_order_fee'] = $fdsett->getlowOrderFee();
  2324.                                     }
  2325.                                 }
  2326.                             }
  2328.                             $log_data = $api_log_info." | final_cost:".json_encode($final_cost)." | ii:".json_encode($ii)." | data:".json_encode($data);
  2329.                             SELF::createApiLog($log_data);
  2331.                         } else $data[] = ['message'=>$message];
  2332.                         /*----------- End of Get Shipping rate data based on state code and weight cart ----------*/
  2334.                     } else $data[] = ['message'=>$message];
  2335.                 }
  2336.             }
  2337.         } else $data[] = ['message'=>$message];
  2339.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2340.         SELF::createApiLog($log_data);
  2342.         return $this->json(["success" => true, "data" => $data]);
  2343.     }
  2345.     /*------------------------------ End of Shipping Rate / Delivery Fee Related APIs -------------------------*/
  2347.     /*---------------------------------- Factory Related APIs ----------------------------*/
  2349.     /**
  2350.      * @Route("/factory/getfactories")
  2351.      */
  2352.     public function getfactories()
  2353.     {
  2354.         $api_log_info = "API:Get All Factories - ".date("YmdHis")." ".time();
  2355.         $log_data = "Started - ".$api_log_info;
  2356.         SELF::createApiLog($log_data);
  2358.         $message = SELF::verifyauthToken($api_log_info);
  2360.         $log_data = $api_log_info." | message:".json_encode($message);
  2361.         SELF::createApiLog($log_data);
  2363.         if($message == "No data found")
  2364.         {
  2365.             $factoriesList = DataObject\Factories::getList();
  2366.             $factoriesList->load();
  2368.             $log_data = $api_log_info." | factoriesList count:".json_encode(count($factoriesList));
  2369.             SELF::createApiLog($log_data);
  2371.             if(count($factoriesList) > 0){
  2372.                 foreach ($factoriesList as $key => $blog) {
  2374.                     $log_data = $api_log_info." | key:".json_encode($key)." | blog:".json_encode($blog);
  2375.                     SELF::createApiLog($log_data);
  2377.                     $bestbefore_date = '';
  2379.                     if($blog->getbestbefore()){
  2380.                         $bestbefore_dt = date("m/d/y", strtotime($blog->getbestbefore()));
  2381.                         $bestbefore_date = Carbon::createFromFormat('m/d/y', $bestbefore_dt);
  2383.                         $log_data = $api_log_info." | bestbefore_dt:".json_encode($bestbefore_dt)." | bestbefore_date:".json_encode($bestbefore_date);
  2384.                         SELF::createApiLog($log_data);
  2385.                     }
  2386.                     $data[] = array(
  2387.                         "code" => $blog->getcode(),
  2388.                         "name" => $blog->getname(),
  2389.                         "address" => $blog->getaddress(),
  2390.                         "street" => $blog->getstreet(),
  2391.                         "landmark" => $blog->getlandmark(),
  2392.                         "city" => $blog->getcity(),
  2393.                         "state" => $blog->getstate(),
  2394.                         "country" => $blog->getcountry(),
  2395.                         "pincode" => $blog->getpincode(),
  2396.                         "bestbefore" => $bestbefore_date);
  2398.                     $log_data = $api_log_info." | data:".json_encode($data);
  2399.                     SELF::createApiLog($log_data);
  2400.                 }
  2401.             } else $data[] = ['message'=>$message];
  2402.         } else $data[] = ['message'=>$message];
  2404.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2405.         SELF::createApiLog($log_data);
  2406.         
  2407.         return $this->json(["success" => true, "data" => $data]);
  2408.     }
  2410.     /**
  2411.      * @Route("api/getfactorydata", methods={"POST"})
  2412.      */
  2413.     public function getfactorydataAction(Request $request)
  2414.     {
  2415.         $api_log_info = "API:Get factory Info by Code - ".date("YmdHis")." ".time();
  2416.         $log_data = "Started - ".$api_log_info;
  2417.         SELF::createApiLog($log_data);
  2419.         $factorycode = $request->get('factorycode');
  2421.         $log_data = $api_log_info." | factorycode:".json_encode($factorycode);
  2422.         SELF::createApiLog($log_data);
  2424.         if($factorycode == "")
  2425.         {
  2426.             $data = "Factory Code is mandatory!";
  2428.             $log_data = $api_log_info." | data:".json_encode($data);
  2429.             SELF::createApiLog($log_data);
  2430.         } else 
  2431.         {
  2432.             $data = SELF::verifyauthToken($api_log_info);
  2434.             $log_data = $api_log_info." | data:".json_encode($data);
  2435.             SELF::createApiLog($log_data);
  2437.             if($data == "No data found")
  2438.             {
  2439.                 /*---- Check Factory by Code ---------*/
  2440.                 $factoryData = DataObject\Factories::getBycode($factorycode, 1);
  2442.                 $log_data = $api_log_info." | factoryData:".json_encode($factoryData);
  2443.                 SELF::createApiLog($log_data);
  2445.                 if(!empty($factoryData) && $factoryData->getId()){
  2446.                         
  2447.                     $log_data = $api_log_info." | factoryData getId:".json_encode($factoryData->getId());
  2448.                     SELF::createApiLog($log_data);
  2450.                     $data = array(
  2451.                         "id" => $factoryData->getId(),
  2452.                         "code" => $factoryData->getCode(),
  2453.                         "name" => $factoryData->getname(),
  2454.                         "address" => $factoryData->getaddress(),
  2455.                         "street" => $factoryData->getstreet(),
  2456.                         "landmark" => $factoryData->getlandmark(),
  2457.                         "city" => $factoryData->getcity(),
  2458.                         "state" => $factoryData->getstate(),
  2459.                         "country" => $factoryData->getcountry(),
  2460.                         "pincode" => $factoryData->getpincode(),
  2461.                         "bestbefore" => $factoryData->getbestbefore());
  2463.                     $log_data = $api_log_info." | data:".json_encode($data);
  2464.                     SELF::createApiLog($log_data);
  2465.                 } else {
  2466.                     $data = "No data found!";
  2467.                     $log_data = $api_log_info." | data:".json_encode($data);
  2468.                     SELF::createApiLog($log_data);
  2469.                 }
  2470.             }
  2471.         }
  2473.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2474.         SELF::createApiLog($log_data);
  2476.         return $this->json(["success" => true, "data" => $data]);
  2477.     }
  2479.     /**
  2480.      * @Route("api/getfactoriesdata", methods={"POST"})
  2481.      */
  2482.     public function getfactoriesdataAction(Request $request)
  2483.     {
  2484.         $api_log_info = "API:Get Factories list by multiple Factory codes - ".date("YmdHis")." ".time();
  2485.         $log_data = "Started - ".$api_log_info;
  2486.         SELF::createApiLog($log_data);
  2488.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2490.         $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2491.         SELF::createApiLog($log_data);
  2493.         $factorycodes = (isset($reqparams['factorycodes']))?$reqparams['factorycodes']:'';
  2495.         $log_data = $api_log_info." | factorycodes:".json_encode($factorycodes);
  2496.         SELF::createApiLog($log_data);
  2498.         // $factorycode = $request->get('factorycode');
  2500.         if($factorycodes == "")
  2501.         {
  2502.             $data = "Factory Code(s) is(are) mandatory!";
  2504.             $log_data = $api_log_info." | data:".json_encode($data);
  2505.             SELF::createApiLog($log_data);
  2506.         } else 
  2507.         {
  2508.             $data = SELF::verifyauthToken($api_log_info);
  2510.             $log_data = $api_log_info." | data:".json_encode($data);
  2511.             SELF::createApiLog($log_data);
  2513.             if($data == "No data found")
  2514.             {
  2515.                 /*---- Check Factory by Code ---------*/
  2516.                 $factoriesData = new DataObject\Factories\Listing();
  2517.                 $factoriesData->setCondition("code IN (?)", [$factorycodes]);
  2518.                 $factoriesData->load();
  2520.                 $log_data = $api_log_info." | factoriesData count:".json_encode(count($factoriesData));
  2521.                 SELF::createApiLog($log_data);
  2523.                 if(!empty($factoriesData) && count($factoriesData)>0){
  2524.                     $data = [];
  2525.                     foreach($factoriesData as $factoryData){
  2527.                         $log_data = $api_log_info." | factoryData:".json_encode($factoryData);
  2528.                         SELF::createApiLog($log_data);
  2530.                         $curdata = array(
  2531.                             "id" => $factoryData->getId(),
  2532.                             "code" => $factoryData->getCode(),
  2533.                             "name" => $factoryData->getname(),
  2534.                             "address" => $factoryData->getaddress(),
  2535.                             "street" => $factoryData->getstreet(),
  2536.                             "landmark" => $factoryData->getlandmark(),
  2537.                             "city" => $factoryData->getcity(),
  2538.                             "state" => $factoryData->getstate(),
  2539.                             "country" => $factoryData->getcountry(),
  2540.                             "pincode" => $factoryData->getpincode(),
  2541.                             "bestbefore" => $factoryData->getbestbefore());
  2543.                         $log_data = $api_log_info." | curdata:".json_encode($curdata);
  2544.                         SELF::createApiLog($log_data);
  2546.                         array_push($data, $curdata);
  2548.                     }
  2549.                 } else {
  2550.                     $data = "No data found!";
  2551.                     $log_data = $api_log_info." | data:".json_encode($data);
  2552.                     SELF::createApiLog($log_data);
  2553.                 }
  2554.             }
  2555.         }
  2557.         $return_data = ["success" => true, "data" => $data];
  2559.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2560.         SELF::createApiLog($log_data);
  2562.         return $this->json(["success" => true, "data" => $data]);
  2563.     }
  2565.     /*------------------------------ End of Factory Related APIs -------------------------*/
  2567.     /*---------------------------------- Faq Related APIs ----------------------------*/
  2568.     /**
  2569.      * @param Request $request
  2570.      * 
  2571.      * @Route("/faqApi1",methods={"POST"})
  2572.      * 
  2573.      * @return Response
  2574.      * 
  2575.      */
  2576.     
  2577.      public function faqApi1Action(Request $request)
  2578.      {
  2579.         $api_log_info = "API:Get Faq List by locationcode with or without type - ".date("YmdHis")." ".time();
  2580.         $log_data = "Started - ".$api_log_info;
  2581.         SELF::createApiLog($log_data);
  2583.         $data = SELF::verifyauthToken($api_log_info);
  2585.         $log_data = $api_log_info." | data:".json_encode($data);
  2586.         SELF::createApiLog($log_data);
  2588.         if($data == "No data found")
  2589.         {
  2590.             $locationcode = (!empty($request->get('location_code')))?$request->get('location_code'):'';
  2592.             if($locationcode == "")
  2593.             {
  2594.                 $data = "Location Code is mandatory";
  2595.             } else {
  2596.                 $getlocationInfo = DataObject\Locations::getBylocation_code($locationcode, 1);
  2598.                 $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2599.                 SELF::createApiLog($log_data);
  2601.                 if((!empty($getlocationInfo))){
  2602.                     $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2603.                     $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2605.                     $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2606.                     SELF::createApiLog($log_data);
  2608.                     $faqType = (!empty($request->get('type')) && $request->get('type') == 'All')?'':((!empty($request->get('type')) && $request->get('type') != 'All')?$request->get('type'):'General');
  2610.                     $log_data = $api_log_info." | locationcode:".json_encode($locationcode)." | faqType:".json_encode($faqType);
  2611.                     SELF::createApiLog($log_data);
  2613.                     $faqTypes_list = ['','All','General', 'Loyalty'];
  2614.                     if(!in_array($faqType, $faqTypes_list)){
  2615.                         $data = "You are entered Type is Invalid, Please try again";
  2617.                         $return_data = ["success" => true, "data" => $data];
  2619.                         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2620.                         SELF::createApiLog($log_data);
  2621.                         
  2622.                         return $this->json(["success" => true, "data" => $data]);
  2623.                     }
  2624.             
  2625.                     $entries = new DataObject\ItcAddFaq\Listing();
  2627.                     $whr_condition = " faqQuestion!= '' ";
  2628.                     if($locationcode != '')
  2629.                     $whr_condition .= " AND location_code= '".$loc_name."' ";
  2630.                     if($faqType != '')
  2631.                     $whr_condition .= " AND faqType= '".$faqType."' ";
  2633.                     // if($locationcode != '')
  2634.                     // $entries->setCondition("location_name = :location_name", ["location_name" => $locationcode]);
  2635.                     // if($faqType != '')
  2636.                     // $entries->setCondition("faqType = :faqType", ["faqType" => $faqType]);
  2637.                     $entries->setCondition($whr_condition);
  2638.                     $entries->load();
  2640.                     $log_data = $api_log_info." | faq entries count :".json_encode(count($entries));
  2641.                     SELF::createApiLog($log_data);
  2643.                     $data = (count($entries)>0)?array():"No data found";
  2645.                     foreach($entries as $key => $entrie){
  2647.                         $log_data = $api_log_info." | faq key :".json_encode($key)." | faq entrie :".json_encode($entrie);
  2648.                         SELF::createApiLog($log_data);
  2649.             
  2650.                         if($entrie->getlocation_code()){
  2651.                             $locationInfo = DataObject\Locations::getBylocation_name($entrie->getlocation_code(), 1);
  2653.                             $log_data = $api_log_info." | locationInfo :".json_encode($locationInfo);
  2654.                             SELF::createApiLog($log_data);
  2655.                             
  2656.                             $loc_name = (!empty($locationInfo->getlocation_name()))?$locationInfo->getlocation_name():'';
  2657.                             $loc_code = (!empty($locationInfo->getlocation_code()))?$locationInfo->getlocation_code():'';
  2659.                             $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2660.                             SELF::createApiLog($log_data);
  2661.                         }
  2662.                         $data[] = array("faqId" => $entrie->getfaqId(),
  2663.                                 "location_code" => $loc_code,
  2664.                                 "location_name" => $loc_name,
  2665.                                 "faqQuestion" => $entrie->getfaqQuestion(),
  2666.                                 "faqAnswer" => $entrie->getfaqAnswer(),
  2667.                                 "Type" => $entrie->getfaqType(),
  2668.                         );
  2670.                         $log_data = $api_log_info." | data :".json_encode($data);
  2671.                         SELF::createApiLog($log_data);
  2672.                     }
  2674.                 } else {
  2675.                     $data = "Invalid Location Code, Please enter valid Location Code";
  2676.                     $log_data = $api_log_info." | data :".json_encode($data);
  2677.                     SELF::createApiLog($log_data);
  2678.                 }
  2679.             }
  2680.         }
  2682.         $return_data = ["success" => true, "data" => $data];
  2684.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2685.         SELF::createApiLog($log_data);
  2686.         
  2687.         return $this->json(["success" => true, "data" => $data]);
  2688.         
  2689.      }
  2690.      /**
  2691.      * @param Request $request
  2692.      * 
  2693.      * @Route("/faqApi",methods={"POST"})
  2694.      * 
  2695.      * @return Response
  2696.      * 
  2697.      */
  2698.      public function faqApiAction(Request $request)
  2699.      {
  2700.         $api_log_info = "API:Get Faq List by locationcode with or without type - ".date("YmdHis")." ".time();
  2701.         $log_data = "Started - ".$api_log_info;
  2702.         SELF::createApiLog($log_data);
  2704.         $data = SELF::verifyauthToken($api_log_info);
  2706.         $log_data = $api_log_info." | data:".json_encode($data);
  2707.         SELF::createApiLog($log_data);
  2709.         if($data == "No data found")
  2710.         {
  2711.             $locationcode = (!empty($request->get('location_code')))?$request->get('location_code'):'';
  2713.             // if($locationcode == "")
  2714.             // {
  2715.             //     $data = "Location Code is mandatory";
  2716.             // } else {
  2718.                 $getlocationInfo = (isset($locationcode) && $locationcode!='')?DataObject\Locations::getBylocation_code($locationcode, 1):[];
  2720.                 $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2721.                 SELF::createApiLog($log_data);
  2723.                 // if((!empty($getlocationInfo))){
  2725.                     $loc_name = (!empty($getlocationInfo) && !empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2726.                     $loc_code = (!empty($getlocationInfo) && !empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2728.                     $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2729.                     SELF::createApiLog($log_data);
  2731.                     $faqType = (!empty($request->get('type')) && $request->get('type') == 'All')?'':((!empty($request->get('type')) && $request->get('type') != 'All')?$request->get('type'):'General');
  2733.                     $log_data = $api_log_info." | locationcode:".json_encode($locationcode)." | faqType:".json_encode($faqType);
  2734.                     SELF::createApiLog($log_data);
  2736.                     $faqTypes_list = ['','All','General', 'Loyalty'];
  2737.                     if(!in_array($faqType, $faqTypes_list)){
  2738.                         $data = "You are entered Type is Invalid, Please try again";
  2740.                         $return_data = ["success" => true, "data" => $data];
  2742.                         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2743.                         SELF::createApiLog($log_data);
  2744.                         
  2745.                         return $this->json(["success" => true, "data" => $data]);
  2746.                     }
  2747.             
  2748.                     $entries = new DataObject\ItcAddFaq\Listing();
  2750.                     $whr_condition = " faqQuestion!= '' ";
  2751.                     if($locationcode != '')
  2752.                     $whr_condition .= " AND location_code= '".$loc_name."' ";
  2753.                     if($faqType != '')
  2754.                     $whr_condition .= " AND faqType= '".$faqType."' ";
  2756.                     // if($locationcode != '')
  2757.                     // $entries->setCondition("location_name = :location_name", ["location_name" => $locationcode]);
  2758.                     // if($faqType != '')
  2759.                     // $entries->setCondition("faqType = :faqType", ["faqType" => $faqType]);
  2760.                     $entries->setCondition($whr_condition);
  2761.                     $entries->load();
  2763.                     $log_data = $api_log_info." | faq entries count :".json_encode(count($entries));
  2764.                     SELF::createApiLog($log_data);
  2766.                     $data = (count($entries)>0)?array():"No data found";
  2768.                     foreach($entries as $key => $entrie){
  2770.                         $log_data = $api_log_info." | faq key :".json_encode($key)." | faq entrie :".json_encode($entrie);
  2771.                         SELF::createApiLog($log_data);
  2772.             
  2773.                         if($entrie->getlocation_code()){
  2774.                             $locationInfo = DataObject\Locations::getBylocation_name($entrie->getlocation_code(), 1);
  2776.                             $log_data = $api_log_info." | locationInfo :".json_encode($locationInfo);
  2777.                             SELF::createApiLog($log_data);
  2778.                             
  2779.                             $loc_name = (!empty($locationInfo->getlocation_name()))?$locationInfo->getlocation_name():'';
  2780.                             $loc_code = (!empty($locationInfo->getlocation_code()))?$locationInfo->getlocation_code():'';
  2782.                             $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2783.                             SELF::createApiLog($log_data);
  2784.                         }
  2785.                         $data[] = array("faqId" => $entrie->getfaqId(),
  2786.                                 "location_code" => $loc_code,
  2787.                                 "location_name" => $loc_name,
  2788.                                 "faqQuestion" => $entrie->getfaqQuestion(),
  2789.                                 "faqAnswer" => $entrie->getfaqAnswer(),
  2790.                                 "Type" => $entrie->getfaqType(),
  2791.                         );
  2793.                         $log_data = $api_log_info." | data :".json_encode($data);
  2794.                         SELF::createApiLog($log_data);
  2795.                     }
  2797.                 // } else {
  2798.                 //     $data = "Invalid Location Code, Please enter valid Location Code";
  2799.                 //     $log_data = $api_log_info." | data :".json_encode($data);
  2800.                 //     SELF::createApiLog($log_data);
  2801.                 // }
  2802.             // }
  2803.         }
  2805.         $return_data = ["success" => true, "data" => $data];
  2807.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2808.         SELF::createApiLog($log_data);
  2809.         
  2810.         return $this->json(["success" => true, "data" => $data]);
  2811.         
  2812.      }
  2813.     /*------------------------------ End of Faq Related APIs -------------------------*/
  2815.     /*--------------------------------- Pincode Related APIs -----------------------------*/
  2816.     /**
  2817.      * @param Request $request
  2818.      * 
  2819.      * @Route("/wearhouseDetectionApi",methods={"POST"})
  2820.      * 
  2821.      * @return Response
  2822.      * 
  2823.      */
  2825.      public function wearhouseDetectionApiAction(Request $request)
  2826.      { 
  2827.         $api_log_info = "API:Get Wearhouse data by Pincode - ".date("YmdHis")." ".time();
  2828.         $log_data = "Started - ".$api_log_info;
  2829.         SELF::createApiLog($log_data);
  2831.         $message = SELF::verifyauthToken();
  2833.         $log_data = $api_log_info." | message:".json_encode($message);
  2834.         SELF::createApiLog($log_data);
  2835.  
  2836.         if($message == "No data found")
  2837.         {
  2838.             if($request->get('pincode')){
  2839.                 $pincode = $request->get('pincode');
  2841.                 $log_data = $api_log_info." | pincode:".json_encode($pincode);
  2842.                 SELF::createApiLog($log_data);
  2844.                 // $entries = new DataObject\ItcAddPincode\Listing();
  2845.                 // $entries->setCondition("pincode = :name", ["name" => $pincode]);
  2846.                 // $entries->load();
  2848.                 $getpincodeInfo = DataObject\ItcAddPincode::getBypincode($pincode, 1);
  2850.                 $log_data = $api_log_info." | getpincodeInfo :".json_encode($getpincodeInfo);
  2851.                 SELF::createApiLog($log_data);
  2853.                 if((!empty($getpincodeInfo))){
  2855.                     $loc_name = $loc_code = '';
  2857.                     $location_name = (!empty($getpincodeInfo->getlocation_code()))?$getpincodeInfo->getlocation_code():"";
  2859.                     $log_data = $api_log_info." | location_name:".json_encode($location_name);
  2860.                     SELF::createApiLog($log_data);
  2862.                     if(!empty($location_name)){
  2863.                         $getlocationInfo = DataObject\Locations::getBylocation_name($location_name, 1);
  2865.                         $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2866.                         SELF::createApiLog($log_data);
  2868.                         if((!empty($getlocationInfo))){
  2869.                             $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2870.                             $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2871.                         } 
  2873.                         $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2874.                         SELF::createApiLog($log_data);                     
  2875.                     }
  2877.                     $data = array("pincode" => $getpincodeInfo->getpincode(),
  2878.                                     "store_code" => $loc_code,
  2879.                                     "location_name" => $loc_name,
  2880.                                     "city_name" => $getpincodeInfo->getcity(),
  2881.                                     "state" => $getpincodeInfo->getstate(),
  2882.                                     "delivery_type" => $getpincodeInfo->getdeliverytype(),
  2883.                                     "is_shipping_applicable" => $getpincodeInfo->getis_shipping_applicable(),
  2884.                                     "merichakki_available" => $getpincodeInfo->getmerichakki_available(),
  2885.                                     "nammachakki_available" => $getpincodeInfo->getnammachakki_available(),
  2886.                                     "vin_instance" => $getpincodeInfo->getvin_instance(),
  2887.                                 );
  2889.                 } else {
  2890.                     $data = "You are entered Pincode is Invalid, Please try again";
  2891.                 }
  2892.                 $log_data = $api_log_info." | data :".json_encode($data);
  2893.                 SELF::createApiLog($log_data);  
  2895.             }elseif($request->get('city_name')){
  2896.                 $city = $request->get('city_name');
  2898.                 $log_data = $api_log_info." | city :".json_encode($city);
  2899.                 SELF::createApiLog($log_data);  
  2901.                 $entries = new DataObject\ItcAddPincode\Listing();
  2902.                 $entries->setCondition("city = :name OR location_code = :name", ["name" => $city,"location_code" => $city]);
  2903.                 $entries->setLimit(1);
  2904.                 $entries->load();
  2906.                 $log_data = $api_log_info." | entries count :".json_encode(count($entries));
  2907.                 SELF::createApiLog($log_data);  
  2909.                 foreach($entries as $key => $entrie){
  2911.                     $log_data = $api_log_info." | entrie :".json_encode($entrie);
  2912.                     SELF::createApiLog($log_data); 
  2914.                     $loc_name = $loc_code = '';
  2916.                     $location_name = (!empty($entrie->getlocation_code()))?$entrie->getlocation_code():"";
  2918.                     $log_data = $api_log_info." | location_name:".json_encode($location_name);
  2919.                     SELF::createApiLog($log_data);
  2921.                     if(!empty($location_name)){
  2922.                         $getlocationInfo = DataObject\Locations::getBylocation_name($location_name, 1);
  2924.                         $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2925.                         SELF::createApiLog($log_data);
  2927.                         if((!empty($getlocationInfo))){
  2928.                             $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2929.                             $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2930.                         } 
  2932.                         $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2933.                         SELF::createApiLog($log_data);                     
  2934.                     }
  2936.                     $data = array("pincode" => $entrie->getpincode(),
  2937.                                     "store_code" => $loc_code,
  2938.                                     "location_name" => $loc_name,
  2939.                                     "city_name" => $entrie->getcity(),
  2940.                                     "state" => $entrie->getstate(),
  2941.                                     "delivery_type" => $entrie->getdeliverytype(),
  2942.                                     "is_shipping_applicable" => $entrie->getis_shipping_applicable(),
  2943.                                     "merichakki_available" => $entrie->getmerichakki_available(),
  2944.                                     "nammachakki_available" => $entrie->getnammachakki_available(),
  2945.                                     "vin_instance" => $entrie->getvin_instance(),
  2946.                                 );
  2947.                 }
  2948.             }  else {
  2949.                 $data = "Pincode is mandatory";
  2950.             }      
  2951.         } 
  2952.         else
  2953.             $data[] = ['message'=>$message];
  2955.         if(!empty($data)){
  2957.             $success = (empty($data['pincode'])) ? false : true;
  2958.             if ($success) {
  2959.                 return $this->json(["success" => $success, "data" => $data]);
  2960.             } else {
  2961.                 return $this->json(["success" => $success, 'message' => $data]);
  2962.             }
  2963.         }else{
  2964.             return $this->json(["success" => false, "message" => "Service not available"]);
  2965.         }
  2966.       
  2967.      }
  2968.     /*------------------------------ End of Pincode Related APIs -------------------------*/
  2969.     /*---------------------------------- Voucher Related APIs ----------------------------*/
  2970.     /**
  2971.      * @Route("api/getvouchersdata", methods={"POST"})
  2972.      */
  2973.     public function getvouchersdataAction(Request $request)
  2974.     {
  2975.         $api_log_info = "API:Get Vouchers list by multiple voucher codes - ".date("YmdHis")." ".time();
  2976.         $log_data = "Started - ".$api_log_info;
  2977.         SELF::createApiLog($log_data);
  2979.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2981.         $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2982.         SELF::createApiLog($log_data);
  2984.         $vouchercodes = (isset($reqparams['vouchercodes']))?$reqparams['vouchercodes']:'';
  2985.         $vouchertype = (isset($reqparams['vouchertype']))?$reqparams['vouchertype']:'';
  2987.         $log_data = $api_log_info." | vouchercodes:".json_encode($vouchercodes)." | vouchertype:".json_encode($vouchertype);
  2988.         SELF::createApiLog($log_data);
  2990.         // $factorycode = $request->get('factorycode');
  2992.         if(($vouchercodes == "" || !is_array($vouchercodes)) && ($vouchertype == '' || ($vouchertype && !in_array($vouchertype, ["Master", "all"]))))
  2993.         {
  2994.             
  2995.             $data = "Voucher Code(s) OR Voucher Type is(are) mandatory, Voucher Type must be like Master OR all!";
  2997.             $log_data = $api_log_info." | data:".json_encode($data);
  2998.             SELF::createApiLog($log_data);
  2999.         } else 
  3000.         {
  3001.             // die;
  3002.             $data = SELF::verifyauthToken($api_log_info);
  3004.             $log_data = $api_log_info." | data:".json_encode($data);
  3005.             SELF::createApiLog($log_data);
  3007.             if($data == "No data found")
  3008.             {
  3009.                 $vouchertype = ($vouchertype == 'all')?'Voucher':$vouchertype;
  3011.                 /*---- Get Master Voucher data by Master Voucher Code ---------*/
  3012.                 $master_voucher = "Master_Voucher";
  3013.                 $masterVoucherData = DataObject\Vouchers::getByvoucher_code($master_voucher, 1);
  3014.                 
  3015.                 $projectUrl  = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off' ? 'https://' : 'http://';
  3016.                 $projectUrl .= $_SERVER['SERVER_NAME'];
  3017.                 $log_data = $api_log_info." | projectUrl:".json_encode($projectUrl);
  3018.                 SELF::createApiLog($log_data);
  3020.                 /*---- Check Factory by Code ---------*/
  3021.                 $vouchersData = new DataObject\Vouchers\Listing();
  3022.                 if($vouchercodes)
  3023.                 $vouchersData->setCondition("voucher_code IN (?)", [$vouchercodes]);
  3024.                 else if($vouchertype)
  3025.                 $vouchersData->setCondition("voucher_type IN (?)", [$vouchertype]);
  3026.                 $vouchersData->load();
  3028.                 $log_data = $api_log_info." | vouchersData count:".json_encode(count($vouchersData));
  3029.                 SELF::createApiLog($log_data);
  3031.                 if(!empty($vouchersData) && count($vouchersData)>0){
  3032.                     $data = [];
  3033.                     foreach($vouchersData as $voucherData){
  3035.                         $log_data = $api_log_info." | voucherData:".json_encode($voucherData);
  3036.                         SELF::createApiLog($log_data);
  3038.                         $voucher_logo_path = ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getvoucher_logo():$voucherData->getvoucher_logo();
  3039.                         $voucher_logo_path = $projectUrl."/uploads/".$voucher_logo_path;
  3040.                         $voucher_background_image_path = $projectUrl."/uploads/".($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getvoucher_background_image():$voucherData->getvoucher_background_image();
  3041.                         $voucher_background_image_path = $projectUrl."/uploads/".$voucher_background_image_path;
  3043.                         $curdata = array(
  3044.                             "id" => $voucherData->getId(),
  3045.                             "voucher_code" => $voucherData->getvoucher_code(),
  3046.                             "about_offer" => ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getabout_offer():$voucherData->getabout_offer(),
  3047.                             "avail_offer" => ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getavail_offer():$voucherData->getavail_offer(),
  3048.                             "voucher_logo_path" => $voucher_logo_path,
  3049.                             "voucher_background_image_path" => $voucher_background_image_path);
  3051.                         $log_data = $api_log_info." | curdata:".json_encode($curdata);
  3052.                         SELF::createApiLog($log_data);
  3054.                         array_push($data, $curdata);
  3056.                     }
  3057.                 } else {
  3058.                     $data = "No data found!";
  3059.                     $log_data = $api_log_info." | data:".json_encode($data);
  3060.                     SELF::createApiLog($log_data);
  3061.                 }
  3062.             }
  3063.         }
  3065.         $return_data = ["success" => true, "data" => $data];
  3067.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  3068.         SELF::createApiLog($log_data);
  3070.         return $this->json(["success" => true, "data" => $data]);
  3071.     }
  3072.     /*------------------------------ End of Voucher Related APIs -------------------------*/
  3074.     /*---------------------------------- Log Related APIs ----------------------------*/
  3075.     /**
  3076.      * @Route("/api/log_info/{date?}")
  3077.      */
  3078.     public function log_infoAction($date)
  3079.     {
  3080.         // $date = ($date == '')?date("Y-m-d", strtotime("-1 day")):$date;
  3081.         $date = ($date == '')?date("Y-m-d"):$date;
  3082.         if($date == '')
  3083.         {
  3084.             $data = "Date is mandatory!";
  3085.         } else {
  3086.             $file = '../var/log/slot-api-log_'.$date.'.txt';
  3087.             if(file_exists($file)){
  3088.                 $myfile = fopen($file, "r") or die("Unable to open file!");
  3089.                 $data = fread($myfile,filesize($file));
  3090.                 fclose($myfile);
  3091.             } else {
  3092.                 $data = "The file is not exited!";
  3093.             }
  3094.         }
  3095.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3096.     }
  3098.     /**
  3099.      * @Route("/api/log_info_data")
  3100.      */
  3101.     public function log_info_dataAction(Request $requet)
  3102.     {
  3103.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3105.         $date = (isset($reqparams['date']))?$reqparams['date']:'';
  3106.         $from_line = (isset($reqparams['from_line']))?$reqparams['from_line']:'';
  3107.         $to_line = (isset($reqparams['to_line']))?$reqparams['to_line']:'';
  3109.         $date = ($date == '')?date("Y-m-d"):$date;
  3110.         if($date == '' || $from_line == '' || $to_line == '')
  3111.         {
  3112.             $data = "Date, from_line and to_line are mandatory!";
  3113.         } else {
  3114.             $file = '../var/log/slot-api-log_'.$date.'.txt';
  3115.             if(file_exists($file)){
  3116.                 $splitdata = array_slice(file($file), $from_line, $to_line);
  3117.                 echo $data = implode('', $splitdata); die;
  3118.             } else {
  3119.                 $data = "The file is not exited!";
  3120.             }
  3121.         }
  3122.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3123.     }
  3125.     /**
  3126.      * @Route("/api/delete_log_file/{date}")
  3127.      */
  3128.     public function delete_log_fileAction($date)
  3129.     {
  3130.         if($date == '')
  3131.         {
  3132.             $data = "Date is mandatory!";
  3133.         } else {
  3135.             $message = SELF::verifyauthToken();
  3136.         
  3137.             if($message == "No data found")
  3138.             {
  3139.                 $file = '../var/log/slot-api-log_'.$date.'.txt';
  3140.                 if(file_exists($file)){
  3141.                     unlink($file);
  3142.                     $data = "Deleted the file successfully!";
  3143.                 } else {
  3144.                     $data = "The file is not exited!";
  3145.                 }
  3146.             }else $data[] = ['message'=>$message];
  3147.         }
  3148.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3149.     }
  3151.     /**
  3152.      * @Route("/api/delete_log_files")
  3153.      */
  3154.     public function delete_log_filesAction(Request $request)
  3155.     {
  3156.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3158.         $fromdate = (isset($reqparams['fromdate']))?$reqparams['fromdate']:'';
  3159.         $todate = (isset($reqparams['todate']))?$reqparams['todate']:'';
  3161.         if($fromdate == '' || $todate == '')
  3162.         {
  3163.             $data = "From Date and To Date are mandatory!";
  3164.         } else {
  3165.             $message = SELF::verifyauthToken();
  3166.         
  3167.             if($message == "No data found")
  3168.             {
  3169.                 $rangeDates = SELF::getDatesFromRange($fromdate, $todate);
  3170.                 // echo 'rangeDates:<pre>';
  3171.                 // print_r($rangeDates); die;
  3172.                 foreach($rangeDates as $rangeDateInfo){
  3173.                     $file = '../var/log/slot-api-log_'.$rangeDateInfo.'.txt';
  3174.                     if(file_exists($file)){
  3175.                         unlink($file);
  3176.                         $data = "Deleted the file successfully!";
  3177.                     } else {
  3178.                         $data = (isset($data) && $data == "Deleted the file successfully!")?$data:"The file is not exited!";
  3179.                     }
  3180.                 }
  3181.             }else $data[] = ['message'=>$message];
  3182.         }
  3183.         return $this->json(["success" => true, "fromdate" => $fromdate, "todate" => $todate, "data" => $data]);
  3184.     }
  3187.     /**
  3188.      * @Route("/api/get_log_files")
  3189.      */
  3190.     public function get_log_filesAction(Request $request)
  3191.     {
  3192.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3194.         $fromdate = (isset($reqparams['fromdate']))?$reqparams['fromdate']:'';
  3195.         $todate = (isset($reqparams['todate']))?$reqparams['todate']:'';
  3197.         $filenames = [];
  3199.         if($fromdate == '' || $todate == '')
  3200.         {
  3201.             $data = "From Date and To Date are mandatory!";
  3202.         } else {
  3203.             $message = SELF::verifyauthToken();
  3204.         
  3205.             if($message == "No data found")
  3206.             {
  3207.                 $rangeDates = SELF::getDatesFromRange($fromdate, $todate);
  3208.                 // echo 'rangeDates:<pre>';
  3209.                 // print_r($rangeDates); die;
  3210.                 foreach($rangeDates as $rangeDateInfo){
  3211.                     $file = '../var/log/slot-api-log_'.$rangeDateInfo.'.txt';
  3212.                     if(file_exists($file)){
  3213.                         array_push($filenames, 'slot-api-log_'.$rangeDateInfo.'.txt');
  3214.                     } else {
  3215.                         $msg = (!empty($filenames))?'':"The file is not exited!";
  3216.                     }
  3217.                 }
  3219.                 $data = (!empty($filenames))?$filenames:$msg;
  3221.             }else $data[] = ['message'=>$message];
  3222.         }
  3223.         return $this->json(["success" => true, "fromdate" => $fromdate, "todate" => $todate, "data" => $data]);
  3224.     }
  3225.     /*------------------------------ End of Log Related APIs -------------------------*/
  3227.     /**
  3228.      * @Route("/location/locationslist")
  3229.      */
  3230.     public function locationslist()
  3231.     {
  3232.         $log_data = "Started - API:Get All Locations";
  3233.         SELF::createApiLog($log_data);
  3235.         $message = SELF::verifyauthToken();
  3237.         $log_data = "API:Get All Locations | message:".json_encode($message);
  3238.         SELF::createApiLog($log_data);
  3240.         if($message == "No data found")
  3241.         {
  3242.             $locationsList = DataObject\Locations::getList();
  3243.             $locationsList->load();
  3245.             $log_data = "API:Get All Locations | locationsList count :".json_encode(count($locationsList));
  3246.             SELF::createApiLog($log_data);
  3248.             if(count($locationsList) > 0){
  3249.                 foreach ($locationsList as $key => $location) {
  3251.                     $log_data = "API:Get All Locations | location :".json_encode($location);
  3252.                     SELF::createApiLog($log_data);
  3254.                     $data[] = array(
  3255.                         "Id" => $location->getId(),
  3256.                         "location_name" => $location->getLocation_name(),
  3257.                         "location_code" => $location->getLocation_code());
  3259.                     $log_data = "API:Get All Locations | data :".json_encode($data);
  3260.                     SELF::createApiLog($log_data);
  3261.                 }
  3262.             } else $data[] = ['message'=>$message];
  3263.         } else $data[] = ['message'=>$message];
  3265.         $log_data = "Ended - API:Get All Locations | data :".json_encode($data);
  3266.         SELF::createApiLog($log_data);
  3267.         
  3268.         return $this->json(["success" => true, "data" => $data]);
  3269.     }
  3271.     /*--------------- Authentication related methods ----------------*/
  3272.     public function generateAuthToken($userInfo=[])
  3273.     {
  3274.         /*------------- Generate MDF encode --------------*/
  3275.         $generateAuthToken = md5(time());
  3277.         $jwtdata = array(
  3278.             "generateAuthToken" => $generateAuthToken
  3279.         );
  3281.         /*------------- Generate JWT Token ---------------*/
  3282.         $jwt_check = 0;
  3283.         if(!empty($userInfo)){
  3284.             $id = $userInfo['id'];//1024;
  3285.             $firstname = $userInfo['firstname'];//'Tex';
  3286.             $lastname = $userInfo['lastname'];//'Hardrock';
  3287.             $email = $userInfo['email'];//'dino@stone.age';
  3289.             $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  3290.             $issuer_claim = "pimcore6.local"; // this can be the servername
  3291.             $audience_claim = "Babu";
  3292.             $issuedat_claim = time(); // issued at
  3293.             $notbefore_claim = $issuedat_claim + 10; //not before in seconds
  3294.             $expire_claim = $issuedat_claim + 60*5; // expire time in seconds
  3295.             $token = array(
  3296.                 "iss" => $issuer_claim,
  3297.                 "aud" => $audience_claim,
  3298.                 "iat" => $issuedat_claim,
  3299.                 "nbf" => $notbefore_claim,
  3300.                 "exp" => $expire_claim,
  3301.                 "data" => array(
  3302.                     "id" => $id,
  3303.                     "firstname" => $firstname,
  3304.                     "lastname" => $lastname,
  3305.                     "email" => $email
  3306.             ));
  3308.             $jwt = JWT::encode($token, $secret_key, 'HS256');
  3309.             
  3310.             $jwtdata = array(
  3311.                 "generateAuthToken" => $generateAuthToken,
  3312.                 "jwt" => $jwt,
  3313.                 "email" => $email,
  3314.                 "expireAt" => $expire_claim
  3315.             );
  3316.         }
  3317.         return $jwtdata;
  3318.     }
  3320.     public function verifyauthToken1()
  3321.     {
  3322.         $message = "No data found"; $tokenCheck = 0;
  3323.         $headers=array();
  3324.         foreach (getallheaders() as $name => $value) {
  3325.             $headers[$name] = $value;
  3326.             if($name == 'Authtoken') $tokenCheck = 1;
  3327.         }
  3328.         if($tokenCheck == 0){
  3329.             $message = "Authentication Token is missing";;
  3330.         } else {
  3331.             $Authtoken = $headers['Authtoken'];
  3332.         
  3333.             $dbConnection = \Pimcore\Db::get();
  3334.             $authTokencheck = $dbConnection->fetchOne("SELECT id FROM users WHERE authToken = '".$Authtoken."' ");
  3336.             if(empty($authTokencheck)){
  3337.                 $message = "Authentication Token is mismatch";
  3338.             } else {
  3340.             }
  3341.         }
  3343.         return $message;
  3344.     }
  3346.     public function verifyauthToken2()
  3347.     {
  3348.         $api_key = 'api-key';
  3349.         $api_key_value = 'cGltY29yZWFwaWtleXZhbHVl';//base64encode('pimcoreapikeyvalue);
  3351.         $message = "No data found"; $tokenCheck = 0; $apikeyCheck = 0; $jwtCheck = 0;$tokenMsg = ''; $apikeyMsg = ''; $jwtMsg = '';
  3352.         $headers=array();
  3353.         foreach (getallheaders() as $name => $value) {
  3354.             $headers[$name] = $value;
  3355.             if($name == 'Authtoken') $tokenCheck = 1;
  3356.             if($name == 'Api-Key') $apikeyCheck = 1;
  3357.             if($name == 'Authorization') $jwtCheck = 1;
  3358.         }
  3360.         // echo 'arr:<pre>';
  3361.         // print_r($headers); 
  3362.         // die;
  3363.         if($tokenCheck == 0 && $apikeyCheck == 0 && $jwtCheck == 0){
  3364.             $message = "Fill any one of the Authentication Token, Api-Key Or JWT token!";;
  3365.         } else {
  3366.             $tokenCheck_valid = 0; $apikeyCheck_valid = 0; $jwtTokenCheck_valid = 0;
  3368.             /*--------------------- Validating Auth Token -----------------*/
  3369.             if($tokenCheck == 1)
  3370.             {
  3371.                 $Authtoken = $headers['Authtoken'];
  3372.         
  3373.                 $dbConnection = \Pimcore\Db::get();
  3374.                 $authTokencheck = $dbConnection->fetchOne("SELECT id FROM users WHERE authToken = '".$Authtoken."' ");
  3376.                 if(empty($authTokencheck)){
  3377.                     $tokenMsg = "Authentication Token is mismatch";
  3378.                 } else {
  3379.                     $tokenCheck_valid = 1;
  3380.                 }
  3381.             }
  3383.             /*--------------------- Validating Api Key -----------------*/
  3384.             if($apikeyCheck == 1)
  3385.             {
  3386.                 $AuthApikey = $headers['Api-Key'];
  3388.                 if(empty($AuthApikey)){
  3389.                     $apikeyMsg = "Key is mismatch";
  3390.                 } else if($AuthApikey != $api_key_value){
  3391.                     $apikeyMsg = "key is mismatch";
  3392.                 } else {
  3393.                     $apikeyCheck_valid = 1;
  3394.                 }
  3395.             }
  3397.             /*--------------------- Validating JWT Token -----------------*/
  3398.             if($jwtCheck == 1)
  3399.             {
  3400.                 $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  3401.                 $jwt = null;
  3403.                 $authHeader = $_SERVER['HTTP_AUTHORIZATION'];
  3405.                 $arr = explode(" ", $authHeader);
  3406.                 $jwt = $arr[1];
  3408.                 if($jwt){
  3409.                     try {
  3410.                         $decoded = JWT::decode($jwt, new Key($secret_key, 'HS256'));
  3411.                         $jwtTokenCheck_valid = 1;
  3412.                     }catch (ExpiredException $e){
  3413.                         $jwtMsg = "Expired JWT Token!";//$e->getMessage();
  3414.                     }catch (Exception $e){
  3415.                         $jwtTokenCheck_valid = 0;
  3416.                         $jwtMsg = "Expired JWT Token!";//$e->getMessage();
  3417.                     }
  3418.                 } else {
  3419.                     $jwtMsg = "JWT Token is missing";
  3420.                 }
  3421.             }
  3423.             $message = '';
  3424.             if($tokenMsg != '' || $apikeyMsg != '' || $jwtMsg != '')
  3425.             {
  3426.                 $message = ($tokenMsg != '')?"Token Message:".$message.$tokenMsg:$message;
  3427.                 $message = ($apikeyMsg != '')?"".$message." | Api-Key Message:".$apikeyMsg:$message;
  3428.                 $message = ($jwtMsg != '')?"".$message." | JWT Message:".$jwtMsg:$message;
  3429.             }
  3431.             $message = ($tokenCheck_valid == 1 || $apikeyCheck_valid == 1 || $jwtTokenCheck_valid == 1)?"No data found":$message;
  3432.         }
  3434.         return $message;
  3435.     }
  3437.     public function verifyauthToken($api_log_info='')
  3438.     {        
  3439.         $start_method_log_info = "Verify Auth Token Method";
  3440.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Started - ".$start_method_log_info:"Started - ".$start_method_log_info;
  3441.         $log_data = $api_log_method_info;
  3442.         SELF::createApiLog($log_data);
  3444.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | ".$start_method_log_info:$start_method_log_info;
  3446.         $api_key = 'api-key';
  3447.         $api_key_value = 'cGltY29yZWFwaWtleXZhbHVl';//base64encode('pimcoreapikeyvalue);
  3449.         $message = "No data found"; $apikeyCheck = 0; $apikeyMsg = '';
  3450.         $headers=array();
  3451.         foreach (getallheaders() as $name => $value) {
  3452.             $headers[$name] = $value;
  3453.             if($name == 'Api-Key') $apikeyCheck = 1;
  3454.         }
  3455.         
  3456.         if($apikeyCheck == 0){
  3457.             $message = "Api-Key is mandatory!";;
  3458.         } else {
  3459.             $apikeyCheck_valid = 0;
  3461.             /*--------------------- Validating Api Key -----------------*/
  3462.             if($apikeyCheck == 1)
  3463.             {
  3464.                 $AuthApikey = $headers['Api-Key'];
  3466.                 if(empty($AuthApikey)){
  3467.                     $message = "Key is empty, Api-Key is mandatory";
  3468.                 } else if($AuthApikey != $api_key_value){
  3469.                     $message = "key is mismatch";
  3470.                 } else {
  3471.                     $apikeyCheck_valid = 1;
  3472.                 }
  3473.             }
  3474.         }
  3476.         $apikeyCheck_valid = 1;
  3477.         $message = "No data found";
  3479.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Ended - ".$start_method_log_info:"Ended - ".$start_method_log_info;
  3480.         $log_data = $api_log_method_info." | message:".$message;
  3481.         SELF::createApiLog($log_data);
  3483.         return $message;
  3484.     }
  3485.     /*--------------- End of Authentication related methods ------------*/
  3487.     /*-------------------------- Sub methods ---------------------------*/
  3488.     public function generateObjFolder($folderName,$location_code){
  3490.         $yr = date("Y");
  3491.         $mt = date("M");
  3492.         $dy = date("d");
  3494.         $path = "/".$folderName."/".$yr."/".$mt."/".$dy;
  3495.         $path = "/".$folderName."/".$location_code;
  3497.         $object = DataObject::getByPath($path);
  3498.         if(!$object){
  3499.             $path1 = "/".$folderName."/".$yr."/".$mt;
  3500.             $object1 = DataObject::getByPath($path1);
  3501.             if(!$object1){
  3502.                 $path2 = "/".$folderName."/".$yr;
  3503.                 $object2 = DataObject::getByPath($path2);                
  3504.                 if(!$object2){
  3505.                     $path3 = "/".$folderName;
  3506.                     $object3 = DataObject::getByPath($path3);                
  3507.                     if(!$object3){
  3508.                         $createAssetFolder = DoService::createFolderByPath($path3);
  3509.                         $createAssetFolder = DoService::createFolderByPath($path2);
  3510.                         $createAssetFolder = DoService::createFolderByPath($path1);
  3511.                         $createAssetFolder = DoService::createFolderByPath($path);
  3512.                         $objParentId = $createAssetFolder->getId();
  3513.                     }else {
  3514.                         $createAssetFolder = DoService::createFolderByPath($path2);
  3515.                         $createAssetFolder = DoService::createFolderByPath($path1);
  3516.                         $createAssetFolder = DoService::createFolderByPath($path);
  3517.                         $objParentId = $createAssetFolder->getId();
  3518.                     }
  3520.                 }else {
  3521.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3522.                     $createAssetFolder = DoService::createFolderByPath($path);
  3523.                     $objParentId = $createAssetFolder->getId();
  3524.                 }
  3526.             } else {
  3527.                 $createAssetFolder = DoService::createFolderByPath($path);
  3528.                 $objParentId = $createAssetFolder->getId();
  3529.             }
  3530.         } else
  3531.         $objParentId = $object->getId();
  3533.         return $objParentId;
  3534.     }
  3536.     public function generateSlotObjFolder($folderName,$delivery_mode,$location_code){
  3538.         $yr = date("Y");
  3539.         $mt = date("M");
  3540.         $dy = date("d");
  3542.         $path = "/".$folderName."/".$delivery_mode."/".$location_code;//."/".$date.'-'.$location_code;
  3544.         $object = DataObject::getByPath($path);
  3545.         if(!$object){
  3546.             $path1 = "/".$folderName."/".$delivery_mode;//."/".$location_code."/".$date;
  3547.             $object1 = DataObject::getByPath($path1);
  3548.             if(!$object1){
  3549.                 $path2 = "/".$folderName;//."/".$delivery_mode."/".$location_code;
  3550.                 $object2 = DataObject::getByPath($path2);                
  3551.                 if(!$object2){
  3552.                     $createAssetFolder = DoService::createFolderByPath($path2);
  3553.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3554.                     $createAssetFolder = DoService::createFolderByPath($path);
  3555.                     $objParentId = $createAssetFolder->getId();
  3556.                 }else {
  3557.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3558.                     $createAssetFolder = DoService::createFolderByPath($path);
  3559.                     $objParentId = $createAssetFolder->getId();
  3560.                 }
  3561.             } else {
  3562.                 $createAssetFolder = DoService::createFolderByPath($path);
  3563.                 $objParentId = $createAssetFolder->getId();
  3564.             }
  3565.         } else
  3566.         $objParentId = $object->getId();
  3568.         return $objParentId;
  3569.     }
  3571.     public function getWeekDates($holidaysList, $todaydate, $delSlotTimesAvailibility){
  3572.         $jj=0; $weekdates = [];
  3574.         $slot_prepare_days = $delSlotTimesAvailibility['slot_prepare_days'];
  3575.         $slot_generate_days = $delSlotTimesAvailibility['slot_generate_days'];
  3576.         $saturday_slot_availability = $delSlotTimesAvailibility['saturday_slot_availability'];
  3577.         $sunday_slot_availability = $delSlotTimesAvailibility['sunday_slot_availability'];
  3579.         $todaydate = date('Y-m-d', strtotime($todaydate . ' +'.$slot_prepare_days.' day'));
  3581.         $totDays = $slot_generate_days+7;
  3583.         for($ii=1; $ii<$totDays; $ii++)
  3584.         {
  3585.             if($jj >= $slot_generate_days) break;
  3586.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3588.                 $weekDay = date('w', strtotime($todaydate));
  3589.                 if(($weekDay == 0 && $sunday_slot_availability == 'Yes') || ($weekDay == 6 && $saturday_slot_availability == 'Yes') || !in_array($weekDay, [0,6]))
  3590.                 {
  3591.                     $weekdates[] = $todaydate;
  3592.                     $jj=$jj+1;
  3593.                 }
  3594.             }
  3595.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3596.         }
  3598.         // echo '<pre>'; print_r($weekdates); die;
  3600.         return $weekdates;
  3601.     }
  3603.     public function getSettingInfo($api_log_info='')
  3604.     {
  3605.         $start_method_log_info = "Setting info Method";
  3606.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Started - ".$start_method_log_info:"Started - ".$start_method_log_info;
  3607.         $log_data = $api_log_method_info;
  3608.         SELF::createApiLog($log_data);
  3610.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | ".$start_method_log_info:$start_method_log_info;
  3612.         /*------ Get Settings Class data --------*/
  3613.         $dbConnection = \Pimcore\Db::get();
  3614.         $settingsClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Settings' ");
  3615.         $settingsObject = "object_".$settingsClassId;
  3616.         
  3617.         $log_data = $api_log_method_info." | settingsObject:".json_encode($settingsObject);
  3618.         SELF::createApiLog($log_data);
  3619.         
  3620.         $settingsId = $dbConnection->fetchOne(" select * from ".$settingsObject." WHERE setting_flag = 1");
  3621.         
  3622.         $log_data = $api_log_method_info." | settingsId:".json_encode($settingsId);
  3623.         SELF::createApiLog($log_data);
  3624.         /*----- End of Get Settings Class data ---------*/
  3626.         /*--------------- Settings info ----------------*/
  3627.         $settingsInfo = DataObject\Settings::getById($settingsId);
  3628.         
  3629.         $log_data = $api_log_method_info." | settingsInfo:".json_encode($settingsInfo);
  3630.         SELF::createApiLog($log_data);
  3632.         $settingDataId = $settingsInfo->getId();
  3633.         $setting_deliveryModes = $settingsInfo->getdelivery_modes();
  3634.         $setting_slot_time_flag = (!empty($settingsInfo->getslottime()))?$settingsInfo->getslottime():"18:00";
  3636.         $stg_deliveryslot_config_is_upcountry_configuration_applicable = ($settingsInfo->getdeliveryslot_config_is_upcountry_configuration_applicable())?$settingsInfo->getdeliveryslot_config_is_upcountry_configuration_applicable():'No';
  3638.         $stg_deliveryslot_config_is_darkstore_configuration_applicable = ($settingsInfo->getdeliveryslot_config_is_darkstore_configuration_applicable())?$settingsInfo->getdeliveryslot_config_is_darkstore_configuration_applicable():'No';
  3640.         $stg_delslot_normalloc_morethan_fromtime = ($settingsInfo->getdelslot_normalloc_morethan_fromtime())?$settingsInfo->getdelslot_normalloc_morethan_fromtime():"00:00";
  3641.         $stg_delslot_normalloc_lessthaneq_totime = ($settingsInfo->getdelslot_normalloc_lessthaneq_totime())?$settingsInfo->getdelslot_normalloc_lessthaneq_totime():"18:00";
  3642.         $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;
  3643.         $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;
  3645.         $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;
  3647.         $stg_delslot_upcountryloc_morethan_fromtime = ($settingsInfo->getdelslot_upcountryloc_morethan_fromtime())?$settingsInfo->getdelslot_upcountryloc_morethan_fromtime():"00:00";
  3648.         $stg_delslot_upcountryloc_lessthaneq_totime = ($settingsInfo->getdelslot_upcountryloc_lessthaneq_totime())?$settingsInfo->getdelslot_upcountryloc_lessthaneq_totime():"11:00";
  3649.         $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;
  3650.         $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;
  3652.         $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;
  3654.         $stg_delslot_darkstoreloc_morethan_fromtime = ($settingsInfo->getdelslot_darkstoreloc_morethan_fromtime())?$settingsInfo->getdelslot_darkstoreloc_morethan_fromtime():"00:00";
  3655.         $stg_delslot_darkstoreloc_lessthaneq_totime = ($settingsInfo->getdelslot_darkstoreloc_lessthaneq_totime())?$settingsInfo->getdelslot_darkstoreloc_lessthaneq_totime():"11:00";
  3656.         $stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays = $settingsInfo->getdelslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays();//($settingsInfo->getdelslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays())?$settingsInfo->getdelslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays():4;
  3657.         $stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays = ($settingsInfo->getdelslot_darkstoreloc_after_totime_extra_generate_slotdays())?$settingsInfo->getdelslot_darkstoreloc_after_totime_extra_generate_slotdays():5;
  3659.         $stg_darkstoreloc_slot_generate_days = ($stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays>$stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays)?$stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays:$stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays;
  3661.         $stg_is_deliveryfee_config_applicable = $settingsInfo->getis_deliveryfee_config_applicable();
  3662.         $stg_deliveryfee_config = $settingsInfo->getdeliveryfee_config();
  3663.         $stg_deliveryfee_config = $settingsInfo->getdeliveryfee_config();
  3664.         $stg_deliveryfee_config_location_lessthan_charge = $settingsInfo->getdeliveryfee_config_location_lessthan_charge();
  3665.         $stg_deliveryfee_config_location_greaterthanequal_charge = $settingsInfo->getdeliveryfee_config_location_greaterthanequal_charge();
  3667.         $stg_deliveryfee_config_upcountry_lessthan_charge = $settingsInfo->getdeliveryfee_config_upcountry_lessthan_charge();
  3668.         $stg_deliveryfee_config_upcountry_greaterthanequal_charge = $settingsInfo->getdeliveryfee_config_upcountry_greaterthanequal_charge();
  3669.         /*----------- End of Settings Info -------------*/
  3671.         $settingsdata = ['settingDataId'=>$settingDataId,
  3672.                         'setting_deliveryModes'=>$setting_deliveryModes,
  3673.                         'setting_slot_time_flag'=>$setting_slot_time_flag,
  3674.                         'stg_deliveryslot_config_is_upcountry_configuration_applicable'=>$stg_deliveryslot_config_is_upcountry_configuration_applicable,
  3675.                         'stg_deliveryslot_config_is_darkstore_configuration_applicable'=>$stg_deliveryslot_config_is_darkstore_configuration_applicable,
  3676.                         'stg_delslot_normalloc_morethan_fromtime'=>$stg_delslot_normalloc_morethan_fromtime,
  3677.                         'stg_delslot_normalloc_lessthaneq_totime'=>$stg_delslot_normalloc_lessthaneq_totime,
  3678.                         'stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays,
  3679.                         'stg_delslot_normalloc_after_totime_extra_generate_slotdays'=>$stg_delslot_normalloc_after_totime_extra_generate_slotdays,
  3680.                         'stg_normalloc_slot_generate_days'=>$stg_normalloc_slot_generate_days,
  3681.                         'stg_delslot_upcountryloc_morethan_fromtime'=>$stg_delslot_upcountryloc_morethan_fromtime,
  3682.                         'stg_delslot_upcountryloc_lessthaneq_totime'=>$stg_delslot_upcountryloc_lessthaneq_totime,
  3683.                         'stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays,
  3684.                         'stg_delslot_upcountryloc_after_totime_extra_generate_slotdays'=>$stg_delslot_upcountryloc_after_totime_extra_generate_slotdays,
  3685.                         'stg_upcountryloc_slot_generate_days'=>$stg_upcountryloc_slot_generate_days,
  3686.                         'stg_is_deliveryfee_config_applicable'=>$stg_is_deliveryfee_config_applicable,
  3687.                         'stg_deliveryfee_config'=>$stg_deliveryfee_config,
  3688.                         'stg_deliveryfee_config_location_lessthan_charge'=>$stg_deliveryfee_config_location_lessthan_charge,
  3689.                         'stg_deliveryfee_config_location_greaterthanequal_charge'=>$stg_deliveryfee_config_location_greaterthanequal_charge,
  3690.                         'stg_deliveryfee_config_upcountry_lessthan_charge'=>$stg_deliveryfee_config_upcountry_lessthan_charge,
  3691.                         'stg_deliveryfee_config_upcountry_greaterthanequal_charge'=>$stg_deliveryfee_config_upcountry_greaterthanequal_charge,
  3692.                         'stg_delslot_darkstoreloc_morethan_fromtime'=>$stg_delslot_darkstoreloc_morethan_fromtime,
  3693.                         'stg_delslot_darkstoreloc_lessthaneq_totime'=>$stg_delslot_darkstoreloc_lessthaneq_totime,
  3694.                         'stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays,
  3695.                         'stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays'=>$stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays,
  3696.                         'stg_darkstoreloc_slot_generate_days'=>$stg_darkstoreloc_slot_generate_days,
  3697.                         ];
  3698.         
  3700.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Ended - ".$start_method_log_info:"Ended - ".$start_method_log_info;
  3701.         $log_data = $api_log_method_info." | settingsdata:".json_encode($settingsdata);
  3702.         SELF::createApiLog($log_data);
  3703.         
  3704.         return $settingsdata;
  3705.     }
  3707.     function getDatesFromRange($start, $end, $dateformat="Y-m-d"){
  3708.         $dates = array($start);
  3709.         while(end($dates) < $end){
  3710.             $dates[] = date($dateformat, strtotime(end($dates).' +1 day'));
  3711.         }
  3712.         return $dates;
  3713.     }
  3715.     public function getSlotTimeDates($slot_generate_days, $todaydate){
  3716.         $jj=0; $weekdates = [];
  3718.         for($ii=1; $ii<15; $ii++)
  3719.         {
  3720.             if($jj >= 7) break;
  3721.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3722.                 $weekdates[] = $todaydate;
  3723.                 $jj=$jj+1;
  3724.             }
  3725.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3726.         }
  3728.         // echo '<pre>'; print_r($weekdates); die;
  3730.         return $weekdates;
  3731.     }
  3733.     public function getWorkingDate($slot_generate_days, $todaydate){
  3734.         $jj=0; $weekdates = [];
  3736.         for($ii=1; $ii<$slot_generate_days; $ii++)
  3737.         {
  3738.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3739.                 $weekdates[] = $todaydate;
  3740.                 $jj=$jj+1;
  3741.             }
  3742.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3743.         }
  3745.         // echo '<pre>'; print_r($weekdates); die;
  3747.         return $weekdates;
  3748.     }
  3750.     public function createApiLog($content)
  3751.     {
  3752.         $file = '../var/log/slot-api-log_'.date("Y-m-d").'.txt';
  3753.         // chmod($file, 0755);
  3755.         // if(!is_file($file)){
  3756.             // $contents = 'This is a test!';           // Some simple example content.
  3757.             // file_put_contents($file, $content);     // Save our content to the file.
  3758.             file_put_contents($file, date("Y-m-d H:i:s")." | ".$content."\n", FILE_APPEND);
  3759.             chmod($file, 0755);
  3760.         // }
  3761.     }
  3762.     /*----------------------- End of Sub methods -----------------------*/
  3764.    /*------------------------------ Manufacture Related APIs -------------------------*/
  3765.     /**
  3766.      * @param Request $request
  3767.      * 
  3768.      * @Route("/manufacturers/{skucode?}")
  3769.      * 
  3770.      * @return Response
  3771.      * 
  3772.      */
  3773.     public function manufacturersAction($skucode='')
  3774.     {
  3775.        $api_log_info = "API:Get Manufacturers List with or without skucode - ".date("YmdHis")." ".time();
  3776.        $log_data = "Started - ".$api_log_info;
  3777.        SELF::createApiLog($log_data);
  3779.        $data = SELF::verifyauthToken($api_log_info);
  3781.        $log_data = $api_log_info." | data:".json_encode($data);
  3782.        SELF::createApiLog($log_data);
  3784.        if($data == "No data found")
  3785.        {
  3786.             $log_data = $api_log_info." | skucode:".json_encode($skucode);
  3787.             SELF::createApiLog($log_data);
  3788.     
  3789.             $entries = new DataObject\Manufacture\Listing();
  3791.             $whr_condition = " msku_code!= '' ";
  3792.             if($skucode != '')
  3793.             $whr_condition .= " AND msku_code= '".$skucode."' ";
  3794.             
  3795.             $entries->setCondition($whr_condition);
  3796.             $entries->load();
  3798.             $log_data = $api_log_info." | Manufacturers entries count :".json_encode(count($entries));
  3799.             SELF::createApiLog($log_data);
  3801.             $data = (count($entries)>0)?array():"No data found";
  3803.             foreach($entries as $key => $entrie){
  3805.                 $log_data = $api_log_info." | Manufacture key :".json_encode($key)." | Manufacture entrie :".json_encode($entrie);
  3806.                 SELF::createApiLog($log_data);
  3808.                 if($skucode) {
  3809.                     $data = array("Id" => $entrie->getId(),
  3810.                         "msku_code" => $entrie->getmsku_code(),
  3811.                         "sku_name" => $entrie->getsku_name(),
  3812.                         "primary_barcode" => $entrie->getprimary_barcode(),
  3813.                         "manufacture_details" => $entrie->getmanufacture_details(),
  3814.                     );
  3815.                 } else {
  3816.                     $data[] = array("Id" => $entrie->getId(),
  3817.                         "msku_code" => $entrie->getmsku_code(),
  3818.                         "sku_name" => $entrie->getsku_name(),
  3819.                         "primary_barcode" => $entrie->getprimary_barcode(),
  3820.                         "manufacture_details" => $entrie->getmanufacture_details(),
  3821.                     );
  3822.                 }
  3824.                 $log_data = $api_log_info." | data :".json_encode($data);
  3825.                 SELF::createApiLog($log_data);
  3826.             }
  3827.        }
  3829.        $return_data = ["success" => true, "data" => $data];
  3831.        $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  3832.        SELF::createApiLog($log_data);
  3833.        
  3834.        return $this->json(["success" => true, "data" => $data]);
  3835.        
  3836.     }
  3837.    /*------------------------------ End of Manufacture Related APIs -------------------------*/
  3838.     
  3839. }