src/Controller/DeliveryslotapiController.php line 2862

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.     public function __construct()
  20.     {
  21.         header('X-Content-Type-Options: nosniff');
  22.         header("X-Frame-Options: SAMEORIGIN");
  23.         header("Content-Security-Policy: default-src 'self';script-src 'self'");
  24.         header("Server: Ubuntu");
  26.         $origin = $_SERVER['HTTP_ORIGIN'] ?? '';
  27.  
  28.         if (preg_match('/^https:\/\/([a-z0-9-]+\.)*itcstore\.in$/i', $origin)) {
  29.             header("Access-Control-Allow-Origin: $origin");
  30.             header("Access-Control-Allow-Methods: GET, POST");
  31.             header("Access-Control-Allow-Headers: X-Requested-With");
  32.         }
  34.     }
  35.     /**
  36.      * @Route("/holidays/getlist")
  37.      */
  38.     public function getlistAction()
  39.     {
  40.         $api_log_info = "API:Get All Holidays - ".date("YmdHis")." ".time();
  41.         $log_data = "Started - ".$api_log_info;
  42.         SELF::createApiLog($log_data);
  44.         $holidaysList = DataObject\Holidays::getList();
  45.         $holidaysList->load();
  46.         
  47.         $log_data = $api_log_info." | holidaysList Count:".json_encode(count($holidaysList));
  48.         SELF::createApiLog($log_data);
  50.         $message = SELF::verifyauthToken($api_log_info);
  51.         $log_data = $api_log_info." | message:".json_encode($message);
  52.         SELF::createApiLog($log_data);
  55.         $data = $message;
  56.         if($message == "No data found")
  57.         {
  58.             if(count($holidaysList) > 0){
  59.                 foreach ($holidaysList as $key => $holidayInfo) {  
  61.                     $log_data = $api_log_info." | holidayInfo:".json_encode($holidayInfo);
  62.                     SELF::createApiLog($log_data);
  63.                     
  64.                     $location_codes = $holidayInfo->getlocation_code();
  65.                     $loc_name = '';
  67.                     $log_data = $api_log_info." | location_codes:".json_encode($location_codes);
  68.                     SELF::createApiLog($log_data);
  70.                     foreach($location_codes as $location_code){
  71.                         $loc_name .= $location_code->getlocation_name().' ';
  72.                     }
  74.                     $log_data = $api_log_info." | loc_name:".json_encode($loc_name);
  75.                     SELF::createApiLog($log_data);
  77.                     $data[] = array(
  78.                         "name" => $holidayInfo->getname(),
  79.                         "loc_name" => $loc_name,
  80.                         "holidaydate" => $holidayInfo->getHolidaydate());
  82.                     $log_data = $api_log_info." | data:".json_encode($data);
  83.                     SELF::createApiLog($log_data);
  84.                 }
  85.             } else $data[] = [];
  86.         }
  87.         // return $slotsList;
  88.         $returndata = ["success" => true, "data" => $data];
  90.         $log_data = "Ended - ".$api_log_info." | returndata:".json_encode($returndata);
  91.         SELF::createApiLog($log_data);
  93.         return $this->json(["success" => true, "data" => $data]);
  94.     }
  96.     /*-------------------------------- Slots Related APIs ----------------------------*/
  98.     /**
  99.      * @Route("/deliveryslots/list")
  100.      */
  101.     public function listAction()
  102.     {
  103.         $api_log_info = "API:Get Delivery Slots based on Today and Current Time - ".date("YmdHis")." ".time();
  104.         $log_data = "Started - ".$api_log_info;
  105.         SELF::createApiLog($log_data);
  107.         $today_date = strtotime("Y-m-d");
  108.         $cur_time = date("H:i");
  110.         $log_data = $api_log_info." | today_date:".json_encode($today_date)." | cur_time:".json_encode($cur_time);
  111.         SELF::createApiLog($log_data);
  113.         $slotsList = DataObject\Slots::getList();
  114.         $slotsList->setCondition("slotdate >= ? AND prior_time >= ?",[$today_date, $cur_time]);
  115.         // $slotsList->setOffset(0);
  116.         $slotsList->setLimit(100);
  117.         $slotsList->setOrderKey("slotdate");
  118.         $slotsList->setOrder("desc");
  119.         $slotsList->load();
  121.         // $slotsList = DataObject\Slots::getList();
  122.         // $slotsList->setOffset(0);
  123.         // $slotsList->setLimit(10);
  124.         // $slotsList->load();
  126.         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  127.         SELF::createApiLog($log_data);
  129.         // if(count($slotsList) > 0){
  130.             foreach ($slotsList as $key => $slotInfo) {
  132.                 $log_data = $api_log_info." | slotInfo:".json_encode($slotInfo);
  133.                 SELF::createApiLog($log_data);
  135.                 // $location_code = $blog->getlocation_code()->getlocation_code();
  136.                 // $location_code = (!empty($slotInfo->getloc_id()) && $slotInfo->getloc_id())?$slotInfo->getloc_id()->getlocation_code():'';
  137.                 // $loc_name = (!empty($slotInfo->getloc_id()) && $slotInfo->getloc_id())?$slotInfo->getloc_id()->getlocation_name():'';
  139.                 $slotLocationData = DataObject\Locations::getById($slotInfo->getLoc_id());
  140.                 $loc_name = (!empty($slotLocationData) && $slotLocationData->getlocation_name())?$slotLocationData->getlocation_name():'';
  141.                 $location_code = (!empty($slotLocationData) && $slotLocationData->getlocation_code())?$slotLocationData->getlocation_code():'';
  143.                 // foreach($location_codes as $location_code){
  144.                 //     $loc_name = $location_code->getlocation_name();
  145.                 // }
  147.                 $log_data = $api_log_info." | location_code:".json_encode($location_code)." | loc_name:".json_encode($loc_name);
  148.                 SELF::createApiLog($log_data);
  150.                 $data[] = array(
  151.                     "slotId" => $slotInfo->getId(),
  152.                     "prior_time" => $slotInfo->getprior_time(),
  153.                     // "picking_time" => $slotInfo->getpicking_time(),
  154.                     "location_code" => $location_code,
  155.                     "loc_name" => $loc_name,
  156.                     // "charge" => $slotInfo->getcharge(),
  157.                     "slotdate" => $slotInfo->getslotdate(),
  158.                     "fromtime" => $slotInfo->getfromtime(),
  159.                     "totime" => $slotInfo->gettotime(),
  160.                     "maxorder" => $slotInfo->getmaxorder(),
  161.                     "ordercount" => $slotInfo->getordercount(),
  162.                     "delivery_mode" => $slotInfo->getdelivery_mode());
  163.                 
  164.                 $log_data = $api_log_info." | data:".json_encode($data);
  165.                 SELF::createApiLog($log_data);
  166.             }
  167.         // } else $data[] = [];
  168.         // return $slotsList;
  169.         $returnData = ["success" => true, "data" => $data];
  170.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  171.         SELF::createApiLog($log_data);
  172.         return $this->json(["success" => true, "data" => $data]);
  173.     }
  175.     /**
  176.      * @Route("/deliveryslots/saveslots")
  177.      */
  178.     public function saveslotsAction()
  179.     {
  181.         $api_log_info = "API:Generating / Saving Delivery Slots - ".date("YmdHis")." ".time();
  182.         $log_data = "Started - ".$api_log_info;
  183.         SELF::createApiLog($log_data);
  184.         /*--------------- Settings info ----------------*/
  185.         $settingsInfo = SELF::getSettingInfo($api_log_info);
  187.         $log_data = $api_log_info." | settingsInfo:".json_encode($settingsInfo);
  188.         SELF::createApiLog($log_data);
  189.         /*----------- End of Settings Info -------------*/
  190.         // echo 'settingsInfo:<pre>';
  191.         // echo $settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'];
  192.         // print_r($settingsInfo); die;
  194.         $locationsList = DataObject\Locations::getList();
  195.         $locationsList->load();
  197.         $log_data = $api_log_info." | locationsList count:".json_encode(count($locationsList));
  198.         SELF::createApiLog($log_data);
  200.         foreach($locationsList as $location)//Start of Locations Loop
  201.         {
  202.             $log_data = $api_log_info." | location:".json_encode($location);
  203.             SELF::createApiLog($log_data);
  205.             //echo "<br>Id:".$location->getId()."|Location Name:".$location->getLocation_name()."|Location Code:".$location->getLocation_code();
  206.             $location_id = $location->getId();
  208.             $locationName = $location->getLocation_name();
  209.             $locationCode = $location->getLocation_code();
  211.             /*------ Check Location is Up Country or not --------*/
  212.             $Is_location_up_country = (strpos(strtolower($locationName),"up country") || strpos(strtoupper($locationCode),"UPCTR"))?1:0;
  214.             $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);
  215.             SELF::createApiLog($log_data);
  217.             $holidaysList = DataObject\Holidays::getList();
  218.             $holidaysList->setCondition("location_code like '%,".$location_id.",%'");
  219.             $holidaysList->load();
  221.             // if(count($holidaysList) > 0)
  222.             // {
  223.                 $holidayDates = $rangeDates = [];
  224.                 foreach($holidaysList as $holiday)
  225.                 {
  226.                     $log_data = $api_log_info." | holiday:".json_encode($holiday);
  227.                     SELF::createApiLog($log_data);
  229.                     $holiday_locations_list = $holiday->getLocation_code();
  230.                     $holidaydate = $holiday->getHolidaydate();
  231.                     $holidayDate = date("Y-m-d", strtotime($holidaydate));
  233.                     $holidaysenddate = $holiday->getHolidaysenddate();
  235.                     $log_data = $api_log_info." | holiday_locations_list:".json_encode($holiday_locations_list)." | holidaydate:".json_encode($holidaydate)." | holidaysenddate:".json_encode($holidaysenddate);
  236.                     SELF::createApiLog($log_data);
  238.                     if(!empty($holidaysenddate) && $holidaysenddate){
  239.                         $holidaysenddate = date("Y-m-d", strtotime($holidaysenddate));
  240.                         $rangeDates = self::getDatesFromRange($holidayDate, $holidaysenddate);
  242.                         $log_data = $api_log_info." | rangeDates:".json_encode($rangeDates)." | holidaysenddate:".json_encode($holidaysenddate);
  243.                         SELF::createApiLog($log_data);
  245.                         foreach($rangeDates as $rangeDateInfo){
  247.                             $log_data = $api_log_info." | rangeDateInfo:".json_encode($rangeDateInfo);
  248.                             SELF::createApiLog($log_data);
  250.                             array_push($holidayDates,$rangeDateInfo);
  252.                             $log_data = $api_log_info." | holidayDates:".json_encode($holidayDates);
  253.                             SELF::createApiLog($log_data);
  254.                         }
  255.                     } else {
  256.                         array_push($holidayDates,$holidayDate);
  258.                         $log_data = $api_log_info." | holidayDate:".json_encode($holidayDate)." | holidayDates:".json_encode($holidayDates);
  259.                         SELF::createApiLog($log_data);
  260.                     }
  261.                 }
  262.                 // if(!empty($rangeDates)){
  263.                 //     echo '<pre>'; print_r($holidayDates); die;
  264.                 // }
  266.                 /*----------- Delivery Slot Times Loop Starts --------*/
  267.                 $deliveryslottimesList = DataObject\Deliveryslottimes::getList();
  268.                 $deliveryslottimesList->load();
  269.                 //echo '<br>deliveryslottimesList Count:'.count($deliveryslottimesList);
  271.                 $log_data = $api_log_info." | deliveryslottimesList Count:".json_encode(count($deliveryslottimesList));
  272.                 SELF::createApiLog($log_data);
  274.                 if(count($deliveryslottimesList)>0)
  275.                 {
  276.                     foreach($deliveryslottimesList as $deliveryslottimes)
  277.                     {
  278.                         $log_data = $api_log_info." | deliveryslottimes:".json_encode($deliveryslottimes);
  279.                         SELF::createApiLog($log_data);
  281.                         // echo '<pre>deliveryslottimes:'; print_r($deliveryslottimes); //die;
  283.                         $slot_prepare_days = ($deliveryslottimes->getprepare_days())?$deliveryslottimes->getprepare_days():0;
  284.                         $slot_generate_days = ($deliveryslottimes->getslot_generate_days())?$deliveryslottimes->getslot_generate_days():7;
  285.                         $saturday_slot_availability = ($deliveryslottimes->getsaturday_slot_availability())?$deliveryslottimes->getsaturday_slot_availability():'No';
  286.                         $sunday_slot_availability = ($deliveryslottimes->getsunday_slot_availability())?$deliveryslottimes->getsunday_slot_availability():'No';
  288.                         $slot_generate_days = $slot_generate_days+$settingsInfo['stg_normalloc_slot_generate_days']; 
  290.                         $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);
  291.                         SELF::createApiLog($log_data);
  293.                         /*--------------------- Up Country Configuration ------------------------*/
  294.                         $is_upcountry_configuration_applicable = ($deliveryslottimes->getis_upcountry_configuration_applicable())?$deliveryslottimes->getis_upcountry_configuration_applicable():'No';
  295.                         $slot_upcountry_prepare_days = ($deliveryslottimes->getupcountry_prepare_days())?$deliveryslottimes->getupcountry_prepare_days():0;
  296.                         $upcountry_slot_generate_days = ($deliveryslottimes->getupcountry_slot_generate_days())?$deliveryslottimes->getupcountry_slot_generate_days():7;
  297.                         $upcountry_saturday_slot_availability = ($deliveryslottimes->getupcountry_saturday_slot_availability())?$deliveryslottimes->getupcountry_saturday_slot_availability():'No';
  298.                         $upcountry_sunday_slot_availability = ($deliveryslottimes->getupcountry_sunday_slot_availability())?$deliveryslottimes->getupcountry_sunday_slot_availability():'No';
  300.                         $upcountry_slot_generate_days = $upcountry_slot_generate_days+$settingsInfo['stg_upcountryloc_slot_generate_days']; 
  302.                         $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);
  303.                         SELF::createApiLog($log_data);
  305.                         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)
  306.                             $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];
  307.                         else
  308.                             $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];
  310.                         $log_data = $api_log_info." | delSlotTimesAvailibility:".json_encode($delSlotTimesAvailibility);
  311.                         SELF::createApiLog($log_data);
  313.                         // echo '<pre>delSlotTimesAvailibility:'; print_r($delSlotTimesAvailibility); //die;
  315.                         $weekdates = self::getWeekDates($holidayDates, date("Y-m-d"), $delSlotTimesAvailibility);
  316.                         // echo '<pre>weekdates:'; print_r($weekdates);
  318.                         $log_data = $api_log_info." | weekdates:".json_encode($weekdates);
  319.                         SELF::createApiLog($log_data);
  321.                         foreach($weekdates as $weekdate)
  322.                         {
  323.                             $log_data = $api_log_info." | weekdate:".json_encode($weekdate);
  324.                             SELF::createApiLog($log_data);
  326.                             $slotsList = DataObject\Deliveryslotrules::getList();
  327.                             // $slotsList->setCondition("location_code like '%,".$location_id.",%'");
  328.                             $slotsList->setCondition("location_ids IS NOT NULL AND location_ids like '%,".$location_id.",%'");
  329.                             $slotsList->load();
  330.                             //echo '<br>slotsList Count:'.count($slotsList);
  332.                             $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  333.                             SELF::createApiLog($log_data);
  335.                             if(count($slotsList) > 0)
  336.                             {
  337.                                 foreach($slotsList as $slot)
  338.                                 {
  339.                                     $log_data = $api_log_info." | slot:".json_encode($slot);
  340.                                     SELF::createApiLog($log_data);
  342.                                     $prior_time = $slot->getprior_time();
  343.                                     $location_codes = $slot->getlocation_ids();//$slot->getlocation_code();
  344.                                     // $picking_time = $slot->getpicking_time();
  345.                                     $delivery_mode = $slot->getdelivery_mode();
  346.                                     // $charge = $slot->getcharge();
  347.                                     $fromtime = $slot->getfromtime();
  348.                                     $totime = $slot->gettotime();
  349.                                     $maxorder = $slot->getmaxorder();
  350.                                     // $ordercount = $slot->getordercount();
  351.                                     $date = $weekdate;//$slot->getslotdate();
  352.                                     $date2 = date("m/d/y", strtotime($date));
  353.                                     $dates = Carbon::createFromFormat('m/d/y', $date2);
  355.                                     $location_code_array = [];
  357.                                     // echo '<pre>location_codes Count:'.count($location_codes);
  359.                                     $log_data = $api_log_info." | location_codes:".json_encode($location_codes);
  360.                                     SELF::createApiLog($log_data);
  362.                                     if(!empty($location_codes))
  363.                                     {
  364.                                         foreach($location_codes as $location_id_info){//foreach($location_codes as $location_code){//Location Code loop Starts
  366.                                             $log_data = $api_log_info." | location_id_info:".json_encode($location_id_info);
  367.                                             SELF::createApiLog($log_data);
  369.                                             if($location_id == $location_id_info)//if($location_id == $location_code->getId())
  370.                                             {
  371.                                                 $log_data = $api_log_info." | location_id:".json_encode($location_id)." | location_id_info:".json_encode($location_id_info);
  372.                                                 SELF::createApiLog($log_data);
  373.                                                 // $location_code_array[] = DataObject\Locations::getById($location_code->getId());
  374.                                                 // $location_code_id = DataObject\Locations::getById($location_code->getId());
  375.     
  376.                                                 // $loc_id = $location_code->getId();
  377.     
  378.                                                 $location_code_array[] = DataObject\Locations::getById($location_id_info);
  379.                                                 $location_code_id = DataObject\Locations::getById($location_id_info);
  381.                                                 $log_data = $api_log_info." | location_code_id:".json_encode($location_code_id);
  382.                                                 SELF::createApiLog($log_data);
  383.     
  384.                                                 $loc_id = $location_id_info;
  385.     
  386.                                                 /*----------- Delivery Slot Times Loop Starts --------*/
  387.                                                 // $deliveryslottimesList = DataObject\Deliveryslottimes::getList();
  388.                                                 // $deliveryslottimesList->load();
  389.                                                 // //echo '<br>deliveryslottimesList Count:'.count($deliveryslottimesList);
  390.                                                 // if(count($deliveryslottimesList)>0)
  391.                                                 // {
  392.                                                 //     foreach($deliveryslottimesList as $deliveryslottimes)
  393.                                                 //     {
  394.                                                         /*------------ Checking the slot data -------------*/
  395.                                                         $slotCheck = 1;
  396.                                                         $today_date = date("Y-m-d", strtotime($weekdate));
  397.                                                         $cur_time = $prior_time;
  398.     
  399.                                                         $checkDataList = DataObject\Slots::getList();
  400.     
  401.                                                         if ($checkDataList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  402.                                                             $checkDataList->filterBySlotdate($today_date, '=');
  403.                                                         }
  404.     
  405.                                                         if ($checkDataList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  406.                                                             $checkDataList->filterByprior_time($cur_time, '=');
  407.                                                         }
  408.     
  409.                                                         if ($checkDataList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  410.                                                             $checkDataList->filterBydelivery_mode($delivery_mode, '=');
  411.                                                         }
  412.                                                         // $checkDataList->setCondition("loc_id__id = ".$loc_id);
  413.                                                         // $checkDataList->setCondition("delivery_mode = '".$delivery_mode."' ");
  414.     
  415.                                                         $checkDataList->setLimit(100);
  416.                                                         $checkDataList->setOrderKey("slotdate");
  417.                                                         $checkDataList->setOrder("asc");
  418.                                                         $checkDataList->load();
  419.                                                         //echo '<br>checkDataList Count:'.count($checkDataList);
  420.     
  421.                                                         $checkData_loc_valid = 0; $checkData_locs = [];
  423.                                                         $log_data = $api_log_info." | checkDataList count:".json_encode(count($checkDataList));
  424.                                                         SELF::createApiLog($log_data);
  425.                                                         
  426.                                                         if(count($checkDataList) > 0)
  427.                                                         {
  428.                                                             foreach($checkDataList as $checkData)
  429.                                                             {
  430.                                                                 $log_data = $api_log_info." | checkData:".json_encode($checkData);
  431.                                                                 SELF::createApiLog($log_data);
  432.                                                         
  433.                                                                 // $checkData_locData = $checkData->getloc_id();
  434.                                                                 // $checkData_locId = $checkData_locData->getId();
  435.                                                                 $checkData_locId = $checkData->getloc_id();
  436.                                                                 array_push($checkData_locs, $checkData_locId);
  438.                                                                 $log_data = $api_log_info." | checkData_locId:".json_encode($checkData_locId)." | checkData_locs:".json_encode($checkData_locs);
  439.                                                                 SELF::createApiLog($log_data);
  440.                                                             }
  441.                                                         }
  442.                                                         $checkData_loc_valid = (empty($checkData_locs) || (!empty($checkData_locs) && !in_array($loc_id, $checkData_locs)) || count($checkDataList) <= 0)?1:0;
  444.                                                         $log_data = $api_log_info." | checkData_loc_valid:".json_encode($checkData_loc_valid);
  445.                                                         SELF::createApiLog($log_data);
  446.     
  447.                                                         // echo '<br>checkData_locId:'.$checkData_locId;
  448.                                                         // echo '<pre>checkData_locs:';
  449.                                                         // print_r($checkData_locs);
  450.                                                         // echo '<br>checkData_loc_valid:'.$checkData_loc_valid;
  451.                                                         /*------------ End of Checking the slot data -------------*/
  452.     
  453.                                                         if($checkData_loc_valid == 1){
  454.                                                             // $generateObjFolderId = self::generateSlotObjFolder('Slots',$delivery_mode,$loc_id);
  455.     
  456.                                                             $createAssetFolder = DoService::createFolderByPath('Slots');
  457.                                                             $objParentId = $createAssetFolder->getId();
  458.     
  459.                                                             // $holidayObjectName = $location_code.'-'.$name;
  460.                                                             $slotObjectName = $weekdate.'-'.$loc_id.'-'.$slot->getId().'-'.$deliveryslottimes->getId().'-'.time();
  461.     
  462.                                                             $slotObject = new DataObject\Slots(); 
  463.                                                             $slotObject->setKey(\Pimcore\Model\Element\Service::getValidKey($slotObjectName, 'object'));
  464.                                                             $slotObject->setParentId($objParentId);
  465.                                                             $slotObject->setPrior_time($prior_time);
  466.                                                             // $slotObject->setPicking_time($picking_time);
  467.                                                             $slotObject->setDelivery_mode($delivery_mode);
  468.                                                             // $slotObject->setSlotdate($date2);
  469.                                                             $slotObject->setSlotdate($dates);
  470.                                                             $slotObject->setfromtime($fromtime);
  471.                                                             $slotObject->settotime($totime);
  472.                                                             $slotObject->setmaxorder($maxorder);
  473.     
  474.                                                             // $slotObject->setLocation_code($location_code_array);
  475.     
  476.                                                             // $slotObject->setCharge($charge);
  477.                                                             $slotObject->setdeliveryslottime_id(DataObject\Deliveryslottimes::getById($deliveryslottimes->getId()));
  478.                                                             // $slotObject->setloc_id(DataObject\Locations::getById($location_code->getId()));
  479.                                                             // $slotObject->setloc_id(DataObject\Locations::getById($location_id_info));
  480.                                                             $slotObject->setloc_id($location_id_info);
  481.     
  482.                                                             $slotObject->setPublished(true);
  483.                                                             $slotObject->save();
  485.                                                             $log_data = $api_log_info." | objParentId :".json_encode($objParentId)." | slotObjectName :".json_encode($slotObjectName)." | save slot : success";
  486.                                                             SELF::createApiLog($log_data);
  487.                                                         }
  488.                                                 //     }
  489.                                                 // }
  490.                                             }
  491.                                             /*---------- Delivery Slot Time loop ends ------------*/
  492.                                         }//Location Code loop ends
  493.                                     }
  494.                                 }
  495.                             }
  496.                         }
  497.                     }
  498.                 }
  499.             // }
  501.         }//End of Locations Loop
  502.         
  503.         $log_data = "Ended - ".$api_log_info." | data : Slot Created for one week Successfully'";
  504.         SELF::createApiLog($log_data);
  506.         return $this->json(["success" => true, "data" => 'Slot Created for one week Successfully']);
  507.     }
  509.     /**
  510.      * @Route("deliveryslots/updateslotordercount", methods={"POST"})
  511.      */
  512.     public function updateslotordercountAction(Request $request)
  513.     {
  514.         $api_log_info = "API:Update Delivery Slot Order Count based on slotId - ".date("YmdHis")." ".time();
  515.         $log_data = "Started - ".$api_log_info;
  516.         SELF::createApiLog($log_data);
  518.         $message = SELF::verifyauthToken($api_log_info);
  519.         $log_data = $api_log_info." | message:".json_encode($message);
  520.         SELF::createApiLog($log_data);
  522.         $data = [];
  523.         if($message == "No data found")
  524.         {
  525.             $slotId = $request->get('slotId');
  526.             $ordercount = $request->get('ordercount');
  528.             $log_data = $api_log_info." | slotId:".json_encode($slotId)." | ordercount:".json_encode($ordercount);
  529.             SELF::createApiLog($log_data);
  531.             if($slotId == "" || $ordercount == "")
  532.             {
  533.                 $data = "slotId and ordercount are mandatory!";
  534.                 $log_data = $api_log_info." | data:".json_encode($data);
  535.                 SELF::createApiLog($log_data);
  536.             } else 
  537.             {
  538.                 $slotruleObject = DataObject\Slots::getById($slotId);
  539.                 $log_data = $api_log_info." | slotruleObject:".json_encode($slotruleObject);
  540.                 SELF::createApiLog($log_data);
  542.                 if(!empty($slotruleObject) && $slotruleObject->getId()){
  543.                     $slotruleObject->setordercount($ordercount);
  544.                     $slotruleObject->save();
  546.                     $data = "Slot Updated Successfully!";
  547.                     $log_data = $api_log_info." | data:".json_encode($data);
  548.                     SELF::createApiLog($log_data);
  549.                 } else {
  550.                     $data = "This Slot Id ".$slotId." is not existed, Please try with valid Slot Id";
  551.                     $log_data = $api_log_info." | data:".json_encode($data);
  552.                     SELF::createApiLog($log_data);
  553.                 }
  554.             }
  555.         }else $data[] = ['message'=>$message];
  556.         $data = (empty($data))?$message:$data;
  558.         $returnData = ["success" => true, "data" => $data];
  559.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  560.         SELF::createApiLog($log_data);
  562.         return $this->json(["success" => true, "data" => $message]);
  563.     }
  565.     /**
  566.      * @Route("/deliveryslots/getSlot/{id}")
  567.      */
  568.     public function getSlot($id)
  569.     {
  570.         $api_log_info = "API:Slot Info by Slot ID | ID:".$id." - ".date("YmdHis")." ".time();
  571.         $log_data = "Started - ".$api_log_info;
  572.         SELF::createApiLog($log_data);
  574.         $message = SELF::verifyauthToken($api_log_info);
  575.         $log_data = $api_log_info." | message:".json_encode($message);
  576.         SELF::createApiLog($log_data);
  578.         $data = [];
  579.         if($message == "No data found")
  580.         {
  581.             $slot = DataObject\Slots::getById($id);  
  582.         
  583.             $log_data = $api_log_info." | slot:".json_encode($slot);
  584.             SELF::createApiLog($log_data);
  586.             if(isset($slot) && $slot->getId() != ''){
  587.                 
  588.                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  589.                 $loc_name = (!empty($slotLocationData) && $slotLocationData->getlocation_name())?$slotLocationData->getlocation_name():'';
  590.                 $loc_code = (!empty($slotLocationData) && $slotLocationData->getlocation_code())?$slotLocationData->getlocation_code():'';
  592.                 $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData)." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  593.                 SELF::createApiLog($log_data);
  595.                 $data = array(
  596.                     "prior_time" => $slot->getprior_time(),
  597.                     // "picking_time" => $slot->getpicking_time(),
  598.                     // "charge" => $slot->getcharge(),
  599.                     "slotdate" => date("Y-m-d", strtotime($slot->getslotdate())),//$slot->getslotdate(),
  600.                     "loc_code" => $loc_code,
  601.                     "loc_name" => $loc_name,
  602.                     "fromtime" => $slot->getfromtime(),
  603.                     "totime" => $slot->gettotime(),
  604.                     "maxorder" => $slot->getmaxorder(),
  605.                     "ordercount" => $slot->getordercount(),
  606.                     "delivery_mode" => $slot->getdelivery_mode());
  608.                 $log_data = $api_log_info." | data:".json_encode($data);
  609.                 SELF::createApiLog($log_data);
  611.             } else {
  612.                 $data = "No data found";
  613.                 $log_data = $api_log_info." | data:".json_encode($data);
  614.                 SELF::createApiLog($log_data);
  615.             }   
  616.         }else $data[] = ['message'=>$message];
  617.         $data = (empty($data))?$message:$data;  
  618.         
  619.         $returnData = ["success" => true, "data" => $data];
  620.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  621.         SELF::createApiLog($log_data);
  622.         
  623.         // return $slotsList;
  624.         return $this->json(["success" => true, "data" => $data]);
  625.     }
  627.     /**
  628.      * @Route("/deliveryslots/getStoreslot/{id}")
  629.      */
  631.     public function getStoreslot($id)
  632.     {
  633.         $api_log_info = "API:Get Delivery Slots based on Location Code for Today and Time only | ID:".$id." - ".date("YmdHis")." ".time();
  634.         $log_data = "Started - ".$api_log_info;
  635.         SELF::createApiLog($log_data);
  637.         $message = SELF::verifyauthToken($api_log_info);
  638.         $log_data = $api_log_info." | message:".json_encode($message);
  639.         SELF::createApiLog($log_data);
  641.         $data = $message;
  642.         if($message == "No data found")
  643.         {
  644.             $data ="No data found";
  645.             if($id == "")
  646.             {
  647.                 $data ="Location Code is mandatory!";
  648.                 $log_data = $api_log_info." | data:".json_encode($data);
  649.                 SELF::createApiLog($log_data);
  651.             } else 
  652.             {
  653.                 /*---- Check Location by Location Code ---------*/
  654.                 $locData = DataObject\Locations::getBylocation_code($id, 1);
  656.                 $log_data = $api_log_info." | locData:".json_encode($locData);
  657.                 SELF::createApiLog($log_data);
  659.                 if(empty($locData) || empty($locData->getId()))
  660.                 {
  661.                     $data = "Location is not exited, please try with valid location code!";
  662.                     $log_data = $api_log_info." | data:".json_encode($data);
  663.                     SELF::createApiLog($log_data);
  664.                 } else {
  665.                     $loc_id = $locData->getId();
  666.                     $today_date = date("Y-m-d");//"2024-01-03";//
  668.                     $cur_time = date("H:i");
  670.                     $log_data = $api_log_info." | loc_id:".json_encode($loc_id)." | today_date:".json_encode($today_date)." | cur_time:".json_encode($cur_time);
  671.                     SELF::createApiLog($log_data);
  673.                     $slotsList = DataObject\Slots::getList();
  675.                     if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  676.                         $slotsList->filterBySlotdate($today_date, '=');
  677.                     }
  679.                     if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  680.                         $slotsList->filterByprior_time($cur_time, '>=');
  681.                     }
  682.                     $slotsList->setCondition("loc_id = ".$loc_id);
  684.                     $slotsList->setLimit(100);
  685.                     $slotsList->setOrderKey("slotdate");
  686.                     $slotsList->setOrder("asc");
  687.                     $slotsList->load();
  689.                     $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  690.                     SELF::createApiLog($log_data);
  692.                     $data = [];
  694.                     if(count($slotsList) > 0){
  695.                         foreach ($slotsList as $key => $slotInfo) {
  697.                             $log_data = $api_log_info." | slotInfo:".json_encode($slotInfo);
  698.                             SELF::createApiLog($log_data);
  700.                             $slotLocationData = DataObject\Locations::getById($slotInfo->getLoc_id());
  702.                             $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData);
  703.                             SELF::createApiLog($log_data);
  705.                             $loc_name = $slotLocationData->getlocation_name();
  706.                             $loc_code = $slotLocationData->getlocation_code();
  708.                             $log_data = $api_log_info." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  709.                             SELF::createApiLog($log_data);
  710.                 
  711.                             // if($loc_name != 0 && $loc_name == $id){
  712.                             // if(!empty($loc_codes) && in_array($id, $loc_codes)){//&& $id!= '' 
  713.                                 // if(!empty($blog->getloc_id()) && $blog->getloc_id()->getlocation_code() == $id){//&& $id!= '' 
  714.                                 $data[] = array(
  715.                                     "slotId" => $slotInfo->getId(),
  716.                                     "prior_time" => $slotInfo->getprior_time(),
  717.                                     // "picking_time" => $slotInfo->getpicking_time(),
  718.                                     "location_code" => $loc_code,
  719.                                     "loc_name" => $loc_name,
  720.                                     // "charge" => $slotInfo->getcharge(),
  721.                                     "slotdate" => $slotInfo->getslotdate(),
  722.                                     "fromtime" => $slotInfo->getfromtime(),
  723.                                     "totime" => $slotInfo->gettotime(),
  724.                                     "maxorder" => $slotInfo->getmaxorder(),
  725.                                     "ordercount" => $slotInfo->getordercount(),
  726.                                     "delivery_mode" => $slotInfo->getdelivery_mode());
  728.                                 $log_data = $api_log_info." | data:".json_encode($data);
  729.                                 SELF::createApiLog($log_data);
  730.                             //}
  731.                         }
  732.                     } else $data = "No data found";
  733.                 }
  734.             }
  735.         }
  737.         $return_data = ["success" => true, "data" => $data];
  739.         $log_data = $api_log_info." | return_data:".json_encode($return_data);
  740.         SELF::createApiLog($log_data);
  741.         
  742.         return $this->json(["success" => true, "data" => $data]);
  743.     }
  745.     /**
  746.      * @Route("/deliveryslottime/gelocslottimes/{locCode}")
  747.      */
  748.     public function gelocslottimesAction($locCode)
  749.     {
  750.         date_default_timezone_set('Asia/Kolkata');
  752.         $api_log_info = "API:Retriving Delivery Slots by Location Code | locCode:".$locCode." - ".date("YmdHis")." ".time();
  753.         $log_data = "Started - ".$api_log_info;
  754.         SELF::createApiLog($log_data);
  756.         $message = SELF::verifyauthToken($api_log_info);
  757.         $log_data = $api_log_info." | message:".json_encode($message);
  758.         SELF::createApiLog($log_data);
  760.         $Is_location_up_country = $is_upcountry_configuration_applicable = '';
  762.         if($message == "No data found")
  763.         {
  764.             $today_date = date("Y-m-d");
  765.             $tomorrow_date = date('Y-m-d', strtotime($today_date . ' +1 day'));
  766.             $dates_list = array($today_date, $tomorrow_date);
  767.             
  768.             $log_data = $api_log_info." | dates_list:".json_encode($dates_list);
  769.             SELF::createApiLog($log_data);
  771.             /*---- Check Location by Location Code ---------*/
  772.             $locationData = DataObject\Locations::getBylocation_code($locCode, 1);
  773.             
  774.             $log_data = $api_log_info." | locationData:".json_encode($locationData);
  775.             SELF::createApiLog($log_data);
  777.             /*--------------- Settings info ----------------*/
  778.             $settingsInfo = SELF::getSettingInfo($api_log_info);
  780.             $log_data = $api_log_info." | settingsInfo:".json_encode($settingsInfo);
  781.             SELF::createApiLog($log_data);
  782.             /*----------- End of Settings Info -------------*/
  783.              /*--------- Getting Delivery Modes settings ----------*/
  784.             $setting_slot_time_flag = $settingsInfo['setting_slot_time_flag'];
  785.             $setting_deliveryModes = $settingsInfo['setting_deliveryModes'];
  786.             $settingDataId = $settingsInfo['settingDataId'];
  787.             // echo 'settingsInfo:<pre>';
  788.             // print_r($settingsInfo); die;
  789.             
  790.             $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);
  791.             SELF::createApiLog($log_data);
  793.             if(!empty($locationData) && !empty($locationData->getId()))
  794.             {
  795.                 $parentLoc_id = $locationData->getId();
  796.                 $parentLocationName = $locationData->getLocation_name();
  797.                 $parentLocationCode = $locationData->getLocation_code();
  798.                 $fastDelivery = $locationData->getfastDeliveryAvailable();
  799.                 $location_type = $locationData->getlocation_type();
  801.                 /*------ Check Location is Up Country or not --------*/
  802.                 $Is_location_up_country = (strpos(strtolower($parentLocationName),"up country") || strpos(strtoupper($parentLocationCode),"UPCTR"))?1:0;
  804.                 $log_data = $api_log_info." | parentLoc_id:".json_encode($parentLoc_id)."| parentLocationName:".json_encode($parentLocationName)."| parentLocationCode:".json_encode($parentLocationCode);
  805.                 SELF::createApiLog($log_data);
  807.                 //------ get holidays list ------------//
  808.                 $holidaysList = DataObject\Holidays::getList();
  809.                 $holidaysList->setCondition("location_code like '%,".$parentLoc_id.",%'");
  810.                 $holidaysList->load();
  811.                 
  812.                 $holidayDates = [];
  813.                 foreach($holidaysList as $holiday)
  814.                 {
  815.                     $log_data = $api_log_info." | holiday:".json_encode($holiday);
  816.                     SELF::createApiLog($log_data);
  818.                     $holiday_locations_list = $holiday->getLocation_code();
  819.                     $holidaydate = $holiday->getHolidaydate();
  820.                     $holidayDate = date("Y-m-d", strtotime($holidaydate));
  822.                     $log_data = $api_log_info." | holiday_locations_list:".json_encode($holiday_locations_list)."| holidaydate:".json_encode($holidaydate);
  823.                     SELF::createApiLog($log_data);
  824.                     
  825.                     $holidaysenddate = $holiday->getHolidaysenddate();
  826.                     if(!empty($holidaysenddate) && $holidaysenddate){
  827.                         $holidaysenddate = date("Y-m-d", strtotime($holidaysenddate));
  828.                         $rangeDates = self::getDatesFromRange($holidayDate, $holidaysenddate);
  830.                         $log_data = $api_log_info." | holidaysenddate:".json_encode($holidaysenddate)."| rangeDates:".json_encode($rangeDates);
  831.                         SELF::createApiLog($log_data);
  832.                         
  833.                         foreach($rangeDates as $rangeDateInfo){
  834.                             array_push($holidayDates,$rangeDateInfo);
  835.                         }
  836.                     } else {
  837.                         array_push($holidayDates,$holidayDate);
  838.                     }
  839.                 }
  841.                 $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  842.                 $delSlotTimesList->setOrderKey("o_id");
  843.                 $delSlotTimesList->setOrder("desc");
  844.                 $delSlotTimesList->load();
  846.                 // foreach($dates_list as $cur_date){
  848.                     $log_data = $api_log_info." | delSlotTimesList count:".count($delSlotTimesList);
  849.                     SELF::createApiLog($log_data);
  850.                     
  851.                     if(count($delSlotTimesList) > 0){
  853.                         $cur_time = date("H:i");//"09:00";//
  855.                         $log_data = $api_log_info." | cur_time:".$cur_time;
  856.                         SELF::createApiLog($log_data);
  858.                         foreach($delSlotTimesList as $delSlotTimes)
  859.                         {
  860.                             $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  861.                             SELF::createApiLog($log_data);
  863.                             //------- Get Week Dates based on Holidays and Slot Time data ---------//
  864.                             $slot_prepare_days = ($delSlotTimes->getprepare_days())?$delSlotTimes->getprepare_days():0;
  865.                             $slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():7;
  866.                             $saturday_slot_availability = ($delSlotTimes->getsaturday_slot_availability())?$delSlotTimes->getsaturday_slot_availability():'No';
  867.                             $sunday_slot_availability = ($delSlotTimes->getsunday_slot_availability())?$delSlotTimes->getsunday_slot_availability():'No';
  869.                             $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);
  870.                             SELF::createApiLog($log_data);
  872.                             /*--------------------- Up Country Configuration ------------------------*/
  873.                             $is_upcountry_configuration_applicable = ($delSlotTimes->getis_upcountry_configuration_applicable())?$delSlotTimes->getis_upcountry_configuration_applicable():'No';
  874.                             $slot_upcountry_prepare_days = ($delSlotTimes->getupcountry_prepare_days())?$delSlotTimes->getupcountry_prepare_days():0;
  875.                             $upcountry_slot_generate_days = ($delSlotTimes->getupcountry_slot_generate_days())?$delSlotTimes->getupcountry_slot_generate_days():7;
  876.                             $upcountry_saturday_slot_availability = ($delSlotTimes->getupcountry_saturday_slot_availability())?$delSlotTimes->getupcountry_saturday_slot_availability():'No';
  877.                             $upcountry_sunday_slot_availability = ($delSlotTimes->getupcountry_sunday_slot_availability())?$delSlotTimes->getupcountry_sunday_slot_availability():'No';
  879.                             $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);
  880.                             SELF::createApiLog($log_data);
  882.                             /*--------------------- Darkstore Configuration ------------------------*/
  883.                             $is_darkstore_configuration_applicable = ($delSlotTimes->getis_darkstore_configuration_applicable())?$delSlotTimes->getis_darkstore_configuration_applicable():'No';
  884.                             $slot_darkstore_prepare_days = ($delSlotTimes->getdarkstore_prepare_days())?$delSlotTimes->getdarkstore_prepare_days():0;
  885.                             $darkstore_slot_generate_days = ($delSlotTimes->getdarkstore_slot_generate_days())?$delSlotTimes->getdarkstore_slot_generate_days():7;
  886.                             $darkstore_saturday_slot_availability = ($delSlotTimes->getdarkstore_saturday_slot_availability())?$delSlotTimes->getdarkstore_saturday_slot_availability():'No';
  887.                             $darkstore_sunday_slot_availability = ($delSlotTimes->getdarkstore_sunday_slot_availability())?$delSlotTimes->getdarkstore_sunday_slot_availability():'No';
  889.                             $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);
  890.                             SELF::createApiLog($log_data);
  892.                             $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);
  893.                             SELF::createApiLog($log_data);
  895.                             // echo '<pre>';
  896.                             // print_r($settingsInfo);die;
  898.                             // echo $settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'];
  899.                             // echo "<br>";
  900.                             // echo $location_type;
  901.                             // die;
  903.                             if($settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'] == 'Yes' && $location_type == 'Darkstore')
  904.                             {                                
  905.                                 $slot_prepare_days = $slot_darkstore_prepare_days;
  906.                                 $slot_generate_days = $darkstore_slot_generate_days;
  907.                                 $saturday_slot_availability = $darkstore_saturday_slot_availability;
  908.                                 $sunday_slot_availability = $darkstore_sunday_slot_availability;
  909.                                 
  910.                                 $cur_slot_generate_days = ($delSlotTimes->getdarkstore_slot_generate_days())?$delSlotTimes->getdarkstore_slot_generate_days():0;
  911.                                 
  912.                                 $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'];
  914.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  916.                                 $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);
  917.                                 SELF::createApiLog($log_data);
  918.                             } 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)
  919.                             {                                
  920.                                 $slot_prepare_days = $slot_upcountry_prepare_days;
  921.                                 $slot_generate_days = $upcountry_slot_generate_days;
  922.                                 $saturday_slot_availability = $upcountry_saturday_slot_availability;
  923.                                 $sunday_slot_availability = $upcountry_sunday_slot_availability;
  924.                                 
  925.                                 $cur_slot_generate_days = ($delSlotTimes->getupcountry_slot_generate_days())?$delSlotTimes->getupcountry_slot_generate_days():0;
  926.                                 
  927.                                 // $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'];
  928.                                 
  929.                                 $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'];
  931.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  933.                                 $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);
  934.                                 SELF::createApiLog($log_data);
  935.                             } else {
  936.                                 $cur_slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():0;
  938.                                 // $slot_generate_days = ($cur_time > $setting_slot_time_flag)?$slot_generate_days+1:$slot_generate_days;
  940.                                 $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'];
  942.                                 $slot_generate_days = $slot_generate_days+$stg_normalloc_upcounry_slot_generate_days;
  944.                                 $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);
  945.                                 SELF::createApiLog($log_data);
  946.                             }
  948.                             $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;
  949.                             $cur_slot_prepare_days = (!empty($fastDelivery)) ? 0 : $cur_slot_prepare_days;
  951.                             $log_data = $api_log_info." | cur_slot_prepare_days:".json_encode($cur_slot_prepare_days);
  952.                             SELF::createApiLog($log_data);
  953.                             
  954.                             $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];
  956.                             $log_data = $api_log_info." | delSlotTimesAvailibility:".json_encode($delSlotTimesAvailibility);
  957.                             SELF::createApiLog($log_data);
  958.                             
  959.                             $weekdates = self::getWeekDates($holidayDates, date("Y-m-d"), $delSlotTimesAvailibility);
  961.                             $log_data = $api_log_info." | weekdates:".json_encode($weekdates);
  962.                             SELF::createApiLog($log_data);
  963.                             // echo $cur_time." | ".$setting_slot_time_flag;
  964.                             // echo 'delSlotTimesAvailibility<pre>:';
  965.                             // print_r($delSlotTimesAvailibility);
  966.                             // echo 'weekdates<pre>:';
  967.                             // print_r($weekdates);die;
  968.                             //------- Get Week Dates based on Holidays and Slot Time data ---------//
  970.                             // $prepare_days = $delSlotTimes->getprepare_days();
  971.                             // $delSlot_date = ($prepare_days == 0)?$tomorrow_date:date('Y-m-d', strtotime($today_date . ' +'.$prepare_days.' day'));
  972.                             if($settingsInfo['stg_deliveryslot_config_is_darkstore_configuration_applicable'] == 'Yes' && $location_type == 'Darkstore')
  973.                             {
  974.                                 $delSlot_date = ($slot_prepare_days == 0)?date('Y-m-d'):date('Y-m-d', strtotime($today_date . ' +'.$slot_prepare_days.' day'));
  975.                             } else {
  976.                                 $delSlot_date = ($slot_prepare_days == 0)?$tomorrow_date:date('Y-m-d', strtotime($today_date . ' +'.$slot_prepare_days.' day'));
  977.                             }
  979.                             if(!empty($fastDelivery)){
  981.                                 date_default_timezone_set('Asia/Kolkata');
  983.                                 $delSlot_date = date('Y-m-d');
  984.                                 
  985.                                 // Get the current hour
  986.                                 $currentHour = (int)date('H');
  988.                                 // Check if the current time is greater than 6 PM
  989.                                 if ($currentHour >= 18) {
  990.                                     // Add one day to the current date
  991.                                     $delSlot_date = date('Y-m-d', strtotime($delSlot_date . ' +1 day'));
  992.                                 }
  993.                             }
  995.                             $delSlot_date1 = date("Y-m-d", strtotime($delSlot_date));
  996.                             
  997.                             $cur_time_data = explode(" ",$cur_time);
  999.                             // $slot_generate_days = ($delSlotTimes->getslot_generate_days())?$delSlotTimes->getslot_generate_days():0;
  1001.                             // $slot_generate_days_limit = ($slot_generate_days > 0)?$slot_generate_days:1;
  1002.                             $slot_generate_days_limit = ($cur_slot_generate_days > 0)?$cur_slot_generate_days:1;
  1004.                             $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);
  1005.                             SELF::createApiLog($log_data);
  1007.                             // echo $tomorrow_date.":".$weekdates[0];
  1008.                             /* if($cur_time > $setting_slot_time_flag)//if($cur_time > '18:00')
  1009.                             {
  1010.                                 // if($tomorrow_date >= $weekdates[0])
  1011.                                 // {
  1012.                                 //     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  1013.                                 // } else {
  1014.                                 //     $no_of_weekdates = count($weekdates);
  1015.                                 //     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[$no_of_weekdates-1]])):[$weekdates[0]];
  1016.                                 // }
  1017.                                 
  1018.                                 $no_of_weekdates = count($weekdates);
  1019.                                 // $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[$no_of_weekdates-1]])):[$weekdates[0]];
  1021.                                 $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  1022.                             } else {
  1023.                                 $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  1024.                             } */
  1026.                             /* if($settingsInfo['stg_deliveryslot_config_is_upcountry_configuration_applicable'] == 'Yes' && $Is_location_up_country == 1)
  1027.                             {
  1028.                                 if($cur_time > $settingsInfo['stg_delslot_upcountryloc_morethan_fromtime'] && $cur_time < $settingsInfo['stg_delslot_upcountryloc_lessthaneq_totime'])
  1029.                                 {
  1030.                                     $weekdates = ($slot_generate_days > 0)?array_values(array_diff($weekdates,[$weekdates[0]])):[$weekdates[1]];
  1031.                                 } else {
  1032.                                     $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  1033.                                 }
  1034.                                 if(($slot_generate_days > 0)){
  1035.                                     for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days; $ii++)
  1036.                                     {
  1037.                                         $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  1038.                                     }
  1039.                                 } else 
  1040.                                 $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1041.                                 
  1042.                             } else {
  1043.                                 $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'];
  1044.                             } */
  1046.                             /* if(($slot_generate_days > 0)){
  1047.                                 for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days; $ii++)
  1048.                                 {
  1049.                                     $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  1050.                                 }
  1051.                             } else 
  1052.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]]; */
  1054.                             /*
  1055.                             if(($slot_generate_days > 0)){
  1056.                                 if($stg_normalloc_upcounry_slot_generate_days>1)
  1057.                                 {
  1058.                                     for($ii=0; $ii<$stg_normalloc_upcounry_slot_generate_days-1; $ii++)
  1059.                                     {
  1060.                                         $weekdates = array_values(array_diff($weekdates,[$weekdates[0]]));
  1061.                                     }
  1062.                                 }
  1064.                                 $cur_weekdates = [];
  1065.                                 if($cur_slot_generate_days > 0){
  1066.                                     for($jj=0; $jj < $cur_slot_generate_days; $jj++)
  1067.                                     {
  1068.                                         array_push($cur_weekdates,$weekdates[$jj]);
  1069.                                     }
  1070.                                 }
  1072.                                 $weekdates = $cur_weekdates;
  1074.                             } else 
  1075.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1077.                             */
  1079.                             $log_data = $api_log_info." | slot_generate_days:".json_encode($slot_generate_days)."| cur_slot_generate_days:".json_encode($cur_slot_generate_days);
  1080.                             SELF::createApiLog($log_data);
  1082.                             if(($slot_generate_days > 0)){
  1083.                                 $cur_weekdates = [];
  1084.                                 if($cur_slot_generate_days > 0){
  1085.                                     for($jj=0; $jj < $cur_slot_generate_days; $jj++)
  1086.                                     {
  1087.                                         $log_data = $api_log_info." | jj:".json_encode($jj)."| cur_weekdates:".json_encode($cur_weekdates)."| weekdates:".json_encode($weekdates);
  1088.                                         SELF::createApiLog($log_data);
  1090.                                         array_push($cur_weekdates,$weekdates[$jj]);
  1091.                                     }
  1092.                                 }
  1094.                                 $weekdates = $cur_weekdates;
  1096.                             } else 
  1097.                             $weekdates = [$weekdates[$stg_normalloc_upcounry_slot_generate_days]];
  1099.                             $log_data = $api_log_info." | stg_normalloc_upcounry_slot_generate_days:".json_encode($stg_normalloc_upcounry_slot_generate_days)."| weekdates:".json_encode($weekdates);
  1100.                             SELF::createApiLog($log_data);
  1102.                             // $weekdates = ($slot_generate_days > 0)?$weekdates:[$weekdates[0]];
  1104.                             // echo 'weekdates:<pre>:'; print_r($weekdates);
  1105.                             
  1106.                             $slot_generate_days_date  = date('Y-m-d', strtotime($today_date . ' +'.$slot_generate_days.' day'));
  1108.                             $delivery_modes = $setting_deliveryModes;//['standard','express'];//['courier','standard','express'];
  1110.                             $locationSlotRule = new DataObject\Deliveryslotrules\Listing();
  1111.                             $locationSlotRule->setCondition(" FIND_IN_SET('".$parentLoc_id."',location_ids) ");
  1112.                             $locationSlotRule = $locationSlotRule->getData();
  1114.                             if (count($locationSlotRule)) {
  1115.                                 $delivery_modes = array();
  1116.                                 foreach ($locationSlotRule as $slv) {
  1117.                                     $delivery_modes[] = $slv->getdelivery_mode();
  1118.                                 }
  1119.                             }
  1121.                             $log_data = $api_log_info." | slot_generate_days_date:".json_encode($slot_generate_days_date)."| delivery_modes:".json_encode($delivery_modes);
  1122.                             SELF::createApiLog($log_data);
  1124.                             $delivery_mode_slots_all = [];
  1125.                             foreach($delivery_modes as $delivery_mode)
  1126.                             {
  1127.                                 $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)."| delSlotTimes Title:".json_encode($delSlotTimes->gettitle());
  1128.                                 SELF::createApiLog($log_data);
  1130.                                 if($delSlotTimes->gettitle() == 'customized' && (!in_array($delivery_mode,['standard'])))
  1131.                                 {
  1132.                                     $delivery_mode_slots_all[$delivery_mode] = [];
  1133.                                 } else if($delSlotTimes->gettitle() == 'Confectionery' && (!in_array($delivery_mode,['standard','express'])))
  1134.                                 {
  1135.                                     $delivery_mode_slots_all[$delivery_mode] = [];
  1136.                                 } else {
  1137.                                     $slotsList = DataObject\Slots::getList();
  1139.                                     if($cur_time > $setting_slot_time_flag)//if($cur_time > '18:00')
  1140.                                     {
  1141.                                         $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]);
  1142.                                     } else {
  1143.                                         if($delivery_mode == 'standard')
  1144.                                         {
  1145.                                             $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]);
  1146.                                         } else
  1147.                                         {
  1148.                                             $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]);
  1149.                                         }
  1150.                                     }
  1152.                                     $slotsList->setOrderKey("slotdate");
  1153.                                     $slotsList->setOrder("asc");
  1154.                                     $slotsList->load();
  1156.                                     // if($slot_generate_days == 3)
  1157.                                     // {
  1158.                                     //     echo '<pre>';
  1159.                                     //     print_r($slotsList); die;
  1160.                                     // }
  1162.                                     /*---------- Slots Loop Starts ----------*/
  1163.                                     $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList))."| cur_slot_generate_days:".json_encode($cur_slot_generate_days);
  1164.                                     SELF::createApiLog($log_data);
  1166.                                     $delivery_mode_slots = [];
  1167.                                     if(count($slotsList) > 0 && $cur_slot_generate_days>0){
  1168.                                         foreach($slotsList as $slot)
  1169.                                         {
  1170.                                             $log_data = $api_log_info." | slot:".json_encode($slot);
  1171.                                             SELF::createApiLog($log_data);
  1173.                                             $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1174.                                             $loc_name = $slotLocationData->getlocation_name();
  1176.                                             $delivery_mode_slot1 = array(
  1177.                                                 "slotId" => $slot->getId(),
  1178.                                                 "prior_time" => $slot->getprior_time(),
  1179.                                                 "slotdate" => date("Y-m-d", strtotime($slot->getslotdate())),//$slot->getslotdate(),//$delSlot_date1,//
  1180.                                                 "loc_name" => $loc_name,
  1181.                                                 "fromtime" => $slot->getfromtime(),
  1182.                                                 "totime" => $slot->gettotime(),
  1183.                                                 "maxorder" => $slot->getmaxorder(),
  1184.                                                 "ordercount" => $slot->getordercount(),
  1185.                                                 "delivery_mode" => $slot->getdelivery_mode(),
  1186.                                             );
  1187.                                             array_push($delivery_mode_slots, $delivery_mode_slot1);
  1189.                                             $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1)."| delivery_mode_slots:".json_encode($delivery_mode_slots);
  1190.                                             SELF::createApiLog($log_data);
  1191.                                         }
  1192.                                     }
  1193.                                     /*---------- Slots Loop Starts ----------*/
  1195.                                     $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1197.                                     $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1198.                                     SELF::createApiLog($log_data);
  1200.                                     // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1201.                                     if ($fastDelivery) {
  1202.                                         if ($delivery_mode == 'standard') {
  1203.                                             $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1204.                                         } else {
  1205.                                             $delivery_mode_slots_all[$delivery_mode] = (!empty($delivery_mode_slots[0]) ? array($delivery_mode_slots[0]) : array());
  1206.                                         }
  1207.                                     } else {
  1208.                                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1209.                                     }
  1211.                                     $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)."| delivery_mode_slots:".json_encode($delivery_mode_slots);
  1212.                                     SELF::createApiLog($log_data);
  1213.                                 }
  1214.                             }
  1216.                             $data[] = array(
  1217.                                 // "LocationName" => $parentLocationName,
  1218.                                 // "LocationCode" => $parentLocationCode,
  1219.                                 // "Is_location_up_country" => $Is_location_up_country,
  1220.                                 "location_type" => $location_type,
  1221.                                 "is_upcountry_configuration_applicable" => $is_upcountry_configuration_applicable,
  1222.                                 "stg_normalloc_upcounry_slot_generate_days" => $stg_normalloc_upcounry_slot_generate_days,
  1223.                                 "deliverytype_id" => $delSlotTimes->gettitle(),
  1224.                                 "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1225.                                 "prepare_days" => $slot_prepare_days,//$delSlotTimes->getprepare_days(),
  1226.                                 "slot_generate_days" => $cur_slot_generate_days,//$slot_generate_days,
  1227.                                 "delSlot_date" => $delSlot_date1,
  1228.                                 "slots"=>$delivery_mode_slots_all);
  1230.                                 $log_data = $api_log_info." | data:".json_encode($data);
  1231.                                 SELF::createApiLog($log_data);
  1233.                         }
  1234.                     } else $data[] = ['message'=>$message];
  1235.                 // }
  1236.             } else $data[] = ['message'=>$message];
  1237.             
  1238.         } else $data[] = ['message'=>$message];
  1240.         $return_data = ["success" => true, "Is_location_up_country" => $Is_location_up_country, "data" => $data];
  1242.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  1243.         SELF::createApiLog($log_data);
  1245.         return $this->json(["success" => true, "Is_location_up_country" => $Is_location_up_country, "data" => $data]);
  1246.     }
  1248.     /**
  1249.      * @Route("/api/allslots")
  1250.      */
  1251.     public function allslotsAction()
  1252.     {
  1253.         $api_log_info = "API:All Available Slots - ".date("YmdHis")." ".time();
  1254.         $log_data = "Started - ".$api_log_info;
  1255.         SELF::createApiLog($log_data);
  1257.         $message = SELF::verifyauthToken($api_log_info);
  1258.         $log_data = $api_log_info." | message:".json_encode($message);
  1259.         SELF::createApiLog($log_data);
  1261.         if($message == "No data found")
  1262.         {
  1263.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1264.             $delSlotTimesList->load();
  1266.             // $delivery_modes = ['courier','standard','express'];
  1267.             // $slotsList = DataObject\Slots::getList();
  1268.             // $slotsList->setCondition("delivery_mode = 'courier'");
  1269.             // // if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1270.             // //     $slotsList->filterBydelivery_mode($courier_mode, '=');
  1271.             // // }
  1272.             // $slotsList->load();
  1274.             // echo '<pre>kk'; print_r($slotsList); die;
  1276.             $log_data = $api_log_info." | delSlotTimesList count:".json_encode(count($delSlotTimesList));
  1277.             SELF::createApiLog($log_data);
  1279.             if(count($delSlotTimesList) > 0){
  1280.                 foreach($delSlotTimesList as $delSlotTimes)
  1281.                 {
  1282.                     $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  1283.                     SELF::createApiLog($log_data);
  1285.                     $prepare_days = $delSlotTimes->getprepare_days();
  1286.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1288.                     $delSlot_date1 = date("Y-m-d");//date("Y-m-d", strtotime($delSlot_date));
  1289.                     $cur_time = date("H:i");
  1291.                     // $delSlotTimes->delSlot_date = $delSlot_date;
  1293.                     $delivery_modes = ['courier','standard','express'];
  1295.                     $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);
  1296.                     SELF::createApiLog($log_data);
  1298.                     $delivery_mode_slots_all = [];
  1299.                     foreach($delivery_modes as $delivery_mode)
  1300.                     {
  1301.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode);
  1302.                         SELF::createApiLog($log_data);
  1304.                         $slotsList = DataObject\Slots::getList();
  1305.                         // $slotsList->setCondition("delivery_mode = '".$delivery_mode."'");
  1306.                         if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  1307.                             $slotsList->filterBySlotdate($delSlot_date1, '>=');
  1308.                         }
  1309.                         // if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  1310.                         //     $slotsList->filterByprior_time($cur_time, '>=');
  1311.                         // }
  1312.                         if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1313.                             $slotsList->filterBydelivery_mode($delivery_mode, '>=');
  1314.                         }
  1315.                         $slotsList->setLimit(100);
  1316.                         $slotsList->setOrderKey("slotdate");
  1317.                         $slotsList->setOrder("asc");
  1318.                         $slotsList->load();
  1320.                         /*---------- Slots Loop Starts ----------*/
  1321.                         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  1322.                         SELF::createApiLog($log_data);
  1324.                         $delivery_mode_slots = [];
  1325.                         if(count($slotsList) > 0){
  1326.                             foreach($slotsList as $slot)
  1327.                             {
  1328.                                 $log_data = $api_log_info." | slot:".json_encode($slot);
  1329.                                 SELF::createApiLog($log_data);
  1330.                                 // $loc_name = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_name():'';
  1331.                                 // $loc_code = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_code():'';
  1333.                                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1334.                                 $loc_name = $slotLocationData->getlocation_name();
  1335.                                 $loc_code = $slotLocationData->getlocation_code();
  1337.                                 $log_data = $api_log_info." | slotLocationData:".json_encode($slotLocationData)." | loc_name:".json_encode($loc_name)." | loc_code:".json_encode($loc_code);
  1338.                                 SELF::createApiLog($log_data);
  1340.                                 $delivery_mode_slot1 = array(
  1341.                                     "slotId" => $slot->getId(),
  1342.                                     "prior_time" => $slot->getprior_time(),
  1343.                                     // "picking_time" => $slot->getpicking_time(),
  1344.                                     // "charge" => $slot->getcharge(),
  1345.                                     "slotdate" => $slot->getslotdate(),
  1346.                                     "loc_name" => $loc_name,
  1347.                                     "loc_code" => $loc_code,
  1348.                                     "fromtime" => $slot->getfromtime(),
  1349.                                     "totime" => $slot->gettotime(),
  1350.                                     "maxorder" => $slot->getmaxorder(),
  1351.                                     "ordercount" => $slot->getordercount(),
  1352.                                     "delivery_mode" => $slot->getdelivery_mode()
  1353.                                 );
  1355.                                 $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1);
  1356.                                 SELF::createApiLog($log_data);
  1358.                                 array_push($delivery_mode_slots, $delivery_mode_slot1);
  1360.                                 $log_data = $api_log_info." | delivery_mode_slots:".json_encode($delivery_mode_slots);
  1361.                                 SELF::createApiLog($log_data);
  1362.                             }
  1363.                         }
  1364.                         /*---------- Slots Loop Starts ----------*/
  1366.                         $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1368.                         $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1369.                         SELF::createApiLog($log_data);
  1371.                         // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1372.                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1374.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)." | delivery_mode_slots_all:".json_encode($delivery_mode_slots_all);
  1375.                         SELF::createApiLog($log_data);
  1376.                     }
  1378.                     $data[] = array(
  1379.                         "deliverytype_id" => $delSlotTimes->gettitle(),
  1380.                         "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1381.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1382.                         "delSlot_date" => $delSlot_date,
  1383.                         "slots"=>$delivery_mode_slots_all);
  1384.                     
  1385.                     $log_data = $api_log_info." | data:".json_encode($data);
  1386.                     SELF::createApiLog($log_data);
  1388.                 }
  1389.             } else $data[] = [];
  1391.         } else $data[] = ['message'=>$message];
  1392.         $data = (empty($data))?$message:$data;
  1393.                 
  1394.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  1395.         SELF::createApiLog($log_data);
  1397.         return $this->json(["success" => true, "data" => $data]);
  1398.     }
  1400.     /*------------------------------ End of Slots Related APIs -------------------------*/
  1402.     /*---------------------------------- Delivery Slot Time Related APIs ----------------------------*/
  1403.     /**
  1404.      * @Route("/deliveryslottime/getslottimes")
  1405.      */
  1406.     public function getslottimesAction()
  1407.     {
  1408.         $api_log_info = "API:Retriving all Delivery Slot times / Confencery Days - ".date("YmdHis")." ".time();
  1409.         $log_data = "Started - ".$api_log_info;
  1410.         SELF::createApiLog($log_data);
  1412.         $message = SELF::verifyauthToken($api_log_info);
  1413.         $log_data = $api_log_info." | message:".json_encode($message);
  1414.         SELF::createApiLog($log_data);
  1415.         
  1416.         if($message == "No data found")
  1417.         {
  1418.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1419.             $delSlotTimesList->load();
  1421.             $log_data = $api_log_info." | delSlotTimesList Count ; ".count($delSlotTimesList);
  1422.             SELF::createApiLog($log_data);
  1424.             if(count($delSlotTimesList) > 0){
  1425.                 foreach($delSlotTimesList as $delSlotTimes)
  1426.                 {
  1427.                     $log_data = $api_log_info." | delSlotTimes ; ".json_encode($delSlotTimes);
  1428.                     SELF::createApiLog($log_data);
  1430.                     $prepare_days = $delSlotTimes->getprepare_days();
  1431.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1433.                     $data[] = array(
  1434.                         "title" => $delSlotTimes->gettitle(),
  1435.                         "deliverytype_id" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1436.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1437.                         "delSlot_date" => $delSlot_date);
  1439.                         $log_data = $api_log_info." | data ; ".json_encode($data);
  1440.                         SELF::createApiLog($log_data);
  1442.                 }
  1443.             } else $data = "No data found";
  1444.         }else $data[] = ['message'=>$message];
  1445.         $data = (empty($data))?$message:$data;
  1447.         $log_data = "Ended - ".$api_log_info." | data ; ".json_encode($data);
  1448.         SELF::createApiLog($log_data);
  1450.         return $this->json(["success" => true, "data" => $data]);
  1451.     }
  1453.     /**
  1454.      * @Route("/deliveryslottime/getslottimeslist")
  1455.      */
  1456.     public function getslottimeslistAction()
  1457.     {
  1458.         $api_log_info = "API:Retriving all Delivery Slots - ".date("YmdHis")." ".time();
  1459.         $log_data = "Started - ".$api_log_info;
  1460.         SELF::createApiLog($log_data);
  1462.         $message = SELF::verifyauthToken($api_log_info);
  1463.         $log_data = $api_log_info." | message:".json_encode($message);
  1464.         SELF::createApiLog($log_data);
  1465.         
  1466.         if($message == "No data found")
  1467.         {
  1468.             $delSlotTimesList = DataObject\Deliveryslottimes::getList();
  1469.             $delSlotTimesList->load();
  1471.             // $delivery_modes = ['courier','standard','express'];
  1472.             // $slotsList = DataObject\Slots::getList();
  1473.             // $slotsList->setCondition("delivery_mode = 'courier'");
  1474.             // // if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1475.             // //     $slotsList->filterBydelivery_mode($courier_mode, '=');
  1476.             // // }
  1477.             // $slotsList->load();
  1479.             // echo '<pre>kk'; print_r($slotsList); die;
  1481.             $log_data = $api_log_info." | delSlotTimesList:".json_encode(count($delSlotTimesList));
  1482.             SELF::createApiLog($log_data);
  1484.             if(count($delSlotTimesList) > 0){
  1485.                 foreach($delSlotTimesList as $delSlotTimes)
  1486.                 {
  1487.                     $log_data = $api_log_info." | delSlotTimes:".json_encode($delSlotTimes);
  1488.                     SELF::createApiLog($log_data);
  1490.                     $prepare_days = $delSlotTimes->getprepare_days();
  1491.                     $delSlot_date = date('Y-m-d H:i:s', strtotime(' +'.$prepare_days.' day'));
  1493.                     $delSlot_date1 = date("Y-m-d", strtotime($delSlot_date));
  1494.                     $cur_time = date("H:i");
  1496.                     // $delSlotTimes->delSlot_date = $delSlot_date;
  1498.                     $delivery_modes = ['courier','standard','express'];
  1500.                     $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);
  1501.                     SELF::createApiLog($log_data);
  1503.                     $delivery_mode_slots_all = [];
  1504.                     foreach($delivery_modes as $delivery_mode)
  1505.                     {
  1506.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode);
  1507.                         SELF::createApiLog($log_data);
  1509.                         $slotsList = DataObject\Slots::getList();
  1510.                         // $slotsList->setCondition("delivery_mode = '".$delivery_mode."'");
  1511.                         if ($slotsList->getClass()->getFieldDefinition('slotdate')->isFilterable()) {
  1512.                             $slotsList->filterBySlotdate($delSlot_date1, '=');
  1513.                         }
  1514.                         if ($slotsList->getClass()->getFieldDefinition('prior_time')->isFilterable()) {
  1515.                             $slotsList->filterByprior_time($cur_time, '>=');
  1516.                         }
  1517.                         if ($slotsList->getClass()->getFieldDefinition('delivery_mode')->isFilterable()) {
  1518.                             $slotsList->filterBydelivery_mode($delivery_mode, '>=');
  1519.                         }
  1520.                         $slotsList->setLimit(100);
  1521.                         $slotsList->setOrderKey("slotdate");
  1522.                         $slotsList->setOrder("asc");
  1523.                         $slotsList->load();
  1525.                         /*---------- Slots Loop Starts ----------*/
  1527.                         $log_data = $api_log_info." | slotsList count:".json_encode(count($slotsList));
  1528.                         SELF::createApiLog($log_data);
  1530.                         $delivery_mode_slots = [];
  1531.                         if(count($slotsList) > 0){
  1532.                             foreach($slotsList as $slot)
  1533.                             {
  1534.                                 $log_data = $api_log_info." | slot:".json_encode($slot);
  1535.                                 SELF::createApiLog($log_data);
  1537.                                 // $loc_name = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_name():'';
  1538.                                 // $loc_code = (!empty($slot->getLoc_id()))?$slot->getLoc_id()->getlocation_code():'';
  1540.                                 $slotLocationData = DataObject\Locations::getById($slot->getLoc_id());
  1541.                                 $loc_name = $slotLocationData->getlocation_name();
  1542.                                 $loc_code = $slotLocationData->getlocation_code();
  1544.                                 $delivery_mode_slot1 = array(
  1545.                                     "slotId" => $slot->getId(),
  1546.                                     "prior_time" => $slot->getprior_time(),
  1547.                                     // "picking_time" => $slot->getpicking_time(),
  1548.                                     // "charge" => $slot->getcharge(),
  1549.                                     "slotdate" => $slot->getslotdate(),
  1550.                                     "loc_name" => $loc_name,
  1551.                                     "loc_code" => $loc_code,
  1552.                                     "fromtime" => $slot->getfromtime(),
  1553.                                     "totime" => $slot->gettotime(),
  1554.                                     "maxorder" => $slot->getmaxorder(),
  1555.                                     "ordercount" => $slot->getordercount(),
  1556.                                     "delivery_mode" => $slot->getdelivery_mode()
  1557.                                 );
  1558.                                 array_push($delivery_mode_slots, $delivery_mode_slot1);
  1560.                                 $log_data = $api_log_info." | delivery_mode_slot1:".json_encode($delivery_mode_slot1)." | delivery_mode_slots:".json_encode($delivery_mode_slots);
  1561.                                 SELF::createApiLog($log_data);
  1562.                             }
  1563.                         }
  1564.                         /*---------- Slots Loop Starts ----------*/
  1566.                         $delivery_mode_slot2 = array($delivery_mode=>$delivery_mode_slots);
  1568.                         $log_data = $api_log_info." | delivery_mode_slot2:".json_encode($delivery_mode_slot2);
  1569.                         SELF::createApiLog($log_data);
  1571.                         // array_push($delivery_mode_slots_all, $delivery_mode_slot2);
  1572.                         $delivery_mode_slots_all[$delivery_mode] = $delivery_mode_slots;
  1574.                         $log_data = $api_log_info." | delivery_mode:".json_encode($delivery_mode)." | delivery_mode_slots_all:".json_encode($delivery_mode_slots_all);
  1575.                         SELF::createApiLog($log_data);
  1576.                     }
  1578.                     $data[] = array(
  1579.                         "deliverytype_id" => $delSlotTimes->gettitle(),
  1580.                         "label" => $delSlotTimes->getdeliverytype_id()->getdeliverytype(),
  1581.                         "prepare_days" => $delSlotTimes->getprepare_days(),
  1582.                         "delSlot_date" => $delSlot_date,
  1583.                         "slots"=>$delivery_mode_slots_all);
  1584.                         
  1585.                     $log_data = $api_log_info." | data:".json_encode($data);
  1586.                     SELF::createApiLog($log_data);
  1588.                 }
  1589.             } else $data[] = [];
  1591.         }else $data[] = ['message'=>$message];
  1592.         $data = (empty($data))?$message:$data;
  1594.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  1595.         SELF::createApiLog($log_data);
  1597.         return $this->json(["success" => true, "data" => $data]);
  1598.     }
  1599.     /*------------------------------ End of Delivery Slot Time Related APIs -------------------------*/
  1601.     /*----------------------------------- AWS S3 Bucket Related APIs ---------------------------*/
  1602.     /**
  1603.      * @Route("/awss3bucket/gets3bucketlist")
  1604.      */
  1605.     public function gets3bucketlistAction()
  1606.     {
  1607.         putenv('AWS_DEFAULT_REGION=us-east-2');
  1608.         putenv('AWS_ACCESS_KEY_ID=AKIAUY45FDQLWT32YTPJ');
  1609.         putenv('AWS_SECRET_ACCESS_KEY=IyaHsvQqIdeyDvUrpmlm4T/xizd5999KCpuBP8vg');
  1611.         // $output = shell_exec('aws s3 ls');
  1612.         try
  1613.         {
  1614.             $output = shell_exec('aws s3api create-bucket --bucket snap2web-13 --region us-east-2 --create-bucket-configuration LocationConstraint=us-east-2');
  1615.         } catch(Exception $e)
  1616.         {
  1617.             echo $e->getMessage(); die;
  1618.         }
  1619.         // echo "<pre>$output</pre>";
  1621.         echo '<pre>'; print_r($output); die;
  1624.         return $this->json(["success" => true, "data" => $data]);
  1625.     }
  1627.     /**
  1628.      * @Route("/awss3bucket/uploadFileToS3")
  1629.      */
  1630.     public function uploadFileToS3()
  1631.     {
  1632.         $curl = curl_init();
  1634.         curl_setopt_array($curl, array(
  1635.         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',
  1636.         CURLOPT_RETURNTRANSFER => true,
  1637.         CURLOPT_ENCODING => '',
  1638.         CURLOPT_MAXREDIRS => 10,
  1639.         CURLOPT_TIMEOUT => 0,
  1640.         CURLOPT_FOLLOWLOCATION => true,
  1641.         CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1642.         CURLOPT_CUSTOMREQUEST => 'PUT',
  1643.         CURLOPT_POSTFIELDS => "<file contents here>",
  1644.         CURLOPT_HTTPHEADER => array(
  1645.             'Content-Type: text/plain'
  1646.         ),
  1647.         ));
  1649.         $response = curl_exec($curl);
  1651.         curl_close($curl);
  1652.         echo $response;
  1654.     }
  1655.     /*------------------------------ End of AWS S3 Bucket Related APIs -------------------------*/
  1657.     /**
  1658.      * @Route("/user/login", methods={"POST"})
  1659.      */
  1660.     public function userLogin(Request $request)
  1661.     {
  1662.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  1663.         $userName = (isset($reqparams['username']))?$reqparams['username']:'';
  1664.         $password = (isset($reqparams['password']))?$reqparams['password']:'';
  1665.         if($userName == '' || $password == '')
  1666.         {
  1667.             $data = "Username and Password are mandatory!";
  1668.         } else {
  1669.             $user = User::getByName($userName);
  1670.             if($user) {
  1671.                 $validateUser = \Pimcore\Tool\Authentication::authenticatePlaintext($userName,$password);
  1672.                 if($validateUser) {
  1674.                     $userInfo = ['id'=>$validateUser->getId(),
  1675.                                 'firstname'=>$validateUser->getfirstname(),
  1676.                                 'lastname'=>$validateUser->getlastname(),
  1677.                                 'email'=>$validateUser->getemail(),
  1678.                                 ];
  1680.                     $generateAuthTokenInfo = SELF::generateAuthToken($userInfo);
  1681.                     $generateAuthToken = $generateAuthTokenInfo['generateAuthToken'];
  1682.                     $jwtToken = (!empty($generateAuthTokenInfo['jwt']))?$generateAuthTokenInfo['jwt']:'';
  1683.                     $userId = $validateUser->getId(); 
  1685.                     $dbConnection = \Pimcore\Db::get();
  1687.                     $dbConnection->query("UPDATE users SET `authToken` = ? WHERE id = ?", [$generateAuthToken, $userId]);
  1689.                     $userData = User::getById($userId);
  1690.                     $authTokenVal = $dbConnection->fetchOne("SELECT authToken FROM users WHERE id = ".$userId);
  1692.                     $data = ["message"=>'Login successfull', "authToken"=>$authTokenVal];
  1694.                     if($jwtToken!='')
  1695.                         $data = ["message"=>'Login successfull', "authToken"=>$authTokenVal, "jwtToken"=>$jwtToken];
  1696.                     
  1697.                 } else {
  1698.                     $data = 'Wrong password';
  1699.                 }
  1700.             } else {
  1701.                 $data = 'User not found';
  1702.             }
  1703.         }
  1705.         return $this->json(["success" => true, "data" => $data]);
  1706.     }
  1708.     /*---------------------------------- JWT Related APIs ----------------------------*/
  1709.     /**
  1710.      * @Route("/api/gernerateJwtToken")
  1711.      */
  1712.     public function gernerateJwtTokenAction()
  1713.     {
  1714.         $id = 1024;
  1715.         $firstname = 'Tex';
  1716.         $lastname = 'Hardrock';
  1717.         $email = 'dino@stone.age';
  1719.         $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  1720.         $issuer_claim = "pimcore6.local"; // this can be the servername
  1721.         $audience_claim = "Babu";
  1722.         $issuedat_claim = time(); // issued at
  1723.         $notbefore_claim = $issuedat_claim + 10; //not before in seconds
  1724.         $expire_claim = $issuedat_claim + 60; // expire time in seconds
  1725.         $token = array(
  1726.             "iss" => $issuer_claim,
  1727.             "aud" => $audience_claim,
  1728.             "iat" => $issuedat_claim,
  1729.             "nbf" => $notbefore_claim,
  1730.             "exp" => $expire_claim,
  1731.             "data" => array(
  1732.                 "id" => $id,
  1733.                 "firstname" => $firstname,
  1734.                 "lastname" => $lastname,
  1735.                 "email" => $email
  1736.         ));
  1738.         $jwt = JWT::encode($token, $secret_key, 'HS256');
  1739.         // echo json_encode(
  1740.         //     array(
  1741.         //         "message" => "Successful login.",
  1742.         //         "jwt" => $jwt,
  1743.         //         "email" => $email,
  1744.         //         "expireAt" => $expire_claim
  1745.         //     )); die;
  1747.         $data = array(
  1748.             "message" => "Successful login.",
  1749.             "jwt" => $jwt,
  1750.             "email" => $email,
  1751.             "expireAt" => $expire_claim
  1752.         );
  1753.         return $this->json(["success" => true, "data" => $data]);
  1754.     }
  1756.     /**
  1757.      * @Route("/api/verifyJwtToken")
  1758.      */
  1759.     public function verifyJwtTokenAction()
  1760.     {
  1761.         $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  1762.         $jwt = null;
  1763.         
  1764.         $data = json_decode(file_get_contents("php://input"));
  1766.         $authHeader = $_SERVER['HTTP_AUTHORIZATION'];
  1768.         $arr = explode(" ", $authHeader);
  1770.         $jwt = $arr[1];
  1772.         if($jwt){
  1774.             try {
  1775.                 $decoded = JWT::decode($jwt, new Key($secret_key, 'HS256'));
  1777.                 // Access is granted. Add code of the operation here 
  1779.                 $data = array(
  1780.                     "message" => "Access granted"
  1781.                 );
  1782.                 return $this->json(["success" => true, "data" => $data]);
  1784.             }catch (Exception $e){
  1786.                 $data = array(
  1787.                     "message" => "Access denied"
  1788.                 );
  1789.                 return $this->json(["success" => true, "data" => $data]);
  1790.             }
  1792.         }
  1793.     }
  1795.     /*------------------------------ End of JWT Related APIs -------------------------*/
  1797.     /*---------------------------------- Personal Statement Related APIs ----------------------------*/
  1799.     /**
  1800.      * @Route("personalitystatement/getperstmtlist", methods={"POST"})
  1801.      */
  1802.     public function getperstmtlistAction(Request $request)
  1803.     {
  1804.         $api_log_info = "API:Get Personality Statements list with or without params - ".date("YmdHis")." ".time();
  1805.         $log_data = "Started - ".$api_log_info;
  1806.         SELF::createApiLog($log_data);
  1808.         $message = SELF::verifyauthToken($api_log_info);
  1810.         $log_data = $api_log_info." | message:".json_encode($message);
  1811.         SELF::createApiLog($log_data);
  1813.         // $data[] = ['message'=>$message];
  1814.         $data = [];
  1815.         if($message == "No data found")
  1816.         {
  1817.             $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  1818.             // print_r($reqparams); die;
  1819.             // print_r($request->get->all());
  1821.             $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  1822.             SELF::createApiLog($log_data);
  1824.             $title = (isset($reqparams['title']))?$reqparams['title']:'';
  1825.             $gender = (isset($reqparams['gender']))?$reqparams['gender']:'';
  1826.             $standout_fitin = (isset($reqparams['standout_fitin']))?$reqparams['standout_fitin']:'';
  1827.             $describe_yourself = (isset($reqparams['describe_yourself']))?$reqparams['describe_yourself']:'';
  1828.             $occasion = (isset($reqparams['occasion']))?$reqparams['occasion']:'';
  1829.             $priceband = (isset($reqparams['priceband']))?$reqparams['priceband']:'';
  1830.             $blank1 = (isset($reqparams['blank1']))?$reqparams['blank1']:'';
  1831.             $blank2 = (isset($reqparams['blank2']))?$reqparams['blank2']:'';
  1833.             $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);
  1834.             SELF::createApiLog($log_data);
  1836.             $perstmtList = DataObject\Personalitystatements::getList();
  1838.             if($title || $blank1 || $blank2 || $priceband || $gender || $standout_fitin || $describe_yourself || $occasion)
  1839.             {
  1840.                 $whr_condition = " personality_statement != '' "; $whr_condition_array = [];
  1841.                 if($title){
  1842.                     $whr_condition .= " AND personality_statement = '".$title."'";
  1843.                 }
  1844.                 if($priceband){
  1845.                     $whr_condition .= " AND priceband = '".$priceband."'";
  1846.                 }
  1847.                 if($blank1){
  1848.                     $whr_condition .= " AND blank1 = '".$blank1."'";
  1849.                 }
  1850.                 if($blank2){
  1851.                     $whr_condition .= " AND blank2 = '".$blank2."'";
  1852.                 }
  1853.                 if($gender){
  1854.                     $whr_condition .= " AND gender LIKE '%,".$gender.",%'";
  1855.                 }
  1856.                 if($standout_fitin){
  1857.                     $whr_condition .= " AND standout_fitin LIKE '%,".$standout_fitin.",%'";
  1858.                 }
  1859.                 if($describe_yourself){
  1860.                     $whr_condition .= " AND describe_yourself LIKE '%,".$describe_yourself.",%'";
  1861.                 }
  1862.                 if($occasion){
  1863.                     $whr_condition .= " AND occasion LIKE '%,".$occasion.",%'";
  1864.                 }
  1866.                 // echo "whr_condition:".$whr_condition;
  1867.                 // echo "whr_condition_array:";
  1868.                 // print_r($whr_condition_array); die;
  1870.                 $log_data = $api_log_info." | whr_condition:".json_encode($whr_condition);
  1871.                 SELF::createApiLog($log_data);
  1873.                 $perstmtList->setCondition($whr_condition);
  1874.                 
  1875.             }
  1876.             
  1877.             $perstmtList->load();
  1879.             $log_data = $api_log_info." | perstmtList count:".json_encode(count($perstmtList));
  1880.             SELF::createApiLog($log_data);
  1882.             foreach ($perstmtList as $key => $perstmtObj) {
  1884.                 $log_data = $api_log_info." | perstmtObj:".json_encode($perstmtObj);
  1885.                 SELF::createApiLog($log_data);
  1887.                 $data[] = array(
  1888.                     "id" => $perstmtObj->getId(),
  1889.                     "personality_statement" => $perstmtObj->getpersonality_statement(),
  1890.                     "standout_fitin" => $perstmtObj->getstandout_fitin(),
  1891.                     "describe_yourself" => $perstmtObj->getdescribe_yourself(),
  1892.                     "occasion" => $perstmtObj->getoccasion(),
  1893.                     "priceband" => $perstmtObj->getpriceband(),
  1894.                     "blank2" => $perstmtObj->getblank2(),
  1895.                     "blank1" => $perstmtObj->getblank1());
  1897.                 $log_data = $api_log_info." | data:".json_encode($data);
  1898.                 SELF::createApiLog($log_data);
  1899.             }
  1900.         } else $data[] = ['message'=>$message];
  1901.         $data = (empty($data))?$message:$data;
  1902.         // return $slotsList;
  1903.         $return_data = ["success" => true, "data" => $data];
  1904.         $log_data = $api_log_info." | return_data:".json_encode($return_data);
  1905.         SELF::createApiLog($log_data);
  1906.         return $this->json(["success" => true, "data" => $data]);
  1907.     }
  1909.     /**
  1910.      * @Route("personalitystatement/perstmtlist")
  1911.      */
  1912.     public function perstmtlistAction()
  1913.     {
  1914.         $api_log_info = "API:Get All Personality Statements - ".date("YmdHis")." ".time();
  1915.         $log_data = "Started - ".$api_log_info;
  1916.         SELF::createApiLog($log_data);
  1918.         $message = SELF::verifyauthToken($api_log_info);
  1919.         $log_data = $api_log_info." | message:".json_encode($message);
  1920.         SELF::createApiLog($log_data);
  1922.         if($message == "No data found")
  1923.         {
  1924.             $perstmtList = DataObject\Personalitystatements::getList();
  1925.             $perstmtList->load();
  1927.             $log_data = $api_log_info." | perstmtList count:".json_encode(count($perstmtList));
  1928.             SELF::createApiLog($log_data);
  1930.             if(count($perstmtList)>0){
  1931.                 foreach ($perstmtList as $key => $perstmtObj) {
  1933.                     $log_data = $api_log_info." | perstmtObj:".json_encode($perstmtObj);
  1934.                     SELF::createApiLog($log_data);
  1936.                     $data[] = array(
  1937.                         "id" => $perstmtObj->getId(),
  1938.                         "personality_statement" => $perstmtObj->getpersonality_statement(),
  1939.                         "standout_fitin" => $perstmtObj->getstandout_fitin(),
  1940.                         "describe_yourself" => $perstmtObj->getdescribe_yourself(),
  1941.                         "occasion" => $perstmtObj->getoccasion(),
  1942.                         "priceband" => $perstmtObj->getpriceband(),
  1943.                         "blank2" => $perstmtObj->getblank2(),
  1944.                         "blank1" => $perstmtObj->getblank1());
  1946.                     $log_data = $api_log_info." | data:".json_encode($data);
  1947.                     SELF::createApiLog($log_data);
  1948.                 }
  1949.             } else $data[] = ['message'=>$message];
  1950.         } else $data[] = ['message'=>$message];
  1952.         $return_data = ["success" => true, "data" => $data];
  1953.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  1954.         SELF::createApiLog($log_data);
  1956.         return $this->json(["success" => true, "data" => $data]);
  1957.     }
  1959.     /**
  1960.      * @Route("personalitystatement/perstmtinfo/{id}")
  1961.      */
  1962.     public function perstmtinfoAction($id)
  1963.     {
  1964.         $api_log_info = "API:Get Personality Statement Info by ID - ".date("YmdHis")." ".time();
  1965.         $log_data = "Started - ".$api_log_info;
  1966.         SELF::createApiLog($log_data);
  1968.         $log_data = $api_log_info." | ID:".$id;
  1969.         SELF::createApiLog($log_data);
  1971.         $message = SELF::verifyauthToken($api_log_info);
  1973.         $log_data = $api_log_info." | message:".json_encode($message);
  1974.         SELF::createApiLog($log_data);
  1976.         if($message == "No data found")
  1977.         {
  1978.             $perstmtObject = DataObject\Personalitystatements::getById($id);
  1980.             $log_data = $api_log_info." | perstmtObject:".json_encode($perstmtObject);
  1981.             SELF::createApiLog($log_data);
  1983.             if(!empty($perstmtObject) && $perstmtObject->getpersonality_statement()){
  1984.                 $log_data = $api_log_info." | perstmtObject getpersonality_statement:".json_encode($perstmtObject->getpersonality_statement());
  1985.                 SELF::createApiLog($log_data);
  1987.                 $data[] = array(
  1988.                     "id" => $perstmtObject->getId(),
  1989.                     "personality_statement" => $perstmtObject->getpersonality_statement(),
  1990.                     "standout_fitin" => $perstmtObject->getstandout_fitin(),
  1991.                     "describe_yourself" => $perstmtObject->getdescribe_yourself(),
  1992.                     "occasion" => $perstmtObject->getoccasion(),
  1993.                     "priceband" => $perstmtObject->getpriceband(),
  1994.                     "blank2" => $perstmtObject->getblank2(),
  1995.                     "blank1" => $perstmtObject->getblank1());
  1997.                 $log_data = $api_log_info." | data:".json_encode($data);
  1998.                 SELF::createApiLog($log_data);
  2000.             } else $data[] = ['message'=>$message];
  2001.         } else $data[] = ['message'=>$message];
  2003.         $returnData = ["success" => true, "data" => $data];
  2005.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  2006.         SELF::createApiLog($log_data);
  2008.         return $this->json(["success" => true, "data" => $data]);
  2009.     }
  2011.     /*------------------------------ End of Personal Statement Related APIs -------------------------*/
  2013.     /*---------------------------------- Shipping Rate / Delivery Fee Related APIs ----------------------------*/
  2015.     /**
  2016.      * @Route("api/shippingchargeslist")
  2017.      */
  2018.     public function shippingchargeslistAction()
  2019.     {
  2020.         $api_log_info = "API:Get Shipping Charges List - ".date("YmdHis")." ".time();
  2021.         $log_data = "Started - ".$api_log_info;
  2022.         SELF::createApiLog($log_data);
  2024.         $message = SELF::verifyauthToken($api_log_info);
  2026.         $log_data = $api_log_info." | message:".json_encode($message);
  2027.         SELF::createApiLog($log_data);
  2029.         if($message == "No data found")
  2030.         {
  2031.             $shippingchargesList = DataObject\Shippingcharges::getList();
  2032.             $shippingchargesList->load();
  2034.             $log_data = $api_log_info." | shippingchargesList count:".json_encode(count($shippingchargesList));
  2035.             SELF::createApiLog($log_data);
  2037.             if(count($shippingchargesList)>0){
  2038.                 foreach ($shippingchargesList as $key => $shippingchargeObj) {
  2040.                     $log_data = $api_log_info." | shippingchargeObj:".json_encode($shippingchargeObj);
  2041.                     SELF::createApiLog($log_data);
  2043.                     $data[] = array(
  2044.                         "id" => $shippingchargeObj->getId(),
  2045.                         "minimum_order" => $shippingchargeObj->getminimum_order(),
  2046.                         "maximum_order" => $shippingchargeObj->getmaximum_order(),
  2047.                         "discount_percentage" => $shippingchargeObj->getdiscount_percentage(),
  2048.                         "location" => $shippingchargeObj->getlocationId()->getLocation_name());
  2050.                     $log_data = $api_log_info." | data:".json_encode($data);
  2051.                     SELF::createApiLog($log_data);
  2052.                 }
  2053.             } else $data[] = ['message'=>$message];
  2054.         } else $data[] = ['message'=>$message];
  2056.         $returnData = ["success" => true, "data" => $data];
  2058.         $log_data = "Ended - ".$api_log_info." | returnData:".json_encode($returnData);
  2059.         SELF::createApiLog($log_data);
  2061.         return $this->json(["success" => true, "data" => $data]);
  2062.     }
  2064.     /**
  2065.      * @Route("api/shippingrateslist", methods={"POST"})
  2066.      */
  2067.     public function shippingrateslistAction()
  2068.     {
  2070.         $api_log_info = "API:Shipping Rate / Delivery Fee List - ".date("YmdHis")." ".time();
  2071.         $log_data = "Started - ".$api_log_info;
  2072.         SELF::createApiLog($log_data);
  2074.         $message = SELF::verifyauthToken($api_log_info);
  2075.         $log_data = $api_log_info." | message:".json_encode($message);
  2076.         SELF::createApiLog($log_data);
  2078.         if($message == "No data found")
  2079.         {
  2080.             $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2081.             $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2082.             SELF::createApiLog($log_data);
  2084.             $weight_cart = (isset($reqparams['weight_cart']))?$reqparams['weight_cart']:'';
  2085.             $req_weight_cart = $weight_cart;
  2086.             $locationCode = (isset($reqparams['locationCode']))?$reqparams['locationCode']:'';
  2087.             $shipping_state_code = (isset($reqparams['shipping_state_code']))?$reqparams['shipping_state_code']:'';
  2088.             $pincode = (isset($reqparams['pincode']))?$reqparams['pincode']:'';
  2089.             $order_amount = (isset($reqparams['order_amount']))?$reqparams['order_amount']:'';
  2091.             $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);
  2092.             SELF::createApiLog($log_data);
  2094.             if($weight_cart == '' || $locationCode == '' || $shipping_state_code == '' || $pincode == '' || $order_amount == '')
  2095.             {
  2096.                 $data = "weight_cart, locationCode, shipping_state_code, pincode and order_amount are mandatory!";
  2098.                 $log_data = $api_log_info." | data:".json_encode($data);
  2099.                 SELF::createApiLog($log_data);
  2100.             } else {
  2101.                 /*------ Get Shipping Rate Card Class data --------*/
  2102.                 $dbConnection = \Pimcore\Db::get();
  2103.                 $shippingRatecardClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Shippingratecards' ");
  2104.                 $shippingRatecardObject = "object_".$shippingRatecardClassId;
  2106.                 $log_data = $api_log_info." | shippingRatecardObject:".json_encode($shippingRatecardObject);
  2107.                 SELF::createApiLog($log_data);
  2109.                 // $shippingRatecardId = $dbConnection->fetchOne(" select * from object_12 order by abs(no_of_kgs - ".$weight_cart.")");
  2110.                 $shippingRatecardId = $dbConnection->fetchOne(" select * from ".$shippingRatecardObject." order by abs(no_of_kgs - ".$weight_cart.")");
  2112.                 $log_data = $api_log_info." | shippingRatecardId:".json_encode($shippingRatecardId);
  2113.                 SELF::createApiLog($log_data);
  2114.                 /*----- End of ---------*/
  2115.                 /*---- Check Location by Location Code ---------*/
  2116.                 $locData = DataObject\Locations::getBylocation_code($locationCode, 1);
  2117.                 $pincodeInfo = DataObject\ItcAddPincode::getBypincode($pincode, 1);
  2118.                 $stateInfo = DataObject\States::getBystate_code($shipping_state_code, 1);
  2119.                 $shipChargeInfo = DataObject\Shippingratecards::getById($shippingRatecardId); //DataObject\Shippingratecards::getByno_of_kgs($weight_cart, 1);
  2121.                 $log_data = $api_log_info." | locData:".json_encode($locData)." | pincodeInfo:".json_encode($pincodeInfo)." | stateInfo:".json_encode($stateInfo)." | shipChargeInfo:".json_encode($shipChargeInfo);
  2122.                 SELF::createApiLog($log_data);
  2124.                 if(empty($locData) || empty($locData->getId()) || empty($pincodeInfo) || empty($pincodeInfo->getId()) || empty($shipChargeInfo) || empty($shipChargeInfo->getId()))// || empty($stateInfo) || empty($stateInfo->getId()) 
  2125.                 {
  2126.                     if(empty($locData) || empty($locData->getId()))
  2127.                         $message = "Location is not exited, please try with valid location code!";
  2128.                     
  2129.                     if(empty($pincodeInfo) || empty($pincodeInfo->getId()))
  2130.                         $message = "Pincode is not exited, please try with valid pincode!";
  2131.                 
  2132.                     if(empty($shipChargeInfo) || empty($shipChargeInfo->getId()))
  2133.                         $message = "Shipping Charge is not exited for ".$weight_cart." Kgs, please try with valid No of Kgs!";
  2135.                     $data[] = ['message'=>$message];
  2136.                     
  2137.                     $log_data = $api_log_info." | data:".json_encode($data);
  2138.                     SELF::createApiLog($log_data);
  2140.                 } else {
  2141.                     $locationId = $locData->getId();
  2142.                     $locationName = $locData->getLocation_name();
  2143.                     $message = SELF::verifyauthToken();
  2144.                     
  2145.                     $log_data = $api_log_info." | locationId:".json_encode($locationId)." | locationName:".json_encode($locationName)." | message:".json_encode($message);
  2146.                     SELF::createApiLog($log_data);
  2148.                     if($message == "No data found")
  2149.                     {
  2150.                         /*------ Check Location is Up Country or not --------*/
  2151.                         $Is_location_up_country = (strpos(strtolower($locationName),"up country"))?1:0;
  2152.                     
  2153.                         $log_data = $api_log_info." | Is_location_up_country:".json_encode($Is_location_up_country);
  2154.                         SELF::createApiLog($log_data);
  2155.         
  2156.                         /*------ Get Settings Class, Object and ID data --------*/
  2157.                         $dbConnection = \Pimcore\Db::get();
  2158.                         $settingsClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Settings' ");
  2159.                         $settingsObject = "object_".$settingsClassId;
  2160.                     
  2161.                         $log_data = $api_log_info." | settingsObject:".json_encode($settingsObject);
  2162.                         SELF::createApiLog($log_data);
  2164.                         $settingsObjectId = $dbConnection->fetchOne("select * from ".$settingsObject." order by oo_id asc");
  2165.                     
  2166.                         $log_data = $api_log_info." | settingsObjectId:".json_encode($settingsObjectId);
  2167.                         SELF::createApiLog($log_data);
  2169.                         /*---- Get Settings Data ---------*/
  2170.                         $settingsData = DataObject\Settings::getById($settingsObjectId);
  2172.                         $log_data = $api_log_info." | settingsData:".json_encode($settingsData);
  2173.                         SELF::createApiLog($log_data);
  2175.                         // echo '<pre>settingsObjectId:'.$settingsObjectId;
  2176.                         // echo '<pre>settingsData:';
  2177.                         // print_r($settingsData->getis_deliveryfee_config_applicable());
  2179.                         $is_shippingapplicable=$pincodeInfo->getis_shipping_applicable();
  2180.                     
  2181.                         $log_data = $api_log_info." | is_shippingapplicable:".json_encode($is_shippingapplicable);
  2182.                         SELF::createApiLog($log_data);
  2184.                         $pincode_data['pincode'] = $pincodeInfo->getpincode();
  2185.                         $pincode_data['state'] = $pincodeInfo->getstate();
  2186.                         $pincode_data['is_shipping_applicable'] = $pincodeInfo->getis_shipping_applicable();
  2187.                         $pincode_data['deliverytype'] = $pincodeInfo->getdeliverytype();
  2188.                     
  2189.                         $log_data = $api_log_info." | pincode_data:".json_encode($pincode_data);
  2190.                         SELF::createApiLog($log_data);
  2191.                         /*----------- End of Check Is Shipping Applicable or Not based on Pincode from Pincode Table ----------*/
  2193.                         /*------------- Get Shipping Discount Based on Is Shipping Applicable Fee Shipping Rule(Shipping Charges) Table------------*/
  2194.                         $final_cost=0; $rate_discount_perc=0; $cur_noofkgs = $shipChargeInfo->getno_of_kgs();
  2195.                         $zone_name=(!empty($stateInfo) && $stateInfo->getZoneId())?$stateInfo->getZoneId()->getzone_name():'';
  2196.                     
  2197.                         $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);
  2198.                         SELF::createApiLog($log_data);
  2199.                         /*----------- End of Get Zone based on State Code from States Table ----------*/
  2201.                         /*------------- Get Shipping rate data based on state code and weight cart ------------*/
  2202.                         $shippingratesList = DataObject\Shippingratecards::getList();
  2203.                         if ($shippingratesList->getClass()->getFieldDefinition('no_of_kgs')->isFilterable()) {
  2204.                             $shippingratesList->filterByno_of_kgs($cur_noofkgs, '=');
  2205.                         }
  2206.                         $shippingratesList->setOrderKey("no_of_kgs");
  2207.                         $shippingratesList->setOrder("desc");
  2208.                         $shippingratesList->load();
  2209.                     
  2210.                         $log_data = $api_log_info." | shippingratesList count:".json_encode(count($shippingratesList));
  2211.                         SELF::createApiLog($log_data);
  2213.                         if(count($shippingratesList)>0){
  2214.                             $ii=0;
  2215.                             foreach ($shippingratesList as $key => $shippingrateObj) {
  2216.                     
  2217.                                 $log_data = $api_log_info." | key:".json_encode($key)." | shippingrateObj:".json_encode($shippingrateObj);
  2218.                                 SELF::createApiLog($log_data);
  2220.                                 $data_key = $data_val = $data_key2 = $data_val2 = '';
  2221.                                 $data[] = array(
  2222.                                     "id" => $shippingrateObj->getId(),
  2223.                                     "no_of_kgs" => $req_weight_cart,
  2224.                                     "inter_region_cost" => $shippingrateObj->getintera_region_cost(),
  2225.                                     "j_k_cost" => $shippingrateObj->getj_and_k_cost(),
  2226.                                     "ne_and_andaman_cost" => $shippingrateObj->getne_and_andaman()
  2227.                                 );
  2228.                     
  2229.                                 $log_data = $api_log_info." | Initialise data_key, data_val, data_key2 and data_val2 values as null | data:".json_encode($data);
  2230.                                 SELF::createApiLog($log_data);
  2231.                                 
  2232.                                 if($is_shippingapplicable == 'Yes')
  2233.                                 {
  2234.                                     if($zone_name == 'J and K')
  2235.                                     {
  2236.                                         $final_cost = $shippingrateObj->getj_and_k_cost();
  2237.                                     }
  2238.                                     else if($zone_name == 'NE and Andaman')
  2239.                                     {
  2240.                                         $final_cost = $shippingrateObj->getne_and_andaman();  
  2241.                                     }
  2242.                                     else 
  2243.                                     {
  2244.                                         $final_cost = $shippingrateObj->getintera_region_cost();
  2245.                                     }
  2246.                                 }
  2248.                                 $log_data = $api_log_info." | zone_name:".json_encode($zone_name)." | final_cost:".json_encode($final_cost);
  2249.                                 SELF::createApiLog($log_data);
  2251.                                 $data[$ii]['locationCode'] = $locationCode;
  2252.                                 $data[$ii]['pincode'] = $pincode_data;
  2253.                     
  2254.                                 $log_data = $api_log_info." | ii:".json_encode($ii)." | data:".json_encode($data);
  2255.                                 SELF::createApiLog($log_data);
  2256.                                 
  2257.                             }
  2258.                             $minimum_order = $maximum_order = $discount_percentage = 0; $shippingRules = [];
  2259.                     
  2260.                             $log_data = $api_log_info." | Initialise minimum_order, maximum_order, discount_percentage and shippingRules values as null | is_shippingapplicable:".json_encode($is_shippingapplicable);
  2261.                             SELF::createApiLog($log_data);
  2262.                             
  2263.                             if($is_shippingapplicable == 'Yes')//&& $loc_code_error == ''
  2264.                             {
  2265.                                 $shippingchargesList = DataObject\Shippingcharges::getList();
  2266.                                 $shippingchargesList->setCondition("locationId__Id = ? AND (minimum_order <= ? AND maximum_order >= ?)",[$locationId, $order_amount, $order_amount]);
  2267.                                 $shippingchargesList->load();
  2268.                     
  2269.                                 $log_data = $api_log_info." | shippingchargesList count:".json_encode(count($shippingchargesList));
  2270.                                 SELF::createApiLog($log_data);
  2272.                                 if(count($shippingchargesList)>0)
  2273.                                 {
  2274.                                     foreach($shippingchargesList as $shippingchargeObj)
  2275.                                     {
  2276.                                         $log_data = $api_log_info." | shippingchargeObj:".json_encode($shippingchargeObj);
  2277.                                         SELF::createApiLog($log_data);
  2279.                                         $minimum_order = $shippingchargeObj->getminimum_order();
  2280.                                         $maximum_order = $shippingchargeObj->getmaximum_order();
  2281.                                         $discount_percentage = $shippingchargeObj->getdiscount_percentage();
  2283.                                         $log_data = $api_log_info." | minimum_order:".json_encode($minimum_order)." | maximum_order:".json_encode($maximum_order)." | discount_percentage:".json_encode($discount_percentage);
  2284.                                         SELF::createApiLog($log_data);
  2286.                                         $shippingRules['shippingRuleId'] = $shippingchargeObj->getId();
  2287.                                         $shippingRules['minimum_order_amount'] = $minimum_order;
  2288.                                         $shippingRules['maximum_order_amount'] = $maximum_order;
  2289.                                         $shippingRules['discount_percentage'] = $discount_percentage;
  2291.                                         $log_data = $api_log_info." | shippingRules:".json_encode($shippingRules);
  2292.                                         SELF::createApiLog($log_data);
  2293.                                     }
  2294.                                     $data[$ii]['shippingRules'] = $shippingRules;
  2296.                                     $log_data = $api_log_info." | ii:".json_encode($ii)." | data:".json_encode($data);
  2297.                                     SELF::createApiLog($log_data);
  2299.                                     $rate_discount_perc = ($minimum_order <= $order_amount && $maximum_order >= $order_amount)?$discount_percentage:0;
  2301.                                     $final_cost = $final_cost - (($final_cost*$rate_discount_perc)/100);
  2303.                                     $log_data = $api_log_info." | rate_discount_perc:".json_encode($rate_discount_perc)." | final_cost:".json_encode($final_cost);
  2304.                                     SELF::createApiLog($log_data);
  2305.                                 }
  2306.                                 
  2307.                             }
  2309.                             /*----------- Delivery Fee Configuration Condition --------------*/
  2311.                             $log_data = $api_log_info." | settingsData getis_deliveryfee_config_applicable:".json_encode($settingsData->getis_deliveryfee_config_applicable());
  2312.                             SELF::createApiLog($log_data);
  2314.                             if($settingsData->getis_deliveryfee_config_applicable() == 'Yes')
  2315.                             {
  2316.                                 $stg_deliveryfee_config = $settingsData->getdeliveryfee_config();
  2317.                                 $stg_deliveryfee_config_location_lessthan_charge = $settingsData->getdeliveryfee_config_location_lessthan_charge();
  2318.                                 $stg_deliveryfee_config_location_greaterthanequal_charge = $settingsData->getdeliveryfee_config_location_greaterthanequal_charge();
  2319.                                 $stg_deliveryfee_config_upcountry_lessthan_charge = $settingsData->getdeliveryfee_config_upcountry_lessthan_charge();
  2320.                                 $stg_deliveryfee_config_upcountry_greaterthanequal_charge = $settingsData->getdeliveryfee_config_upcountry_greaterthanequal_charge();
  2322.                                 $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);
  2323.                                 SELF::createApiLog($log_data);
  2325.                                 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;
  2326.                                 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;
  2327.                                 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;
  2328.                                 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;
  2329.                                 else $final_cost = $final_cost;
  2331.                                 $log_data = $api_log_info." | final_cost:".json_encode($final_cost);
  2332.                                 SELF::createApiLog($log_data);
  2333.                             }
  2334.                             
  2335.                             $data[$ii]['final_cost'] = $final_cost;
  2337.                             // 2 hours fast delivery code
  2338.                             if($is_shippingapplicable == 'Yes')
  2339.                             {
  2340.                                 $fdsett = DataObject\FastDeliverySetting::getList();
  2341.                                 $fdsett->setCondition("locationId__Id = ?",[$locationId]);
  2342.                                 $fdsett->load();
  2344.                                 $data[$ii]['platform_fee'] = 0;
  2345.                                 $data[$ii]['low_order_fee'] = 0;
  2347.                                 if(count($fdsett->getData()) > 0) {
  2348.                                     $fdsett = $fdsett->getData()[0];
  2350.                                     $data[$ii]['platform_fee'] = $fdsett->getplatFormFee();
  2351.                                     $cartValue = $fdsett->getcartValue();
  2353.                                     if($cartValue > $order_amount) {
  2354.                                         $data[$ii]['low_order_fee'] = $fdsett->getminLowOrderFee();
  2355.                                     } else {
  2356.                                         $data[$ii]['low_order_fee'] = $fdsett->getlowOrderFee();
  2357.                                     }
  2358.                                 }
  2359.                             }
  2361.                             $log_data = $api_log_info." | final_cost:".json_encode($final_cost)." | ii:".json_encode($ii)." | data:".json_encode($data);
  2362.                             SELF::createApiLog($log_data);
  2364.                         } else $data[] = ['message'=>$message];
  2365.                         /*----------- End of Get Shipping rate data based on state code and weight cart ----------*/
  2367.                     } else $data[] = ['message'=>$message];
  2368.                 }
  2369.             }
  2370.         } else $data[] = ['message'=>$message];
  2372.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2373.         SELF::createApiLog($log_data);
  2375.         return $this->json(["success" => true, "data" => $data]);
  2376.     }
  2378.     /*------------------------------ End of Shipping Rate / Delivery Fee Related APIs -------------------------*/
  2380.     /*---------------------------------- Factory Related APIs ----------------------------*/
  2382.     /**
  2383.      * @Route("/factory/getfactories")
  2384.      */
  2385.     public function getfactories()
  2386.     {
  2387.         $api_log_info = "API:Get All Factories - ".date("YmdHis")." ".time();
  2388.         $log_data = "Started - ".$api_log_info;
  2389.         SELF::createApiLog($log_data);
  2391.         $message = SELF::verifyauthToken($api_log_info);
  2393.         $log_data = $api_log_info." | message:".json_encode($message);
  2394.         SELF::createApiLog($log_data);
  2396.         if($message == "No data found")
  2397.         {
  2398.             $factoriesList = DataObject\Factories::getList();
  2399.             $factoriesList->load();
  2401.             $log_data = $api_log_info." | factoriesList count:".json_encode(count($factoriesList));
  2402.             SELF::createApiLog($log_data);
  2404.             if(count($factoriesList) > 0){
  2405.                 foreach ($factoriesList as $key => $blog) {
  2407.                     $log_data = $api_log_info." | key:".json_encode($key)." | blog:".json_encode($blog);
  2408.                     SELF::createApiLog($log_data);
  2410.                     $bestbefore_date = '';
  2412.                     if($blog->getbestbefore()){
  2413.                         $bestbefore_dt = date("m/d/y", strtotime($blog->getbestbefore()));
  2414.                         $bestbefore_date = Carbon::createFromFormat('m/d/y', $bestbefore_dt);
  2416.                         $log_data = $api_log_info." | bestbefore_dt:".json_encode($bestbefore_dt)." | bestbefore_date:".json_encode($bestbefore_date);
  2417.                         SELF::createApiLog($log_data);
  2418.                     }
  2419.                     $data[] = array(
  2420.                         "code" => $blog->getcode(),
  2421.                         "name" => $blog->getname(),
  2422.                         "address" => $blog->getaddress(),
  2423.                         "street" => $blog->getstreet(),
  2424.                         "landmark" => $blog->getlandmark(),
  2425.                         "city" => $blog->getcity(),
  2426.                         "state" => $blog->getstate(),
  2427.                         "country" => $blog->getcountry(),
  2428.                         "pincode" => $blog->getpincode(),
  2429.                         "bestbefore" => $bestbefore_date);
  2431.                     $log_data = $api_log_info." | data:".json_encode($data);
  2432.                     SELF::createApiLog($log_data);
  2433.                 }
  2434.             } else $data[] = ['message'=>$message];
  2435.         } else $data[] = ['message'=>$message];
  2437.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2438.         SELF::createApiLog($log_data);
  2439.         
  2440.         return $this->json(["success" => true, "data" => $data]);
  2441.     }
  2443.     /**
  2444.      * @Route("api/getfactorydata", methods={"POST"})
  2445.      */
  2446.     public function getfactorydataAction(Request $request)
  2447.     {
  2448.         $api_log_info = "API:Get factory Info by Code - ".date("YmdHis")." ".time();
  2449.         $log_data = "Started - ".$api_log_info;
  2450.         SELF::createApiLog($log_data);
  2452.         $factorycode = $request->get('factorycode');
  2454.         $log_data = $api_log_info." | factorycode:".json_encode($factorycode);
  2455.         SELF::createApiLog($log_data);
  2457.         if($factorycode == "")
  2458.         {
  2459.             $data = "Factory Code is mandatory!";
  2461.             $log_data = $api_log_info." | data:".json_encode($data);
  2462.             SELF::createApiLog($log_data);
  2463.         } else 
  2464.         {
  2465.             $data = SELF::verifyauthToken($api_log_info);
  2467.             $log_data = $api_log_info." | data:".json_encode($data);
  2468.             SELF::createApiLog($log_data);
  2470.             if($data == "No data found")
  2471.             {
  2472.                 /*---- Check Factory by Code ---------*/
  2473.                 $factoryData = DataObject\Factories::getBycode($factorycode, 1);
  2475.                 $log_data = $api_log_info." | factoryData:".json_encode($factoryData);
  2476.                 SELF::createApiLog($log_data);
  2478.                 if(!empty($factoryData) && $factoryData->getId()){
  2479.                         
  2480.                     $log_data = $api_log_info." | factoryData getId:".json_encode($factoryData->getId());
  2481.                     SELF::createApiLog($log_data);
  2483.                     $data = array(
  2484.                         "id" => $factoryData->getId(),
  2485.                         "code" => $factoryData->getCode(),
  2486.                         "name" => $factoryData->getname(),
  2487.                         "address" => $factoryData->getaddress(),
  2488.                         "street" => $factoryData->getstreet(),
  2489.                         "landmark" => $factoryData->getlandmark(),
  2490.                         "city" => $factoryData->getcity(),
  2491.                         "state" => $factoryData->getstate(),
  2492.                         "country" => $factoryData->getcountry(),
  2493.                         "pincode" => $factoryData->getpincode(),
  2494.                         "bestbefore" => $factoryData->getbestbefore());
  2496.                     $log_data = $api_log_info." | data:".json_encode($data);
  2497.                     SELF::createApiLog($log_data);
  2498.                 } else {
  2499.                     $data = "No data found!";
  2500.                     $log_data = $api_log_info." | data:".json_encode($data);
  2501.                     SELF::createApiLog($log_data);
  2502.                 }
  2503.             }
  2504.         }
  2506.         $log_data = "Ended - ".$api_log_info." | data:".json_encode($data);
  2507.         SELF::createApiLog($log_data);
  2509.         return $this->json(["success" => true, "data" => $data]);
  2510.     }
  2512.     /**
  2513.      * @Route("api/getfactoriesdata", methods={"POST"})
  2514.      */
  2515.     public function getfactoriesdataAction(Request $request)
  2516.     {
  2517.         header('X-Content-Type-Options: nosniff');
  2518.         header("X-Frame-Options: SAMEORIGIN");
  2519.         header("Content-Security-Policy: default-src 'self';script-src 'self'");
  2520.         
  2521.         $api_log_info = "API:Get Factories list by multiple Factory codes - ".date("YmdHis")." ".time();
  2522.         $log_data = "Started - ".$api_log_info;
  2523.         SELF::createApiLog($log_data);
  2525.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  2527.         $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  2528.         SELF::createApiLog($log_data);
  2530.         $factorycodes = (isset($reqparams['factorycodes']))?$reqparams['factorycodes']:'';
  2532.         $log_data = $api_log_info." | factorycodes:".json_encode($factorycodes);
  2533.         SELF::createApiLog($log_data);
  2535.         // $factorycode = $request->get('factorycode');
  2537.         if($factorycodes == "")
  2538.         {
  2539.             $data = "Factory Code(s) is(are) mandatory!";
  2541.             $log_data = $api_log_info." | data:".json_encode($data);
  2542.             SELF::createApiLog($log_data);
  2543.         } else 
  2544.         {
  2545.             $data = SELF::verifyauthToken($api_log_info);
  2547.             $log_data = $api_log_info." | data:".json_encode($data);
  2548.             SELF::createApiLog($log_data);
  2550.             if($data == "No data found")
  2551.             {
  2552.                 /*---- Check Factory by Code ---------*/
  2553.                 $factoriesData = new DataObject\Factories\Listing();
  2554.                 $factoriesData->setCondition("code IN (?)", [$factorycodes]);
  2555.                 $factoriesData->load();
  2557.                 $log_data = $api_log_info." | factoriesData count:".json_encode(count($factoriesData));
  2558.                 SELF::createApiLog($log_data);
  2560.                 if(!empty($factoriesData) && count($factoriesData)>0){
  2561.                     $data = [];
  2562.                     foreach($factoriesData as $factoryData){
  2564.                         $log_data = $api_log_info." | factoryData:".json_encode($factoryData);
  2565.                         SELF::createApiLog($log_data);
  2567.                         $curdata = array(
  2568.                             "id" => $factoryData->getId(),
  2569.                             "code" => $factoryData->getCode(),
  2570.                             "name" => $factoryData->getname(),
  2571.                             "address" => $factoryData->getaddress(),
  2572.                             "street" => $factoryData->getstreet(),
  2573.                             "landmark" => $factoryData->getlandmark(),
  2574.                             "city" => $factoryData->getcity(),
  2575.                             "state" => $factoryData->getstate(),
  2576.                             "country" => $factoryData->getcountry(),
  2577.                             "pincode" => $factoryData->getpincode(),
  2578.                             "bestbefore" => $factoryData->getbestbefore());
  2580.                         $log_data = $api_log_info." | curdata:".json_encode($curdata);
  2581.                         SELF::createApiLog($log_data);
  2583.                         array_push($data, $curdata);
  2585.                     }
  2586.                 } else {
  2587.                     $data = "No data found!";
  2588.                     $log_data = $api_log_info." | data:".json_encode($data);
  2589.                     SELF::createApiLog($log_data);
  2590.                 }
  2591.             }
  2592.         }
  2594.         $return_data = ["success" => true, "data" => $data];
  2596.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2597.         SELF::createApiLog($log_data);
  2599.         return $this->json(["success" => true, "data" => $data]);
  2600.     }
  2602.     /*------------------------------ End of Factory Related APIs -------------------------*/
  2604.     /*---------------------------------- Faq Related APIs ----------------------------*/
  2605.     /**
  2606.      * @param Request $request
  2607.      * 
  2608.      * @Route("/faqApi1",methods={"POST"})
  2609.      * 
  2610.      * @return Response
  2611.      * 
  2612.      */
  2613.     
  2614.      public function faqApi1Action(Request $request)
  2615.      {
  2616.         $api_log_info = "API:Get Faq List by locationcode with or without type - ".date("YmdHis")." ".time();
  2617.         $log_data = "Started - ".$api_log_info;
  2618.         SELF::createApiLog($log_data);
  2620.         $data = SELF::verifyauthToken($api_log_info);
  2622.         $log_data = $api_log_info." | data:".json_encode($data);
  2623.         SELF::createApiLog($log_data);
  2625.         if($data == "No data found")
  2626.         {
  2627.             $locationcode = (!empty($request->get('location_code')))?$request->get('location_code'):'';
  2629.             if($locationcode == "")
  2630.             {
  2631.                 $data = "Location Code is mandatory";
  2632.             } else {
  2633.                 $getlocationInfo = DataObject\Locations::getBylocation_code($locationcode, 1);
  2635.                 $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2636.                 SELF::createApiLog($log_data);
  2638.                 if((!empty($getlocationInfo))){
  2639.                     $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2640.                     $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2642.                     $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2643.                     SELF::createApiLog($log_data);
  2645.                     $faqType = (!empty($request->get('type')) && $request->get('type') == 'All')?'':((!empty($request->get('type')) && $request->get('type') != 'All')?$request->get('type'):'General');
  2647.                     $log_data = $api_log_info." | locationcode:".json_encode($locationcode)." | faqType:".json_encode($faqType);
  2648.                     SELF::createApiLog($log_data);
  2650.                     $faqTypes_list = ['','All','General', 'Loyalty'];
  2651.                     if(!in_array($faqType, $faqTypes_list)){
  2652.                         $data = "You are entered Type is Invalid, Please try again";
  2654.                         $return_data = ["success" => true, "data" => $data];
  2656.                         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2657.                         SELF::createApiLog($log_data);
  2658.                         
  2659.                         return $this->json(["success" => true, "data" => $data]);
  2660.                     }
  2661.             
  2662.                     $entries = new DataObject\ItcAddFaq\Listing();
  2664.                     $whr_condition = " faqQuestion!= '' ";
  2665.                     if($locationcode != '')
  2666.                     $whr_condition .= " AND location_code= '".$loc_name."' ";
  2667.                     if($faqType != '')
  2668.                     $whr_condition .= " AND faqType= '".$faqType."' ";
  2670.                     // if($locationcode != '')
  2671.                     // $entries->setCondition("location_name = :location_name", ["location_name" => $locationcode]);
  2672.                     // if($faqType != '')
  2673.                     // $entries->setCondition("faqType = :faqType", ["faqType" => $faqType]);
  2674.                     $entries->setCondition($whr_condition);
  2675.                     $entries->load();
  2677.                     $log_data = $api_log_info." | faq entries count :".json_encode(count($entries));
  2678.                     SELF::createApiLog($log_data);
  2680.                     $data = (count($entries)>0)?array():"No data found";
  2682.                     foreach($entries as $key => $entrie){
  2684.                         $log_data = $api_log_info." | faq key :".json_encode($key)." | faq entrie :".json_encode($entrie);
  2685.                         SELF::createApiLog($log_data);
  2686.             
  2687.                         if($entrie->getlocation_code()){
  2688.                             $locationInfo = DataObject\Locations::getBylocation_name($entrie->getlocation_code(), 1);
  2690.                             $log_data = $api_log_info." | locationInfo :".json_encode($locationInfo);
  2691.                             SELF::createApiLog($log_data);
  2692.                             
  2693.                             $loc_name = (!empty($locationInfo->getlocation_name()))?$locationInfo->getlocation_name():'';
  2694.                             $loc_code = (!empty($locationInfo->getlocation_code()))?$locationInfo->getlocation_code():'';
  2696.                             $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2697.                             SELF::createApiLog($log_data);
  2698.                         }
  2699.                         $data[] = array("faqId" => $entrie->getfaqId(),
  2700.                                 "location_code" => $loc_code,
  2701.                                 "location_name" => $loc_name,
  2702.                                 "faqQuestion" => $entrie->getfaqQuestion(),
  2703.                                 "faqAnswer" => $entrie->getfaqAnswer(),
  2704.                                 "Type" => $entrie->getfaqType(),
  2705.                         );
  2707.                         $log_data = $api_log_info." | data :".json_encode($data);
  2708.                         SELF::createApiLog($log_data);
  2709.                     }
  2711.                 } else {
  2712.                     $data = "Invalid Location Code, Please enter valid Location Code";
  2713.                     $log_data = $api_log_info." | data :".json_encode($data);
  2714.                     SELF::createApiLog($log_data);
  2715.                 }
  2716.             }
  2717.         }
  2719.         $return_data = ["success" => true, "data" => $data];
  2721.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2722.         SELF::createApiLog($log_data);
  2723.         
  2724.         return $this->json(["success" => true, "data" => $data]);
  2725.         
  2726.      }
  2727.      /**
  2728.      * @param Request $request
  2729.      * 
  2730.      * @Route("/faqApi",methods={"POST"})
  2731.      * 
  2732.      * @return Response
  2733.      * 
  2734.      */
  2735.      public function faqApiAction(Request $request)
  2736.      {
  2737.         $api_log_info = "API:Get Faq List by locationcode with or without type - ".date("YmdHis")." ".time();
  2738.         $log_data = "Started - ".$api_log_info;
  2739.         SELF::createApiLog($log_data);
  2741.         $data = SELF::verifyauthToken($api_log_info);
  2743.         $log_data = $api_log_info." | data:".json_encode($data);
  2744.         SELF::createApiLog($log_data);
  2746.         if($data == "No data found")
  2747.         {
  2748.             $locationcode = (!empty($request->get('location_code')))?$request->get('location_code'):'';
  2750.             // if($locationcode == "")
  2751.             // {
  2752.             //     $data = "Location Code is mandatory";
  2753.             // } else {
  2755.                 $getlocationInfo = (isset($locationcode) && $locationcode!='')?DataObject\Locations::getBylocation_code($locationcode, 1):[];
  2757.                 $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2758.                 SELF::createApiLog($log_data);
  2760.                 // if((!empty($getlocationInfo))){
  2762.                     $loc_name = (!empty($getlocationInfo) && !empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2763.                     $loc_code = (!empty($getlocationInfo) && !empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2765.                     $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2766.                     SELF::createApiLog($log_data);
  2768.                     $faqType = (!empty($request->get('type')) && $request->get('type') == 'All')?'':((!empty($request->get('type')) && $request->get('type') != 'All')?$request->get('type'):'General');
  2770.                     $log_data = $api_log_info." | locationcode:".json_encode($locationcode)." | faqType:".json_encode($faqType);
  2771.                     SELF::createApiLog($log_data);
  2773.                     $faqTypes_list = ['','All','General', 'Loyalty'];
  2774.                     if(!in_array($faqType, $faqTypes_list)){
  2775.                         $data = "You are entered Type is Invalid, Please try again";
  2777.                         $return_data = ["success" => true, "data" => $data];
  2779.                         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2780.                         SELF::createApiLog($log_data);
  2781.                         
  2782.                         return $this->json(["success" => true, "data" => $data]);
  2783.                     }
  2784.             
  2785.                     $entries = new DataObject\ItcAddFaq\Listing();
  2787.                     $whr_condition = " faqQuestion!= '' ";
  2788.                     if($locationcode != '')
  2789.                     $whr_condition .= " AND location_code= '".$loc_name."' ";
  2790.                     if($faqType != '')
  2791.                     $whr_condition .= " AND faqType= '".$faqType."' ";
  2793.                     // if($locationcode != '')
  2794.                     // $entries->setCondition("location_name = :location_name", ["location_name" => $locationcode]);
  2795.                     // if($faqType != '')
  2796.                     // $entries->setCondition("faqType = :faqType", ["faqType" => $faqType]);
  2797.                     $entries->setCondition($whr_condition);
  2798.                     $entries->load();
  2800.                     $log_data = $api_log_info." | faq entries count :".json_encode(count($entries));
  2801.                     SELF::createApiLog($log_data);
  2803.                     $data = (count($entries)>0)?array():"No data found";
  2805.                     foreach($entries as $key => $entrie){
  2807.                         $log_data = $api_log_info." | faq key :".json_encode($key)." | faq entrie :".json_encode($entrie);
  2808.                         SELF::createApiLog($log_data);
  2809.             
  2810.                         if($entrie->getlocation_code()){
  2811.                             $locationInfo = DataObject\Locations::getBylocation_name($entrie->getlocation_code(), 1);
  2813.                             $log_data = $api_log_info." | locationInfo :".json_encode($locationInfo);
  2814.                             SELF::createApiLog($log_data);
  2815.                             
  2816.                             $loc_name = (!empty($locationInfo->getlocation_name()))?$locationInfo->getlocation_name():'';
  2817.                             $loc_code = (!empty($locationInfo->getlocation_code()))?$locationInfo->getlocation_code():'';
  2819.                             $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2820.                             SELF::createApiLog($log_data);
  2821.                         }
  2822.                         $data[] = array("faqId" => $entrie->getfaqId(),
  2823.                                 "location_code" => $loc_code,
  2824.                                 "location_name" => $loc_name,
  2825.                                 "faqQuestion" => $entrie->getfaqQuestion(),
  2826.                                 "faqAnswer" => $entrie->getfaqAnswer(),
  2827.                                 "Type" => $entrie->getfaqType(),
  2828.                         );
  2830.                         $log_data = $api_log_info." | data :".json_encode($data);
  2831.                         SELF::createApiLog($log_data);
  2832.                     }
  2834.                 // } else {
  2835.                 //     $data = "Invalid Location Code, Please enter valid Location Code";
  2836.                 //     $log_data = $api_log_info." | data :".json_encode($data);
  2837.                 //     SELF::createApiLog($log_data);
  2838.                 // }
  2839.             // }
  2840.         }
  2842.         $return_data = ["success" => true, "data" => $data];
  2844.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  2845.         SELF::createApiLog($log_data);
  2846.         
  2847.         return $this->json(["success" => true, "data" => $data]);
  2848.         
  2849.      }
  2850.     /*------------------------------ End of Faq Related APIs -------------------------*/
  2852.     /*--------------------------------- Pincode Related APIs -----------------------------*/
  2853.     /**
  2854.      * @param Request $request
  2855.      * 
  2856.      * @Route("/wearhouseDetectionApi",methods={"POST"})
  2857.      * 
  2858.      * @return Response
  2859.      * 
  2860.      */
  2862.      public function wearhouseDetectionApiAction(Request $request)
  2863.      { 
  2864.         $api_log_info = "API:Get Wearhouse data by Pincode - ".date("YmdHis")." ".time();
  2865.         $log_data = "Started - ".$api_log_info;
  2866.         SELF::createApiLog($log_data);
  2868.         $message = SELF::verifyauthToken();
  2870.         $log_data = $api_log_info." | message:".json_encode($message);
  2871.         SELF::createApiLog($log_data);
  2872.  
  2873.         if($message == "No data found")
  2874.         {
  2875.             if($request->get('pincode')){
  2876.                 $pincode = $request->get('pincode');
  2878.                 $log_data = $api_log_info." | pincode:".json_encode($pincode);
  2879.                 SELF::createApiLog($log_data);
  2881.                 // $entries = new DataObject\ItcAddPincode\Listing();
  2882.                 // $entries->setCondition("pincode = :name", ["name" => $pincode]);
  2883.                 // $entries->load();
  2885.                 $getpincodeInfo = DataObject\ItcAddPincode::getBypincode($pincode, 1);
  2887.                 $log_data = $api_log_info." | getpincodeInfo :".json_encode($getpincodeInfo);
  2888.                 SELF::createApiLog($log_data);
  2890.                 if((!empty($getpincodeInfo))){
  2892.                     $loc_name = $loc_code = '';
  2894.                     $location_name = (!empty($getpincodeInfo->getlocation_code()))?$getpincodeInfo->getlocation_code():"";
  2896.                     $log_data = $api_log_info." | location_name:".json_encode($location_name);
  2897.                     SELF::createApiLog($log_data);
  2899.                     if(!empty($location_name)){
  2900.                         $getlocationInfo = DataObject\Locations::getBylocation_name($location_name, 1);
  2902.                         $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2903.                         SELF::createApiLog($log_data);
  2905.                         if((!empty($getlocationInfo))){
  2906.                             $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2907.                             $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2908.                         } 
  2910.                         $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2911.                         SELF::createApiLog($log_data);                     
  2912.                     }
  2914.                     $data = array("pincode" => $getpincodeInfo->getpincode(),
  2915.                                     "store_code" => $loc_code,
  2916.                                     "location_name" => $loc_name,
  2917.                                     "city_name" => $getpincodeInfo->getcity(),
  2918.                                     "state" => $getpincodeInfo->getstate(),
  2919.                                     "delivery_type" => $getpincodeInfo->getdeliverytype(),
  2920.                                     "is_shipping_applicable" => $getpincodeInfo->getis_shipping_applicable(),
  2921.                                     "merichakki_available" => $getpincodeInfo->getmerichakki_available(),
  2922.                                     "nammachakki_available" => $getpincodeInfo->getnammachakki_available(),
  2923.                                     "vin_instance" => $getpincodeInfo->getvin_instance(),
  2924.                                 );
  2926.                 } else {
  2927.                     $data = "You are entered Pincode is Invalid, Please try again";
  2928.                 }
  2929.                 $log_data = $api_log_info." | data :".json_encode($data);
  2930.                 SELF::createApiLog($log_data);  
  2932.             }elseif($request->get('city_name')){
  2933.                 $city = $request->get('city_name');
  2935.                 $log_data = $api_log_info." | city :".json_encode($city);
  2936.                 SELF::createApiLog($log_data);  
  2938.                 $entries = new DataObject\ItcAddPincode\Listing();
  2939.                 $entries->setCondition("city = :name OR location_code = :name", ["name" => $city,"location_code" => $city]);
  2940.                 $entries->setLimit(1);
  2941.                 $entries->load();
  2943.                 $log_data = $api_log_info." | entries count :".json_encode(count($entries));
  2944.                 SELF::createApiLog($log_data);  
  2946.                 foreach($entries as $key => $entrie){
  2948.                     $log_data = $api_log_info." | entrie :".json_encode($entrie);
  2949.                     SELF::createApiLog($log_data); 
  2951.                     $loc_name = $loc_code = '';
  2953.                     $location_name = (!empty($entrie->getlocation_code()))?$entrie->getlocation_code():"";
  2955.                     $log_data = $api_log_info." | location_name:".json_encode($location_name);
  2956.                     SELF::createApiLog($log_data);
  2958.                     if(!empty($location_name)){
  2959.                         $getlocationInfo = DataObject\Locations::getBylocation_name($location_name, 1);
  2961.                         $log_data = $api_log_info." | getlocationInfo :".json_encode($getlocationInfo);
  2962.                         SELF::createApiLog($log_data);
  2964.                         if((!empty($getlocationInfo))){
  2965.                             $loc_name = (!empty($getlocationInfo->getlocation_name()))?$getlocationInfo->getlocation_name():'';
  2966.                             $loc_code = (!empty($getlocationInfo->getlocation_code()))?$getlocationInfo->getlocation_code():'';
  2967.                         } 
  2969.                         $log_data = $api_log_info." | loc_name :".json_encode($loc_name)." | loc_code :".json_encode($loc_code);
  2970.                         SELF::createApiLog($log_data);                     
  2971.                     }
  2973.                     $data = array("pincode" => $entrie->getpincode(),
  2974.                                     "store_code" => $loc_code,
  2975.                                     "location_name" => $loc_name,
  2976.                                     "city_name" => $entrie->getcity(),
  2977.                                     "state" => $entrie->getstate(),
  2978.                                     "delivery_type" => $entrie->getdeliverytype(),
  2979.                                     "is_shipping_applicable" => $entrie->getis_shipping_applicable(),
  2980.                                     "merichakki_available" => $entrie->getmerichakki_available(),
  2981.                                     "nammachakki_available" => $entrie->getnammachakki_available(),
  2982.                                     "vin_instance" => $entrie->getvin_instance(),
  2983.                                 );
  2984.                 }
  2985.             }  else {
  2986.                 $data = "Pincode is mandatory";
  2987.             }      
  2988.         } 
  2989.         else
  2990.             $data[] = ['message'=>$message];
  2992.         if(!empty($data)){
  2994.             $success = (empty($data['pincode'])) ? false : true;
  2995.             if ($success) {
  2996.                 return $this->json(["success" => $success, "data" => $data]);
  2997.             } else {
  2998.                 return $this->json(["success" => $success, 'message' => $data]);
  2999.             }
  3000.         }else{
  3001.             return $this->json(["success" => false, "message" => "Service not available"]);
  3002.         }
  3003.       
  3004.      }
  3005.     /*------------------------------ End of Pincode Related APIs -------------------------*/
  3006.     /*---------------------------------- Voucher Related APIs ----------------------------*/
  3007.     /**
  3008.      * @Route("api/getvouchersdata", methods={"POST"})
  3009.      */
  3010.     public function getvouchersdataAction(Request $request)
  3011.     {
  3012.         $api_log_info = "API:Get Vouchers list by multiple voucher codes - ".date("YmdHis")." ".time();
  3013.         $log_data = "Started - ".$api_log_info;
  3014.         SELF::createApiLog($log_data);
  3016.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3018.         $log_data = $api_log_info." | reqparams:".json_encode($reqparams);
  3019.         SELF::createApiLog($log_data);
  3021.         $vouchercodes = (isset($reqparams['vouchercodes']))?$reqparams['vouchercodes']:'';
  3022.         $vouchertype = (isset($reqparams['vouchertype']))?$reqparams['vouchertype']:'';
  3024.         $log_data = $api_log_info." | vouchercodes:".json_encode($vouchercodes)." | vouchertype:".json_encode($vouchertype);
  3025.         SELF::createApiLog($log_data);
  3027.         // $factorycode = $request->get('factorycode');
  3029.         if(($vouchercodes == "" || !is_array($vouchercodes)) && ($vouchertype == '' || ($vouchertype && !in_array($vouchertype, ["Master", "all"]))))
  3030.         {
  3031.             
  3032.             $data = "Voucher Code(s) OR Voucher Type is(are) mandatory, Voucher Type must be like Master OR all!";
  3034.             $log_data = $api_log_info." | data:".json_encode($data);
  3035.             SELF::createApiLog($log_data);
  3036.         } else 
  3037.         {
  3038.             // die;
  3039.             $data = SELF::verifyauthToken($api_log_info);
  3041.             $log_data = $api_log_info." | data:".json_encode($data);
  3042.             SELF::createApiLog($log_data);
  3044.             if($data == "No data found")
  3045.             {
  3046.                 $vouchertype = ($vouchertype == 'all')?'Voucher':$vouchertype;
  3048.                 /*---- Get Master Voucher data by Master Voucher Code ---------*/
  3049.                 $master_voucher = "Master_Voucher";
  3050.                 $masterVoucherData = DataObject\Vouchers::getByvoucher_code($master_voucher, 1);
  3051.                 
  3052.                 $projectUrl  = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off' ? 'https://' : 'http://';
  3053.                 $projectUrl .= $_SERVER['SERVER_NAME'];
  3054.                 $log_data = $api_log_info." | projectUrl:".json_encode($projectUrl);
  3055.                 SELF::createApiLog($log_data);
  3057.                 /*---- Check Factory by Code ---------*/
  3058.                 $vouchersData = new DataObject\Vouchers\Listing();
  3059.                 if($vouchercodes)
  3060.                 $vouchersData->setCondition("voucher_code IN (?)", [$vouchercodes]);
  3061.                 else if($vouchertype)
  3062.                 $vouchersData->setCondition("voucher_type IN (?)", [$vouchertype]);
  3063.                 $vouchersData->load();
  3065.                 $log_data = $api_log_info." | vouchersData count:".json_encode(count($vouchersData));
  3066.                 SELF::createApiLog($log_data);
  3068.                 if(!empty($vouchersData) && count($vouchersData)>0){
  3069.                     $data = [];
  3070.                     foreach($vouchersData as $voucherData){
  3072.                         $log_data = $api_log_info." | voucherData:".json_encode($voucherData);
  3073.                         SELF::createApiLog($log_data);
  3075.                         $voucher_logo_path = ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getvoucher_logo():$voucherData->getvoucher_logo();
  3076.                         $voucher_logo_path = $projectUrl."/uploads/".$voucher_logo_path;
  3077.                         $voucher_background_image_path = $projectUrl."/uploads/".($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getvoucher_background_image():$voucherData->getvoucher_background_image();
  3078.                         $voucher_background_image_path = $projectUrl."/uploads/".$voucher_background_image_path;
  3080.                         $curdata = array(
  3081.                             "id" => $voucherData->getId(),
  3082.                             "voucher_code" => $voucherData->getvoucher_code(),
  3083.                             "about_offer" => ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getabout_offer():$voucherData->getabout_offer(),
  3084.                             "avail_offer" => ($voucherData->getvoucher_type() == "Master")?$masterVoucherData->getavail_offer():$voucherData->getavail_offer(),
  3085.                             "voucher_logo_path" => $voucher_logo_path,
  3086.                             "voucher_background_image_path" => $voucher_background_image_path);
  3088.                         $log_data = $api_log_info." | curdata:".json_encode($curdata);
  3089.                         SELF::createApiLog($log_data);
  3091.                         array_push($data, $curdata);
  3093.                     }
  3094.                 } else {
  3095.                     $data = "No data found!";
  3096.                     $log_data = $api_log_info." | data:".json_encode($data);
  3097.                     SELF::createApiLog($log_data);
  3098.                 }
  3099.             }
  3100.         }
  3102.         $return_data = ["success" => true, "data" => $data];
  3104.         $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  3105.         SELF::createApiLog($log_data);
  3107.         return $this->json(["success" => true, "data" => $data]);
  3108.     }
  3109.     /*------------------------------ End of Voucher Related APIs -------------------------*/
  3111.     /*---------------------------------- Log Related APIs ----------------------------*/
  3112.     /**
  3113.      * @Route("/api/log_info/{date?}")
  3114.      */
  3115.     public function log_infoAction($date)
  3116.     {
  3117.         // $date = ($date == '')?date("Y-m-d", strtotime("-1 day")):$date;
  3118.         $date = ($date == '')?date("Y-m-d"):$date;
  3119.         if($date == '')
  3120.         {
  3121.             $data = "Date is mandatory!";
  3122.         } else {
  3123.             $file = '../var/log/slot-api-log_'.$date.'.txt';
  3124.             if(file_exists($file)){
  3125.                 $myfile = fopen($file, "r") or die("Unable to open file!");
  3126.                 $data = fread($myfile,filesize($file));
  3127.                 fclose($myfile);
  3128.             } else {
  3129.                 $data = "The file is not exited!";
  3130.             }
  3131.         }
  3132.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3133.     }
  3135.     /**
  3136.      * @Route("/api/log_info_data")
  3137.      */
  3138.     public function log_info_dataAction(Request $requet)
  3139.     {
  3140.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3142.         $date = (isset($reqparams['date']))?$reqparams['date']:'';
  3143.         $from_line = (isset($reqparams['from_line']))?$reqparams['from_line']:'';
  3144.         $to_line = (isset($reqparams['to_line']))?$reqparams['to_line']:'';
  3146.         $date = ($date == '')?date("Y-m-d"):$date;
  3147.         if($date == '' || $from_line == '' || $to_line == '')
  3148.         {
  3149.             $data = "Date, from_line and to_line are mandatory!";
  3150.         } else {
  3151.             $file = '../var/log/slot-api-log_'.$date.'.txt';
  3152.             if(file_exists($file)){
  3153.                 $splitdata = array_slice(file($file), $from_line, $to_line);
  3154.                 echo $data = implode('', $splitdata); die;
  3155.             } else {
  3156.                 $data = "The file is not exited!";
  3157.             }
  3158.         }
  3159.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3160.     }
  3162.     /**
  3163.      * @Route("/api/delete_log_file/{date}")
  3164.      */
  3165.     public function delete_log_fileAction($date)
  3166.     {
  3167.         if($date == '')
  3168.         {
  3169.             $data = "Date is mandatory!";
  3170.         } else {
  3172.             $message = SELF::verifyauthToken();
  3173.         
  3174.             if($message == "No data found")
  3175.             {
  3176.                 $file = '../var/log/slot-api-log_'.$date.'.txt';
  3177.                 if(file_exists($file)){
  3178.                     unlink($file);
  3179.                     $data = "Deleted the file successfully!";
  3180.                 } else {
  3181.                     $data = "The file is not exited!";
  3182.                 }
  3183.             }else $data[] = ['message'=>$message];
  3184.         }
  3185.         return $this->json(["success" => true, "date" => $date, "data" => $data]);
  3186.     }
  3188.     /**
  3189.      * @Route("/api/delete_log_files")
  3190.      */
  3191.     public function delete_log_filesAction(Request $request)
  3192.     {
  3193.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3195.         $fromdate = (isset($reqparams['fromdate']))?$reqparams['fromdate']:'';
  3196.         $todate = (isset($reqparams['todate']))?$reqparams['todate']:'';
  3198.         if($fromdate == '' || $todate == '')
  3199.         {
  3200.             $data = "From Date and To Date are mandatory!";
  3201.         } else {
  3202.             $message = SELF::verifyauthToken();
  3203.         
  3204.             if($message == "No data found")
  3205.             {
  3206.                 $rangeDates = SELF::getDatesFromRange($fromdate, $todate);
  3207.                 // echo 'rangeDates:<pre>';
  3208.                 // print_r($rangeDates); die;
  3209.                 foreach($rangeDates as $rangeDateInfo){
  3210.                     $file = '../var/log/slot-api-log_'.$rangeDateInfo.'.txt';
  3211.                     if(file_exists($file)){
  3212.                         unlink($file);
  3213.                         $data = "Deleted the file successfully!";
  3214.                     } else {
  3215.                         $data = (isset($data) && $data == "Deleted the file successfully!")?$data:"The file is not exited!";
  3216.                     }
  3217.                 }
  3218.             }else $data[] = ['message'=>$message];
  3219.         }
  3220.         return $this->json(["success" => true, "fromdate" => $fromdate, "todate" => $todate, "data" => $data]);
  3221.     }
  3224.     /**
  3225.      * @Route("/api/get_log_files")
  3226.      */
  3227.     public function get_log_filesAction(Request $request)
  3228.     {
  3229.         $reqparams = (array) json_decode(file_get_contents('php://input'), TRUE);
  3231.         $fromdate = (isset($reqparams['fromdate']))?$reqparams['fromdate']:'';
  3232.         $todate = (isset($reqparams['todate']))?$reqparams['todate']:'';
  3234.         $filenames = [];
  3236.         if($fromdate == '' || $todate == '')
  3237.         {
  3238.             $data = "From Date and To Date are mandatory!";
  3239.         } else {
  3240.             $message = SELF::verifyauthToken();
  3241.         
  3242.             if($message == "No data found")
  3243.             {
  3244.                 $rangeDates = SELF::getDatesFromRange($fromdate, $todate);
  3245.                 // echo 'rangeDates:<pre>';
  3246.                 // print_r($rangeDates); die;
  3247.                 foreach($rangeDates as $rangeDateInfo){
  3248.                     $file = '../var/log/slot-api-log_'.$rangeDateInfo.'.txt';
  3249.                     if(file_exists($file)){
  3250.                         array_push($filenames, 'slot-api-log_'.$rangeDateInfo.'.txt');
  3251.                     } else {
  3252.                         $msg = (!empty($filenames))?'':"The file is not exited!";
  3253.                     }
  3254.                 }
  3256.                 $data = (!empty($filenames))?$filenames:$msg;
  3258.             }else $data[] = ['message'=>$message];
  3259.         }
  3260.         return $this->json(["success" => true, "fromdate" => $fromdate, "todate" => $todate, "data" => $data]);
  3261.     }
  3262.     /*------------------------------ End of Log Related APIs -------------------------*/
  3264.     /**
  3265.      * @Route("/location/locationslist")
  3266.      */
  3267.     public function locationslist()
  3268.     {
  3269.         $log_data = "Started - API:Get All Locations";
  3270.         SELF::createApiLog($log_data);
  3272.         $message = SELF::verifyauthToken();
  3274.         $log_data = "API:Get All Locations | message:".json_encode($message);
  3275.         SELF::createApiLog($log_data);
  3277.         if($message == "No data found")
  3278.         {
  3279.             $locationsList = DataObject\Locations::getList();
  3280.             $locationsList->load();
  3282.             $log_data = "API:Get All Locations | locationsList count :".json_encode(count($locationsList));
  3283.             SELF::createApiLog($log_data);
  3285.             if(count($locationsList) > 0){
  3286.                 foreach ($locationsList as $key => $location) {
  3288.                     $log_data = "API:Get All Locations | location :".json_encode($location);
  3289.                     SELF::createApiLog($log_data);
  3291.                     $data[] = array(
  3292.                         "Id" => $location->getId(),
  3293.                         "location_name" => $location->getLocation_name(),
  3294.                         "location_code" => $location->getLocation_code());
  3296.                     $log_data = "API:Get All Locations | data :".json_encode($data);
  3297.                     SELF::createApiLog($log_data);
  3298.                 }
  3299.             } else $data[] = ['message'=>$message];
  3300.         } else $data[] = ['message'=>$message];
  3302.         $log_data = "Ended - API:Get All Locations | data :".json_encode($data);
  3303.         SELF::createApiLog($log_data);
  3304.         
  3305.         return $this->json(["success" => true, "data" => $data]);
  3306.     }
  3308.     /*--------------- Authentication related methods ----------------*/
  3309.     public function generateAuthToken($userInfo=[])
  3310.     {
  3311.         /*------------- Generate MDF encode --------------*/
  3312.         $generateAuthToken = md5(time());
  3314.         $jwtdata = array(
  3315.             "generateAuthToken" => $generateAuthToken
  3316.         );
  3318.         /*------------- Generate JWT Token ---------------*/
  3319.         $jwt_check = 0;
  3320.         if(!empty($userInfo)){
  3321.             $id = $userInfo['id'];//1024;
  3322.             $firstname = $userInfo['firstname'];//'Tex';
  3323.             $lastname = $userInfo['lastname'];//'Hardrock';
  3324.             $email = $userInfo['email'];//'dino@stone.age';
  3326.             $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  3327.             $issuer_claim = "pimcore6.local"; // this can be the servername
  3328.             $audience_claim = "Babu";
  3329.             $issuedat_claim = time(); // issued at
  3330.             $notbefore_claim = $issuedat_claim + 10; //not before in seconds
  3331.             $expire_claim = $issuedat_claim + 60*5; // expire time in seconds
  3332.             $token = array(
  3333.                 "iss" => $issuer_claim,
  3334.                 "aud" => $audience_claim,
  3335.                 "iat" => $issuedat_claim,
  3336.                 "nbf" => $notbefore_claim,
  3337.                 "exp" => $expire_claim,
  3338.                 "data" => array(
  3339.                     "id" => $id,
  3340.                     "firstname" => $firstname,
  3341.                     "lastname" => $lastname,
  3342.                     "email" => $email
  3343.             ));
  3345.             $jwt = JWT::encode($token, $secret_key, 'HS256');
  3346.             
  3347.             $jwtdata = array(
  3348.                 "generateAuthToken" => $generateAuthToken,
  3349.                 "jwt" => $jwt,
  3350.                 "email" => $email,
  3351.                 "expireAt" => $expire_claim
  3352.             );
  3353.         }
  3354.         return $jwtdata;
  3355.     }
  3357.     public function verifyauthToken1()
  3358.     {
  3359.         $message = "No data found"; $tokenCheck = 0;
  3360.         $headers=array();
  3361.         foreach (getallheaders() as $name => $value) {
  3362.             $headers[$name] = $value;
  3363.             if($name == 'Authtoken') $tokenCheck = 1;
  3364.         }
  3365.         if($tokenCheck == 0){
  3366.             $message = "Authentication Token is missing";;
  3367.         } else {
  3368.             $Authtoken = $headers['Authtoken'];
  3369.         
  3370.             $dbConnection = \Pimcore\Db::get();
  3371.             $authTokencheck = $dbConnection->fetchOne("SELECT id FROM users WHERE authToken = '".$Authtoken."' ");
  3373.             if(empty($authTokencheck)){
  3374.                 $message = "Authentication Token is mismatch";
  3375.             } else {
  3377.             }
  3378.         }
  3380.         return $message;
  3381.     }
  3383.     public function verifyauthToken2()
  3384.     {
  3385.         $api_key = 'api-key';
  3386.         $api_key_value = 'cGltY29yZWFwaWtleXZhbHVl';//base64encode('pimcoreapikeyvalue);
  3388.         $message = "No data found"; $tokenCheck = 0; $apikeyCheck = 0; $jwtCheck = 0;$tokenMsg = ''; $apikeyMsg = ''; $jwtMsg = '';
  3389.         $headers=array();
  3390.         foreach (getallheaders() as $name => $value) {
  3391.             $headers[$name] = $value;
  3392.             if($name == 'Authtoken') $tokenCheck = 1;
  3393.             if($name == 'Api-Key') $apikeyCheck = 1;
  3394.             if($name == 'Authorization') $jwtCheck = 1;
  3395.         }
  3397.         // echo 'arr:<pre>';
  3398.         // print_r($headers); 
  3399.         // die;
  3400.         if($tokenCheck == 0 && $apikeyCheck == 0 && $jwtCheck == 0){
  3401.             $message = "Fill any one of the Authentication Token, Api-Key Or JWT token!";;
  3402.         } else {
  3403.             $tokenCheck_valid = 0; $apikeyCheck_valid = 0; $jwtTokenCheck_valid = 0;
  3405.             /*--------------------- Validating Auth Token -----------------*/
  3406.             if($tokenCheck == 1)
  3407.             {
  3408.                 $Authtoken = $headers['Authtoken'];
  3409.         
  3410.                 $dbConnection = \Pimcore\Db::get();
  3411.                 $authTokencheck = $dbConnection->fetchOne("SELECT id FROM users WHERE authToken = '".$Authtoken."' ");
  3413.                 if(empty($authTokencheck)){
  3414.                     $tokenMsg = "Authentication Token is mismatch";
  3415.                 } else {
  3416.                     $tokenCheck_valid = 1;
  3417.                 }
  3418.             }
  3420.             /*--------------------- Validating Api Key -----------------*/
  3421.             if($apikeyCheck == 1)
  3422.             {
  3423.                 $AuthApikey = $headers['Api-Key'];
  3425.                 if(empty($AuthApikey)){
  3426.                     $apikeyMsg = "Key is mismatch";
  3427.                 } else if($AuthApikey != $api_key_value){
  3428.                     $apikeyMsg = "key is mismatch";
  3429.                 } else {
  3430.                     $apikeyCheck_valid = 1;
  3431.                 }
  3432.             }
  3434.             /*--------------------- Validating JWT Token -----------------*/
  3435.             if($jwtCheck == 1)
  3436.             {
  3437.                 $secret_key = "951e345a17ab26f80ec0e16b1d2a0c2a";
  3438.                 $jwt = null;
  3440.                 $authHeader = $_SERVER['HTTP_AUTHORIZATION'];
  3442.                 $arr = explode(" ", $authHeader);
  3443.                 $jwt = $arr[1];
  3445.                 if($jwt){
  3446.                     try {
  3447.                         $decoded = JWT::decode($jwt, new Key($secret_key, 'HS256'));
  3448.                         $jwtTokenCheck_valid = 1;
  3449.                     }catch (ExpiredException $e){
  3450.                         $jwtMsg = "Expired JWT Token!";//$e->getMessage();
  3451.                     }catch (Exception $e){
  3452.                         $jwtTokenCheck_valid = 0;
  3453.                         $jwtMsg = "Expired JWT Token!";//$e->getMessage();
  3454.                     }
  3455.                 } else {
  3456.                     $jwtMsg = "JWT Token is missing";
  3457.                 }
  3458.             }
  3460.             $message = '';
  3461.             if($tokenMsg != '' || $apikeyMsg != '' || $jwtMsg != '')
  3462.             {
  3463.                 $message = ($tokenMsg != '')?"Token Message:".$message.$tokenMsg:$message;
  3464.                 $message = ($apikeyMsg != '')?"".$message." | Api-Key Message:".$apikeyMsg:$message;
  3465.                 $message = ($jwtMsg != '')?"".$message." | JWT Message:".$jwtMsg:$message;
  3466.             }
  3468.             $message = ($tokenCheck_valid == 1 || $apikeyCheck_valid == 1 || $jwtTokenCheck_valid == 1)?"No data found":$message;
  3469.         }
  3471.         return $message;
  3472.     }
  3474.     public function verifyauthToken($api_log_info='')
  3475.     {        
  3476.         $start_method_log_info = "Verify Auth Token Method";
  3477.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Started - ".$start_method_log_info:"Started - ".$start_method_log_info;
  3478.         $log_data = $api_log_method_info;
  3479.         SELF::createApiLog($log_data);
  3481.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | ".$start_method_log_info:$start_method_log_info;
  3483.         $api_key = 'api-key';
  3484.         $api_key_value = 'cGltY29yZWFwaWtleXZhbHVl';//base64encode('pimcoreapikeyvalue);
  3486.         $message = "No data found"; $apikeyCheck = 0; $apikeyMsg = '';
  3487.         $headers=array();
  3488.         foreach (getallheaders() as $name => $value) {
  3489.             $headers[$name] = $value;
  3490.             if($name == 'Api-Key') $apikeyCheck = 1;
  3491.         }
  3493.         $log_data = $api_log_info." | headers - ".json_encode($headers)." | apikeyCheck:".$apikeyCheck;
  3494.         SELF::createApiLog($log_data);
  3495.         
  3496.         if($apikeyCheck == 0){
  3497.             $message = "Api-Key is mandatory!";;
  3498.         } else {
  3499.             $apikeyCheck_valid = 0;
  3501.             /*--------------------- Validating Api Key -----------------*/
  3502.             if($apikeyCheck == 1)
  3503.             {
  3504.                 $AuthApikey = $headers['Api-Key'];
  3506.                 if(empty($AuthApikey)){
  3507.                     $message = "Key is empty, Api-Key is mandatory";
  3508.                 } else if($AuthApikey != $api_key_value){
  3509.                     $message = "key is mismatch";
  3510.                 } else {
  3511.                     $apikeyCheck_valid = 1;
  3512.                 }
  3513.             }
  3514.         }
  3516.         // $apikeyCheck_valid = 1;
  3517.         // $message = "No data found";
  3519.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Ended - ".$start_method_log_info:"Ended - ".$start_method_log_info;
  3520.         $log_data = $api_log_method_info." | message:".$message;
  3521.         SELF::createApiLog($log_data);
  3523.         return $message;
  3524.     }
  3525.     /*--------------- End of Authentication related methods ------------*/
  3527.     /*-------------------------- Sub methods ---------------------------*/
  3528.     public function generateObjFolder($folderName,$location_code){
  3530.         $yr = date("Y");
  3531.         $mt = date("M");
  3532.         $dy = date("d");
  3534.         $path = "/".$folderName."/".$yr."/".$mt."/".$dy;
  3535.         $path = "/".$folderName."/".$location_code;
  3537.         $object = DataObject::getByPath($path);
  3538.         if(!$object){
  3539.             $path1 = "/".$folderName."/".$yr."/".$mt;
  3540.             $object1 = DataObject::getByPath($path1);
  3541.             if(!$object1){
  3542.                 $path2 = "/".$folderName."/".$yr;
  3543.                 $object2 = DataObject::getByPath($path2);                
  3544.                 if(!$object2){
  3545.                     $path3 = "/".$folderName;
  3546.                     $object3 = DataObject::getByPath($path3);                
  3547.                     if(!$object3){
  3548.                         $createAssetFolder = DoService::createFolderByPath($path3);
  3549.                         $createAssetFolder = DoService::createFolderByPath($path2);
  3550.                         $createAssetFolder = DoService::createFolderByPath($path1);
  3551.                         $createAssetFolder = DoService::createFolderByPath($path);
  3552.                         $objParentId = $createAssetFolder->getId();
  3553.                     }else {
  3554.                         $createAssetFolder = DoService::createFolderByPath($path2);
  3555.                         $createAssetFolder = DoService::createFolderByPath($path1);
  3556.                         $createAssetFolder = DoService::createFolderByPath($path);
  3557.                         $objParentId = $createAssetFolder->getId();
  3558.                     }
  3560.                 }else {
  3561.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3562.                     $createAssetFolder = DoService::createFolderByPath($path);
  3563.                     $objParentId = $createAssetFolder->getId();
  3564.                 }
  3566.             } else {
  3567.                 $createAssetFolder = DoService::createFolderByPath($path);
  3568.                 $objParentId = $createAssetFolder->getId();
  3569.             }
  3570.         } else
  3571.         $objParentId = $object->getId();
  3573.         return $objParentId;
  3574.     }
  3576.     public function generateSlotObjFolder($folderName,$delivery_mode,$location_code){
  3578.         $yr = date("Y");
  3579.         $mt = date("M");
  3580.         $dy = date("d");
  3582.         $path = "/".$folderName."/".$delivery_mode."/".$location_code;//."/".$date.'-'.$location_code;
  3584.         $object = DataObject::getByPath($path);
  3585.         if(!$object){
  3586.             $path1 = "/".$folderName."/".$delivery_mode;//."/".$location_code."/".$date;
  3587.             $object1 = DataObject::getByPath($path1);
  3588.             if(!$object1){
  3589.                 $path2 = "/".$folderName;//."/".$delivery_mode."/".$location_code;
  3590.                 $object2 = DataObject::getByPath($path2);                
  3591.                 if(!$object2){
  3592.                     $createAssetFolder = DoService::createFolderByPath($path2);
  3593.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3594.                     $createAssetFolder = DoService::createFolderByPath($path);
  3595.                     $objParentId = $createAssetFolder->getId();
  3596.                 }else {
  3597.                     $createAssetFolder = DoService::createFolderByPath($path1);
  3598.                     $createAssetFolder = DoService::createFolderByPath($path);
  3599.                     $objParentId = $createAssetFolder->getId();
  3600.                 }
  3601.             } else {
  3602.                 $createAssetFolder = DoService::createFolderByPath($path);
  3603.                 $objParentId = $createAssetFolder->getId();
  3604.             }
  3605.         } else
  3606.         $objParentId = $object->getId();
  3608.         return $objParentId;
  3609.     }
  3611.     public function getWeekDates($holidaysList, $todaydate, $delSlotTimesAvailibility){
  3612.         $jj=0; $weekdates = [];
  3614.         $slot_prepare_days = $delSlotTimesAvailibility['slot_prepare_days'];
  3615.         $slot_generate_days = $delSlotTimesAvailibility['slot_generate_days'];
  3616.         $saturday_slot_availability = $delSlotTimesAvailibility['saturday_slot_availability'];
  3617.         $sunday_slot_availability = $delSlotTimesAvailibility['sunday_slot_availability'];
  3619.         $todaydate = date('Y-m-d', strtotime($todaydate . ' +'.$slot_prepare_days.' day'));
  3621.         $totDays = $slot_generate_days+7;
  3623.         for($ii=1; $ii<$totDays; $ii++)
  3624.         {
  3625.             if($jj >= $slot_generate_days) break;
  3626.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3628.                 $weekDay = date('w', strtotime($todaydate));
  3629.                 if(($weekDay == 0 && $sunday_slot_availability == 'Yes') || ($weekDay == 6 && $saturday_slot_availability == 'Yes') || !in_array($weekDay, [0,6]))
  3630.                 {
  3631.                     $weekdates[] = $todaydate;
  3632.                     $jj=$jj+1;
  3633.                 }
  3634.             }
  3635.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3636.         }
  3638.         // echo '<pre>'; print_r($weekdates); die;
  3640.         return $weekdates;
  3641.     }
  3643.     public function getSettingInfo($api_log_info='')
  3644.     {
  3645.         $start_method_log_info = "Setting info Method";
  3646.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Started - ".$start_method_log_info:"Started - ".$start_method_log_info;
  3647.         $log_data = $api_log_method_info;
  3648.         SELF::createApiLog($log_data);
  3650.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | ".$start_method_log_info:$start_method_log_info;
  3652.         /*------ Get Settings Class data --------*/
  3653.         $dbConnection = \Pimcore\Db::get();
  3654.         $settingsClassId = $dbConnection->fetchOne(" SELECT id FROM classes WHERE LOWER(name) = 'Settings' ");
  3655.         $settingsObject = "object_".$settingsClassId;
  3656.         
  3657.         $log_data = $api_log_method_info." | settingsObject:".json_encode($settingsObject);
  3658.         SELF::createApiLog($log_data);
  3659.         
  3660.         $settingsId = $dbConnection->fetchOne(" select * from ".$settingsObject." WHERE setting_flag = 1");
  3661.         
  3662.         $log_data = $api_log_method_info." | settingsId:".json_encode($settingsId);
  3663.         SELF::createApiLog($log_data);
  3664.         /*----- End of Get Settings Class data ---------*/
  3666.         /*--------------- Settings info ----------------*/
  3667.         $settingsInfo = DataObject\Settings::getById($settingsId);
  3668.         
  3669.         $log_data = $api_log_method_info." | settingsInfo:".json_encode($settingsInfo);
  3670.         SELF::createApiLog($log_data);
  3672.         $settingDataId = $settingsInfo->getId();
  3673.         $setting_deliveryModes = $settingsInfo->getdelivery_modes();
  3674.         $setting_slot_time_flag = (!empty($settingsInfo->getslottime()))?$settingsInfo->getslottime():"18:00";
  3676.         $stg_deliveryslot_config_is_upcountry_configuration_applicable = ($settingsInfo->getdeliveryslot_config_is_upcountry_configuration_applicable())?$settingsInfo->getdeliveryslot_config_is_upcountry_configuration_applicable():'No';
  3678.         $stg_deliveryslot_config_is_darkstore_configuration_applicable = ($settingsInfo->getdeliveryslot_config_is_darkstore_configuration_applicable())?$settingsInfo->getdeliveryslot_config_is_darkstore_configuration_applicable():'No';
  3680.         $stg_delslot_normalloc_morethan_fromtime = ($settingsInfo->getdelslot_normalloc_morethan_fromtime())?$settingsInfo->getdelslot_normalloc_morethan_fromtime():"00:00";
  3681.         $stg_delslot_normalloc_lessthaneq_totime = ($settingsInfo->getdelslot_normalloc_lessthaneq_totime())?$settingsInfo->getdelslot_normalloc_lessthaneq_totime():"18:00";
  3682.         $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;
  3683.         $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;
  3685.         $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;
  3687.         $stg_delslot_upcountryloc_morethan_fromtime = ($settingsInfo->getdelslot_upcountryloc_morethan_fromtime())?$settingsInfo->getdelslot_upcountryloc_morethan_fromtime():"00:00";
  3688.         $stg_delslot_upcountryloc_lessthaneq_totime = ($settingsInfo->getdelslot_upcountryloc_lessthaneq_totime())?$settingsInfo->getdelslot_upcountryloc_lessthaneq_totime():"11:00";
  3689.         $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;
  3690.         $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;
  3692.         $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;
  3694.         $stg_delslot_darkstoreloc_morethan_fromtime = ($settingsInfo->getdelslot_darkstoreloc_morethan_fromtime())?$settingsInfo->getdelslot_darkstoreloc_morethan_fromtime():"00:00";
  3695.         $stg_delslot_darkstoreloc_lessthaneq_totime = ($settingsInfo->getdelslot_darkstoreloc_lessthaneq_totime())?$settingsInfo->getdelslot_darkstoreloc_lessthaneq_totime():"11:00";
  3696.         $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;
  3697.         $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;
  3699.         $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;
  3701.         $stg_is_deliveryfee_config_applicable = $settingsInfo->getis_deliveryfee_config_applicable();
  3702.         $stg_deliveryfee_config = $settingsInfo->getdeliveryfee_config();
  3703.         $stg_deliveryfee_config = $settingsInfo->getdeliveryfee_config();
  3704.         $stg_deliveryfee_config_location_lessthan_charge = $settingsInfo->getdeliveryfee_config_location_lessthan_charge();
  3705.         $stg_deliveryfee_config_location_greaterthanequal_charge = $settingsInfo->getdeliveryfee_config_location_greaterthanequal_charge();
  3707.         $stg_deliveryfee_config_upcountry_lessthan_charge = $settingsInfo->getdeliveryfee_config_upcountry_lessthan_charge();
  3708.         $stg_deliveryfee_config_upcountry_greaterthanequal_charge = $settingsInfo->getdeliveryfee_config_upcountry_greaterthanequal_charge();
  3709.         /*----------- End of Settings Info -------------*/
  3711.         $settingsdata = ['settingDataId'=>$settingDataId,
  3712.                         'setting_deliveryModes'=>$setting_deliveryModes,
  3713.                         'setting_slot_time_flag'=>$setting_slot_time_flag,
  3714.                         'stg_deliveryslot_config_is_upcountry_configuration_applicable'=>$stg_deliveryslot_config_is_upcountry_configuration_applicable,
  3715.                         'stg_deliveryslot_config_is_darkstore_configuration_applicable'=>$stg_deliveryslot_config_is_darkstore_configuration_applicable,
  3716.                         'stg_delslot_normalloc_morethan_fromtime'=>$stg_delslot_normalloc_morethan_fromtime,
  3717.                         'stg_delslot_normalloc_lessthaneq_totime'=>$stg_delslot_normalloc_lessthaneq_totime,
  3718.                         'stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_normalloc_bw_from_to_time_extra_generate_slotdays,
  3719.                         'stg_delslot_normalloc_after_totime_extra_generate_slotdays'=>$stg_delslot_normalloc_after_totime_extra_generate_slotdays,
  3720.                         'stg_normalloc_slot_generate_days'=>$stg_normalloc_slot_generate_days,
  3721.                         'stg_delslot_upcountryloc_morethan_fromtime'=>$stg_delslot_upcountryloc_morethan_fromtime,
  3722.                         'stg_delslot_upcountryloc_lessthaneq_totime'=>$stg_delslot_upcountryloc_lessthaneq_totime,
  3723.                         'stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_upcountryloc_bw_from_to_time_extra_generate_slotdays,
  3724.                         'stg_delslot_upcountryloc_after_totime_extra_generate_slotdays'=>$stg_delslot_upcountryloc_after_totime_extra_generate_slotdays,
  3725.                         'stg_upcountryloc_slot_generate_days'=>$stg_upcountryloc_slot_generate_days,
  3726.                         'stg_is_deliveryfee_config_applicable'=>$stg_is_deliveryfee_config_applicable,
  3727.                         'stg_deliveryfee_config'=>$stg_deliveryfee_config,
  3728.                         'stg_deliveryfee_config_location_lessthan_charge'=>$stg_deliveryfee_config_location_lessthan_charge,
  3729.                         'stg_deliveryfee_config_location_greaterthanequal_charge'=>$stg_deliveryfee_config_location_greaterthanequal_charge,
  3730.                         'stg_deliveryfee_config_upcountry_lessthan_charge'=>$stg_deliveryfee_config_upcountry_lessthan_charge,
  3731.                         'stg_deliveryfee_config_upcountry_greaterthanequal_charge'=>$stg_deliveryfee_config_upcountry_greaterthanequal_charge,
  3732.                         'stg_delslot_darkstoreloc_morethan_fromtime'=>$stg_delslot_darkstoreloc_morethan_fromtime,
  3733.                         'stg_delslot_darkstoreloc_lessthaneq_totime'=>$stg_delslot_darkstoreloc_lessthaneq_totime,
  3734.                         'stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays'=>$stg_delslot_darkstoreloc_bw_from_to_time_extra_generate_slotdays,
  3735.                         'stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays'=>$stg_delslot_darkstoreloc_after_totime_extra_generate_slotdays,
  3736.                         'stg_darkstoreloc_slot_generate_days'=>$stg_darkstoreloc_slot_generate_days,
  3737.                         ];
  3738.         
  3740.         $api_log_method_info = (!empty($api_log_info))?$api_log_info." | Ended - ".$start_method_log_info:"Ended - ".$start_method_log_info;
  3741.         $log_data = $api_log_method_info." | settingsdata:".json_encode($settingsdata);
  3742.         SELF::createApiLog($log_data);
  3743.         
  3744.         return $settingsdata;
  3745.     }
  3747.     function getDatesFromRange($start, $end, $dateformat="Y-m-d"){
  3748.         $dates = array($start);
  3749.         while(end($dates) < $end){
  3750.             $dates[] = date($dateformat, strtotime(end($dates).' +1 day'));
  3751.         }
  3752.         return $dates;
  3753.     }
  3755.     public function getSlotTimeDates($slot_generate_days, $todaydate){
  3756.         $jj=0; $weekdates = [];
  3758.         for($ii=1; $ii<15; $ii++)
  3759.         {
  3760.             if($jj >= 7) break;
  3761.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3762.                 $weekdates[] = $todaydate;
  3763.                 $jj=$jj+1;
  3764.             }
  3765.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3766.         }
  3768.         // echo '<pre>'; print_r($weekdates); die;
  3770.         return $weekdates;
  3771.     }
  3773.     public function getWorkingDate($slot_generate_days, $todaydate){
  3774.         $jj=0; $weekdates = [];
  3776.         for($ii=1; $ii<$slot_generate_days; $ii++)
  3777.         {
  3778.             if(empty($holidaysList) || !in_array($todaydate, $holidaysList)){
  3779.                 $weekdates[] = $todaydate;
  3780.                 $jj=$jj+1;
  3781.             }
  3782.             $todaydate = date('Y-m-d', strtotime($todaydate . ' +1 day'));
  3783.         }
  3785.         // echo '<pre>'; print_r($weekdates); die;
  3787.         return $weekdates;
  3788.     }
  3790.     public function createApiLog($content)
  3791.     {
  3792.         $file = '../var/log/slot-api-log_'.date("Y-m-d").'.txt';
  3793.         // chmod($file, 0755);
  3795.         // if(!is_file($file)){
  3796.             // $contents = 'This is a test!';           // Some simple example content.
  3797.             // file_put_contents($file, $content);     // Save our content to the file.
  3798.             file_put_contents($file, date("Y-m-d H:i:s")." | ".$content."\n", FILE_APPEND);
  3799.             chmod($file, 0755);
  3800.         // }
  3801.     }
  3802.     /*----------------------- End of Sub methods -----------------------*/
  3804.    /*------------------------------ Manufacture Related APIs -------------------------*/
  3805.     /**
  3806.      * @param Request $request
  3807.      * 
  3808.      * @Route("/manufacturers/{skucode?}")
  3809.      * 
  3810.      * @return Response
  3811.      * 
  3812.      */
  3813.     public function manufacturersAction($skucode='')
  3814.     {
  3815.        $api_log_info = "API:Get Manufacturers List with or without skucode - ".date("YmdHis")." ".time();
  3816.        $log_data = "Started - ".$api_log_info;
  3817.        SELF::createApiLog($log_data);
  3819.        $data = SELF::verifyauthToken($api_log_info);
  3821.        $log_data = $api_log_info." | data:".json_encode($data);
  3822.        SELF::createApiLog($log_data);
  3824.        if($data == "No data found")
  3825.        {
  3826.             $log_data = $api_log_info." | skucode:".json_encode($skucode);
  3827.             SELF::createApiLog($log_data);
  3828.     
  3829.             $entries = new DataObject\Manufacture\Listing();
  3831.             $whr_condition = " msku_code!= '' ";
  3832.             if($skucode != '')
  3833.             $whr_condition .= " AND msku_code= '".$skucode."' ";
  3834.             
  3835.             $entries->setCondition($whr_condition);
  3836.             $entries->load();
  3838.             $log_data = $api_log_info." | Manufacturers entries count :".json_encode(count($entries));
  3839.             SELF::createApiLog($log_data);
  3841.             $data = (count($entries)>0)?array():"No data found";
  3843.             foreach($entries as $key => $entrie){
  3845.                 $log_data = $api_log_info." | Manufacture key :".json_encode($key)." | Manufacture entrie :".json_encode($entrie);
  3846.                 SELF::createApiLog($log_data);
  3848.                 if($skucode) {
  3849.                     $data = array("Id" => $entrie->getId(),
  3850.                         "msku_code" => $entrie->getmsku_code(),
  3851.                         "sku_name" => $entrie->getsku_name(),
  3852.                         "primary_barcode" => $entrie->getprimary_barcode(),
  3853.                         "manufacture_details" => $entrie->getmanufacture_details(),
  3854.                     );
  3855.                 } else {
  3856.                     $data[] = array("Id" => $entrie->getId(),
  3857.                         "msku_code" => $entrie->getmsku_code(),
  3858.                         "sku_name" => $entrie->getsku_name(),
  3859.                         "primary_barcode" => $entrie->getprimary_barcode(),
  3860.                         "manufacture_details" => $entrie->getmanufacture_details(),
  3861.                     );
  3862.                 }
  3864.                 $log_data = $api_log_info." | data :".json_encode($data);
  3865.                 SELF::createApiLog($log_data);
  3866.             }
  3867.        }
  3869.        $return_data = ["success" => true, "data" => $data];
  3871.        $log_data = "Ended - ".$api_log_info." | return_data:".json_encode($return_data);
  3872.        SELF::createApiLog($log_data);
  3873.        
  3874.        return $this->json(["success" => true, "data" => $data]);
  3875.        
  3876.     }
  3877.    /*------------------------------ End of Manufacture Related APIs -------------------------*/
  3878.     
  3879. }