== 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); } ?> ==
No. | {% 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 | Brand | Restaurant | Town | Location | Store Comments | Date Of Creation | Status | {#% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %#}Admin Comments | Main. Comments | {#% 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") %}Technician | {% endif %} {#Tech. Comments | #}Should Delete | {% if userAccessLevel is same as("admin") %}Remove | {% endif %}||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
No. | {% 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 #} | Brand | Restaurant | Town | Location | {# Comment #} | Date Of Creation | Status | {#% 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 | {# Should Delete #} {% if userAccessLevel is same as("admin") %}{# Remove #} {% endif %} | ||||||||||||
{{ ticket.ticketID}} | {% if userAccessLevel is same as("admin") %}{% if ticket.important == 1 %} Yes {% else %} No {% endif %} | {#{% if ticket.OPS == 1 %} |
{#{% if ticket.DEV == 1 %}
|
{% endif %} {% if userAccessLevel is same as("store") %} | {%if ticket.OPS == 1 %}✔{% else %} ✕ {%endif%} | {%if ticket.DEV == 1 %}✔{% else %} ✕ {%endif%} | {%if ticket.MAIN == 1 %}✔{% else %} ✕ {%endif%} | {% endif %}
|
{{ ticket.brand }} | {{ ticket.resCode ~ '-' ~ ticket.resName}} | {{ ticket.cityDescription}} | {{ ticket.locDesc }} | {{ ticket.comments }} | {{ ticket.date_of_creation|date("d/m/Y") }} | {% if userAccessLevel is same as("store") %}{{ ticket.status }} | {% else %}{{ ticket.status }} | {% endif %} {# ADMIN COMMENTS #} {% if userAccessLevel is same as("admin") %}
{% if ticket.adminComments is empty %}
{{ ticket.adminComments }}
{% endif %}
|
{% 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") %}
{{ ticket.adminComments }} | {% endif %} {# MAIN COMMENTS #} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %}
{% if ticket.mainComments is empty %}
{{ ticket.mainComments }}
{% endif %}
|
{% 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") %}
{{ ticket.mainComments }} | {% endif %} {# DATES #} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %}
{% if ticket.execDateFrom is empty %}
{{ ticket.execDateFrom|date("d/m/Y") }} #}
{% endif %}
|
{#
{% if ticket.execDateTo is empty %}
{% else %}
| #}
{% endif %}
{# DATES #}
{% if userAccessLevel is same as("technical") or userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %}
{% 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 %} | #} {% endif %} {#{% if ticket.actualEndDate is not same as("0000-00-00") %} {{ ticket.actualEndDate is empty ? "" :ticket.actualEndDate|date("d/m/Y") }} {% endif %} | #} {# VISIT WEEK #} {% if userAccessLevel is same as("store") %} {% if ticket.execDateFrom is not null %}{{ ticket.execDateFrom|date("d/m") }} - {{ ticket.execDateFrom|date_modify("+7 day")|date("d/m") }} | {% else %}Not Set | {% endif %} {% endif %} {# USER #} {% if userAccessLevel is same as("admin") or userAccessLevel is same as("maintenance") %}{% endif %} {# USER #} {% if userAccessLevel is same as("store") %} | {% if ticket.user is null %} Unassigned {% else %} {{ ticket.name }} {% endif %} | {% endif %} {# USER #} {% if userAccessLevel is same as("ops") or userAccessLevel is same as("dev") %}{% if ticket.user is null %} Unassigned {% else %} {{ ticket.userName }} {% endif %} | {% endif %} {#{{ticket.techComments}} | #} {% 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") %}{% if ticket.shouldDelete == 1 %} Yes {% else %} No {% endif %} | {% endif %} {% if userAccessLevel is same as("admin") %}{% if ticket.shouldDelete == 1 %} Yes {% else %} No {% endif %} | {% endif %} {% if userAccessLevel is same as("admin") %}
|
{% endif %}