== 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 if($brandCode == null){ $brandCode = 'all'; $status = 1; } 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_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, custom_restaurants.code AS resCode, custom_restaurants.name AS resName 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.')'); } $this['tickets'] = $tickets; //dump($tickets); } ?> == {% if userAccessLevel is same as("admin")%} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is 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")%} {# important #} {% endif %} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("store") %} {# OPS #} {# DEV #} {# MAIN #} {% endif %} {# PHOTO #} {# 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 #} {# Should Delete #} {% if userAccessLevel is same as("admin") %} {# Remove #} {% endif %} {% for ticket in tickets %} date(ticket.execDateFrom|date_modify("+7 day")) and (ticket.status == 'Open' or ticket.status == 'In Progress') %} class="visitWeekPast" {% endif %}> {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is 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") %} {# #} {% endif %} {# DATES #} {% if userAccessLevel is same as("technical") or userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %} {# #} {% 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") %} {% endif %} {# USER #} {% if userAccessLevel is same as("store") %} {% endif %} {# USER #} {% if userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %} {% 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 %} {% if userAccessLevel is same as("admin") %} {% endif %} {% if userAccessLevel is same as("admin") %} {% endif %} {% endfor %}
No.ImportantOPS DEV MAINPhoto Brand Restaurant Town Location Store Comments Date Of Creation StatusAdmin Comments Main. CommentsStart DateEnd DateActual End DateVisit WeekTechnicianTech. CommentsShould DeleteRemove
No.Brand Restaurant Town Location Date Of Creation StatusShould Delete
{{ 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.shouldDelete == 1 %} Yes {% else %} No {% endif %} {% if ticket.shouldDelete == 1 %} Yes {% else %} No {% endif %}
{% if tickets is empty %} {% endif %}