== brandCode; $status = $this->status; $cityCode = $this->cityCode; $restaurant = $this->restaurant; //this is run the first time the page loads when no data are passed to the partial so that we load all open tickets for all brands $firstLoad = false; //boolean to load correctly rhe mysq of the department if($brandCode == null){ $brandCode = 'all'; $status = 1; $firstLoad = true; } if($userAccessLevel == 'admin' || $userAccessLevel == 'ops' || $userAccessLevel == 'dev'){ $noFilter = $this->noFilter; $ops = $this->ops; $dev = $this->dev; $main = $this->main; Log::info($noFilter); Log::info($ops); Log::info($dev); Log::info($main); Log::info('brand'); Log::info($brandCode); $department = ""; if(!$firstLoad && $userAccessLevel == 'admin'){ if($noFilter == "true"){ $department = ""; }else{ if( $ops == "true" ){ $department .= "AND custom_tickets.OPS = 1 "; }else{ $department .= "AND custom_tickets.OPS = 0 "; } if( $dev == "true" ){ $department .= "AND custom_tickets.DEV = 1 "; }else{ $department .= "AND custom_tickets.DEV = 0 "; } if( $main == "true" ){ $department .= "AND custom_tickets.MAIN = 1 "; }else{ $department .= "AND custom_tickets.MAIN = 0 "; } } } Log::info('$department'); Log::info($department); if($userAccessLevel == 'ops'){ $access = "AND custom_tickets.OPS"; }else if($userAccessLevel == 'dev'){ $access = "AND custom_tickets.DEV"; }else{ $access = ""; } //when no brandcode is provided or bracode with all and status all if($brandCode == "all" || $brandCode == "" ){ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.code AS brandCode, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_status.id IN ('.$status.') '.$department.' AND custom_tickets.restaurant_id IN (SELECT custom_userRestaurantAccess.restaurantID FROM custom_userRestaurantAccess WHERE userID = '.$userId.') '.$access.' '); }else if($brandCode != "all"){ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.code AS brandCode, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_status.id IN ('.$status.') '.$department.' AND custom_cities.code = "'.$cityCode.'" AND custom_restaurants.id = "'.$restaurant.'" '.$access.' '); }else{ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.code AS brandCode, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_cities.code = ('.$cityCode.') '.$department.' AND custom_restaurants.id = "'.$restaurant.'" '.$access.' '); } $this['users'] = Db::select('SELECT u.id, u.name FROM custom_users AS u WHERE accessLevelCode="technical" AND archiveUser= 0 '); } if($userAccessLevel == 'store'){ $tickets = Db::select(' select custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId, custom_users.name AS name FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id LEFT JOIN custom_users on custom_tickets.responsible_user_id = custom_users.id WHERE custom_tickets.restaurant_id IN (SELECT custom_userRestaurantAccess.restaurantID FROM custom_userRestaurantAccess WHERE userID = '.$userId.')'); } if($userAccessLevel == 'maintenance'){ if($brandCode == "all" || $brandCode == "" ){ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_tickets.MAIN AND custom_status.id IN ('.$status.') '); }/*else if($brandCode == "all" && $status != "all"){ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_tickets.MAIN AND custom_status.id = "'.$status.'" '); }*/else if($brandCode != "all"){ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_tickets.MAIN AND custom_status.id IN ('.$status.') AND custom_cities.code = "'.$cityCode.'" AND custom_restaurants.id = "'.$restaurant.'" '); }else{ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.OPS AS OPS, custom_tickets.DEV AS DEV, custom_tickets.MAIN AS MAIN, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_tickets.MAIN AND custom_cities.code = "'.$cityCode.'" AND custom_restaurants.id = "'.$restaurant.'" '); } $this['users'] = Db::select('SELECT u.id, u.name FROM custom_users AS u WHERE accessLevelCode="technical" AND archiveUser= 0 '); } if($userAccessLevel == 'technical'){ $tickets = Db::select(' SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.main_comments AS mainComments, custom_tickets.shouldDelete, custom_tickets.seen, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets INNER JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id INNER JOIN custom_locations on custom_tickets.location_code = custom_locations.code INNER JOIN custom_cities on custom_restaurants.city = custom_cities.code INNER JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code INNER JOIN custom_status on custom_tickets.status = custom_status.id WHERE custom_tickets.responsible_user_id ="'.$userId.'" '); } /* if($userAccessLevel == 'ops' || $userAccessLevel == 'dev'){ if($userAccessLevel == 'ops'){ $access = "OPS"; }else{ $access = "DEV"; } $restaurants = Db::select("select custom_userRestaurantAccess.restaurantID from custom_userRestaurantAccess where custom_userRestaurantAccess.userID='".$userId."' "); $tempArr = ""; $counter = 0; foreach($restaurants as $r){ $tempArr .= "'".$r->restaurantID."'"; if($counter < count($restaurants)-1){ $tempArr .=','; } $counter++; } Log::info($tempArr); $tickets = Db::select(" SELECT custom_tickets.id AS ticketID, custom_tickets.important, custom_tickets.comments, custom_tickets.date_of_creation, custom_tickets.execution_date_from AS execDateFrom, custom_tickets.execution_date_to AS execDateTo, custom_tickets.actual_end_date AS actualEndDate, custom_tickets.responsible_user_id AS user, custom_users.name AS userName, custom_tickets.technician_comments AS techComments, custom_tickets.admin_comments AS adminComments, custom_tickets.shouldDelete, custom_restaurants.id AS resID, custom_restaurants.code AS resCode, custom_restaurants.name AS resName, custom_restaurants.city, custom_restaurants.isDeactivated, custom_locations.code AS locCode, custom_locations.description AS locDesc, custom_cities.cityDescription, custom_brands.description AS brand, custom_status.description AS status, custom_status.id AS statusId FROM custom_tickets LEFT JOIN custom_restaurants on custom_tickets.restaurant_id = custom_restaurants.id LEFT JOIN custom_locations on custom_tickets.location_code = custom_locations.code LEFT JOIN custom_cities on custom_restaurants.city = custom_cities.code LEFT JOIN custom_brands on custom_restaurants.brandCode = custom_brands.code LEFT JOIN custom_status on custom_tickets.status = custom_status.id LEFT JOIN custom_users on custom_users.id = custom_tickets.responsible_user_id WHERE custom_tickets.".$access." AND custom_restaurants.id IN (".$tempArr.") "); }*/ $this['tickets'] = $tickets; // dump($tickets); } ?> == {% if userAccessLevel is same as("admin")%} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("store") or userAccessLevel is same as("dev") or userAccessLevel is same as("ops") or userAccessLevel is same as("maintenance") %} {% endif %} {% if userAccessLevel is not same as("store") %} {% endif %} {#% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %#} {#% endif %#} {% if userAccessLevel is not same as("store") %} {% endif %} {##} {##} {% if userAccessLevel is same as("store") %} {% endif %} {% if userAccessLevel is not same as("technical") %} {% endif %} {##} {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") or userAccessLevel is same as("dev") or userAccessLevel is same as("ops") %} {% endif %} {# Should Delete #} {% if userAccessLevel is same as("admin")%} {# important #} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("store") or userAccessLevel is same as("dev") or userAccessLevel is same as("ops") or userAccessLevel is same as("maintenance") %} {# OPS #} {# DEV #} {# MAIN #} {% endif %} {# PHOTO #} {% if userAccessLevel is not same as("store") %} {% endif %} {# Comment #} {#% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %#} {# DEV COMMENT #} {#% endif %#} {% if userAccessLevel is not same as("store") %} {# Start Date #} {% endif %} {##} {# End Date #} {##} {# Actual End Date #} {% if userAccessLevel is same as("store") %} {# VISIT WEEK #} {% endif %} {% if userAccessLevel is not same as("technical") %} {# USER #} {% endif %} {##} {# Tech Comments #} {% if userAccessLevel is same as("admin") %} {# Remove #} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") or userAccessLevel is same as("dev") or userAccessLevel is same as("ops") %} {# Seen #} {% endif %} {% for ticket in tickets %} date(ticket.execDateFrom|date_modify("+1 day")) and (ticket.status == 'Open' or ticket.status == 'In Progress') %} class="visitWeekPast" {% endif %} > {#SHOULD DELETE#} {% if userAccessLevel is same as("maintenance") or userAccessLevel is same as("store") or userAccessLevel is same as("technical") or userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %} {% endif %} {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is same as("store") or userAccessLevel is same as("dev") or userAccessLevel is same as("ops") or userAccessLevel is same as("maintenance") %} {% endif %} {% if userAccessLevel is not same as("store") %} {% endif %} {% if userAccessLevel is same as("store") %} {% else %} {% endif %} {# ADMIN COMMENTS #} {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is same as("maintenance") or userAccessLevel is same as("store") or userAccessLevel is same as("technical") or userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %} {% endif %} {# MAIN COMMENTS #} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %} {% endif %} {% if userAccessLevel is same as("store") or userAccessLevel is same as("technical") or userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %} {% endif %} {# DATES #} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") or userAccessLevel is same as("dev") %} {# #} {% endif %} {# DATES #} {% if userAccessLevel is same as("technical") or userAccessLevel is same as("ops") %} {# #} {% endif %} {##} {# VISIT WEEK #} {% if userAccessLevel is same as("store") %} {% if ticket.execDateFrom is not null %} {% else %} {% endif %} {% endif %} {# USER #} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") or userAccessLevel is same as("dev") %} {% endif %} {# USER #} {% if userAccessLevel is same as("store") %} {% endif %} {# USER #} {% if userAccessLevel is same as("ops") %} {% endif %} {##} {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") or userAccessLevel is same as("dev") or userAccessLevel is same as("ops") %} {% endif %} {% endfor %}
Should Delete No.EmergencyOPS DEV MAINPhotoBrand RestaurantTown Location Store Comments Date Of Creation StatusAdmin Comments Main. CommentsStart DateEnd DateActual End DateVisit WeekTechnicianTech. CommentsRemoveSeen
Should DeleteNo.Brand RestaurantTown Location Date Of Creation Status
{% if ticket.shouldDelete == 1 %} Yes {% else %} No {% endif %} {% if ticket.shouldDelete == 1 %} Yes {% else %} No {% endif %} {{ ticket.ticketID}} {% if ticket.important == 1 %} Yes {% else %} No {% endif %} {#{% if ticket.OPS == 1 %} {#{% if ticket.DEV == 1 %} {%if ticket.OPS == 1 %}✔{% else %} ✕ {%endif%} {%if ticket.DEV == 1 %}✔{% else %} ✕ {%endif%} {%if ticket.MAIN == 1 %}✔{% else %} ✕ {%endif%}
{{ ticket.brand }} {{ ticket.resCode ~ '-' ~ ticket.resName}} {{ ticket.cityDescription}} {{ ticket.locDesc }} {{ ticket.comments }} {{ ticket.date_of_creation|date("d/m/Y") }} {{ ticket.status }} {{ ticket.status }} {% if ticket.adminComments is empty %} {% else %}
{{ ticket.adminComments }}
{% endif %}
{{ ticket.adminComments }} {% if ticket.mainComments is empty %} {% else %}
{{ ticket.mainComments }}
{% endif %}
{{ ticket.mainComments }} {% if ticket.execDateFrom is empty %} {% else %} {#
{{ ticket.execDateFrom|date("d/m/Y") }}
#} {% endif %}
{% if ticket.execDateTo is empty %} {% else %} {% endif %} {% if ticket.execDateFrom is empty %} Not set {% else %} {{ ticket.execDateFrom|date("d/m/Y") }} {% endif %} {% if ticket.execDateTo is empty %} Not set {% else %} {{ ticket.execDateTo|date("d/m/Y") }} {% endif %} {% if ticket.actualEndDate is not same as("0000-00-00") %} {{ ticket.actualEndDate is empty ? "" :ticket.actualEndDate|date("d/m/Y") }} {% endif %} {{ ticket.execDateFrom|date("d/m") }} - {{ ticket.execDateFrom|date_modify("+7 day")|date("d/m") }}Not Set {% if ticket.user is null %} Unassigned {% else %} {{ ticket.name }} {% endif %} {% if ticket.user is null %} Unassigned {% else %} {{ ticket.userName }} {% endif %} {{ticket.techComments}} {% if ticket.seen == 1 %} Yes {% else %} No {% endif %}
{% if tickets is empty %} {% endif %}