# master_entities

uuid: ec1a01f7-e490-435d-964b-404491707774
name: User Grid
entity_name: user
entity_type: grid_builder_module
primary_table: users
created_at: 2024-09-04 03:56:40
query_information:
  {"includes":[{"table_name":"user_details","join_type":"INNER","join_condition":"user_details.user_id = users.id"}]}


uuid: 7aa6d230-35de-42c5-8a26-7f17ffcf001f
name: Item Grid
entity_name: item
entity_type: grid_builder_module
primary_table: items
created_at: 2024-09-04 03:56:40
query_information:
  {"includes":[{"table_name":"brands","join_type":"INNER","join_condition":"items.brand_id = brands.id"},{"table_name":"categories","join_type":"INNER","join_condition":"items.category_id = categories.id"},{"table_name":"departments","join_type":"LEFT","join_condition":"items.department_id = departments.id"},{"table_name":"warehouses","join_type":"LEFT","join_condition":"items.warehouse_id = warehouses.id"},{"table_name":"suppliers","join_type":"LEFT","join_condition":"items.supplier_id = suppliers.id"}]}


uuid: 552351c5-7151-4705-8047-b5f4628be7cf
name: Free Item Grid
entity_name: free_item
entity_type: grid_builder_module
primary_table: free_items
created_at: 2024-09-04 03:56:40
query_information:
  {"includes":[{"table_name":"items","join_type":"INNER","join_condition":"items.id = free_items.item_id"},{"table_name":"uoms","join_type":"INNER","join_condition":"uoms.id = free_items.uom_id"}]}


uuid: 095472fa-9806-421d-9209-95edf0b03398
name: Category Grid
entity_name: category
entity_type: grid_builder_module
primary_table: categories
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"table_name":"categories as parent","join_type":"LEFT","join_condition":"parent.id = categories.parent_id"}]}


uuid: 796d4d9a-7407-4a48-893f-58b7ee08629c
name: Salesman Item Mapping Grid
entity_name: salesman_item_mapping
entity_type: grid_builder_module
primary_table: users
created_at: 2024-09-04 03:56:41
query_information:
  {"group_by":["user_details.user_id,user_details.first_name, user_details.last_name,users.id"],"includes":[{"join_type":"LEFT","table_name":"user_details","join_condition":"user_details.user_id = users.id"},{"join_type":"LEFT","table_name":"salesman_item_mappings","join_condition":"users.id = salesman_item_mappings.salesman_id"}]}


uuid: 54ad8706-b1ed-4db3-8a32-d4d617b2e674
name: Route Outlet Mapping Grid
entity_name: route_outlet_mapping
entity_type: grid_builder_module
primary_table: routes
created_at: 2024-09-04 03:56:41
query_information:
  {"group_by":["route_outlet_mappings.route_id,routes.code, routes.id"],"includes":[{"join_type":"LEFT","table_name":"route_outlet_mappings","join_condition":"routes.id = route_outlet_mappings.route_id"}]}


uuid: b325f95a-a0b6-4fbd-9891-a1f58ecea251
name: Salesman Target Grid
entity_name: salesman_target
entity_type: grid_builder_module
primary_table: salesman_targets
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"INNER","table_name":"user_details as salesman","join_condition":"salesman.user_id = salesman_targets.salesman_id"}]}


uuid: 65a035f4-4f30-4e35-8308-318b3c378d82
name: Device Grid
entity_name: device
entity_type: grid_builder_module
primary_table: devices
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"INNER","table_name":"user_details","join_condition":"user_details.user_id = devices.salesman_id"}]}


uuid: cd9c06ea-d946-4d2e-8426-f28292bf6ff9
name: Bank Branch Grid
entity_name: bank_branch
entity_type: grid_builder_module
primary_table: bankbranches
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"INNER","table_name":"banks","join_condition":"banks.id = bankbranches.bank_id"}]}


uuid: 1e94c76b-3219-4663-ae02-e1e95f19ef87
name: Outlet Credit Limits Grid
entity_name: outlet_credit_limit
entity_type: grid_builder_module
primary_table: outlet_credit_limits
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"INNER","table_name":"user_details as outlet_credit_limits_user","join_condition":"outlet_credit_limits_user.user_id = outlet_credit_limits.salesman_id"},{"join_type":"INNER","table_name":"outlets as outlet_credit_limits_outlet","join_condition":"outlet_credit_limits_outlet.id = outlet_credit_limits.outlet_id"}]}


uuid: 960bf4c9-bc6f-45b1-ba99-90020813001c
name: Salesman Outlet Mapping Grid
entity_name: salesman_outlet_mapping
entity_type: grid_builder_module
primary_table: user_details
created_at: 2024-09-04 03:56:41
query_information:
  {"group_by":["salesman_outlet_mappings.outlet_id, user_details.id"],"includes":[{"join_type":"LEFT","table_name":"salesman_outlet_mappings","join_condition":"user_details.user_id = salesman_outlet_mappings.salesman_id"}]}


uuid: 4067bbd3-2bf6-40cd-8288-28cda74467ca
name: Outlet Stock Audit Grid
entity_name: outlet_stock_audit_header
entity_type: grid_builder_module
primary_table: outlet_stock_audit_headers
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"user_details as outlet_stock_audit_salesman","join_condition":"outlet_stock_audit_salesman.user_id = outlet_stock_audit_headers.salesman_id"},{"join_type":"LEFT","table_name":"outlet as outlet_stock_audit_outlet","join_condition":"outlet_stock_audit_outlet.id = outlet_stock_audit_headers.outlet_id"}]}


uuid: 78bd835f-62d0-429a-b590-1fb0fb2d3468
name: Team List Grid
entity_name: team
entity_type: grid_builder_module
primary_table: teams
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"user_details as supervisor","join_condition":"supervisor.user_id = teams.supervisor_id"}]}


uuid: 9437bf65-d341-46a5-8412-c55612f42e80
name: Department Salesman Mapping Grid
entity_name: department_salesman_mapping
entity_type: grid_builder_module
primary_table: users
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"department_salesman_mappings","join_condition":"users.id = department_salesman_mappings.salesman_id"},{"join_type":"LEFT","table_name":"departments as department_salesman_map_department","join_condition":"department_salesman_map_department.id = department_salesman_mappings.department_id"},{"join_type":"LEFT","table_name":"user_details as department_salesman","join_condition":"department_salesman.user_id = users.id"}]}


uuid: eef2f8a9-9352-4a60-a75b-40b8a48cbfbd
name: Approval WorkFlow Grid
entity_name: approval_workflow
entity_type: grid_builder_module
primary_table: approval_workflows
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"master_entities","join_condition":"master_entities.id = approval_workflows.entity_id"}]}


uuid: 3e4bedac-afa5-4f79-8cbc-4ee1eae85105
name: Document Sequences Grid
entity_name: document_sequence
entity_type: grid_builder_module
primary_table: document_sequences
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"user_details as document_seq_user","join_condition":"document_seq_user.user_id = document_sequences.salesman_id"}]}


uuid: b991dda5-0f0f-4216-bacb-98deec1081ae
name: Van Load Approval Grid
entity_name: van_load_approval
entity_type: grid_builder_module
primary_table: van_load_approvals
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"user_details as van_load_approval_user","join_condition":"van_load_approval_user.user_id = van_load_approvals.supervisor_id"}]}


uuid: 9ebd8fa1-c038-4613-bf98-d027bc15fbc4
name: Invoice Grid
entity_name: invoice
entity_type: grid_builder_module
primary_table: invoices
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"outlets as invoices_outlet","join_condition":"invoices_outlet.id = invoices.outlet_id"},{"join_type":"LEFT","table_name":"user_details as invoices_user","join_condition":"invoices_user.user_id = invoices.salesman_id"}]}


uuid: 6f257c51-9da9-412d-8607-2988c65f174b
name: Van Load Request Grid
entity_name: van_load_request
entity_type: grid_builder_module
primary_table: van_load_requests
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"user_details as van_load_req_user","join_condition":"van_load_req_user.user_id = van_load_requests.salesman_id"}]}


uuid: d1d57475-1906-4c0c-a65b-2a76fbb549a2
name: Credit Due Collection Grid
entity_name: credit_due
entity_type: grid_builder_module
primary_table: credit_dues
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"outlets as credit_due_outlet","join_condition":"credit_due_outlet.id = credit_dues.outlet_id"}]}


uuid: 3f05f214-0ce4-40cb-b45b-909964d7e181
name: Van Unload Request Grid
entity_name: van_unload_request
entity_type: grid_builder_module
primary_table: van_unload_requests
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"user_details as van_un_load_req_user","join_condition":"van_un_load_req_user.user_id = van_unload_requests.salesman_id"}]}


uuid: 60e1dc6d-ce11-4291-ae7a-46f062fc5ed4
name: Return Grid
entity_name: return
entity_type: grid_builder_module
primary_table: return_items
created_at: 2024-09-04 03:56:41
query_information:
  {"includes":[{"join_type":"LEFT","table_name":"outlets as return_items_outlet","join_condition":"return_items_outlet.id = return_items.outlet_id"},{"join_type":"LEFT","table_name":"user_details as return_items_user","join_condition":"return_items_user.user_id = return_items.salesman_id"}]}


uuid: 7eb1cbf4-78a2-4aa6-aa95-18cee6c34039
name: Entity Grid
entity_name: master_entity
entity_type: grid_builder_module
primary_table: master_entities
created_at: 2024-09-04 03:56:41
query_information:
  {"group_by":["master_entities.id"],"includes":[{"join_type":"LEFT","table_name":"master_entity_line_items","join_condition":"master_entities.id = master_entity_line_items.master_grid_id"}]}


uuid: fa9cdeb9-deab-4fd6-8ce2-f1047ea163c6
name: Import Template Grid
entity_name: import_template
entity_type: grid_builder_module
primary_table: import_templates
created_at: 2024-09-04 03:56:41
query_information:
  {"group_by":["import_templates.id"],"includes":[{"join_type":"LEFT","table_name":"import_template_line_items","join_condition":"import_templates.id = import_template_line_items.master_grid_id"}]}


uuid: a80e8436-687f-40f7-a863-c4d824e12bb8
name: role_details_page
entity_name: role_details_page
entity_type: static_page_builder_module
created_at: 2024-09-04 03:56:42
query_information:
  {"includes":[{"join_type":"INNER","table_name":"statuses","join_condition":"roles.status_id = statuses.id"}],"company_id":1,"search_all":[{"value":"$unique_id","operator":"=","column_name":"roles.uuid"},{"value":"3","operator":"!=","column_name":"roles.status_id"}],"sort_columns":[["roles.id","asc"]],"primary_table":"roles","limit_range":1,"print_query":false,"start_index":0,"select_columns":[["roles.name","name"],["statuses.name","status_name"],["roles.description","description"]]}

static_page_content:
  <table class="text"><tbody><tr><th>Role Name: </th><td>{{result_data.name}}</td><th>Status: </th><td>{{result_data.status_name}}</td><th>Description: </th><td>{{result_data.description}}</td></tr></tbody></table>


uuid: 215005c5-288c-4ece-ab44-e00e0a56b71b
name: Summary
entity_name: summary
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["invoices.id"],"company_id":1,"limit_range":10,"print_query":true,"start_index":0,"sort_columns":[["invoices.id","asc"]],"primary_table":"invoices","select_columns":[["sum(redeem_amount)","redeem"],["sum(tax_amount)","tax"],["sum(outlet_discount_amount)","outlet_discount"]]}

static_page_content:
  <div class="panel h-full pb-0 sm:col-span-2 xl:col-span-1">
                  <div class="mb-5 flex items-center dark:text-white-light">
                      <h5 class="text-lg font-semibold">Summary</h5>
                      
                  </div>
                  <div class="space-y-9">
                      <div class="flex items-center">
                          <div class="h-9 w-9 ltr:mr-3 rtl:ml-3">
                              <div
                                  class="grid h-9 w-9 place-content-center rounded-full bg-secondary-light text-secondary dark:bg-secondary dark:text-secondary-light"
                              >
                                  <i class="fa-solid fa-inbox"></i>
                              </div>
                          </div>
                          <div class="flex-1">
                              <div class="mb-2 flex font-semibold text-white-dark">
                                  <h6>Redeem Amount</h6>
                                  <p class="ltr:ml-auto rtl:mr-auto">{{redeem}}</p>
                              </div>
                              <div class="h-2 rounded-full bg-dark-light shadow dark:bg-[#1b2e4b]">
                                  <div class="h-full w-11/12 rounded-full bg-gradient-to-r from-[#7579ff] to-[#b224ef]"></div>
                              </div>
                          </div>
                      </div>
                      <div class="flex items-center">
                          <div class="h-9 w-9 ltr:mr-3 rtl:ml-3">
                              <div class="grid h-9 w-9 place-content-center rounded-full bg-success-light text-success dark:bg-success dark:text-success-light">
                                  <i class="fa-solid fa-tag"></i>
                              </div>
                          </div>
                          <div class="flex-1">
                              <div class="mb-2 flex font-semibold text-white-dark">
                                  <h6>Tax Amount</h6>
                                  <p class="ltr:ml-auto rtl:mr-auto">{{tax}}</p>
                              </div>
                              <div class="h-2 w-full rounded-full bg-dark-light shadow dark:bg-[#1b2e4b]">
                                  <div class="h-full w-full rounded-full bg-gradient-to-r from-[#3cba92] to-[#0ba360]" style="width: 65%"></div>
                              </div>
                          </div>
                      </div>
                      <div class="flex items-center">
                          <div class="h-9 w-9 ltr:mr-3 rtl:ml-3">
                              <div class="grid h-9 w-9 place-content-center rounded-full bg-warning-light text-warning dark:bg-warning dark:text-warning-light">
                                  <i class="fa-solid fa-credit-card"></i>
                              </div>
                          </div>
                          <div class="flex-1">
                              <div class="mb-2 flex font-semibold text-white-dark">
                                  <h6>Outlet Discount Amount</h6>
                                  <p class="ltr:ml-auto rtl:mr-auto">{{outlet_discount}}</p>
                              </div>
                              <div class="h-2 w-full rounded-full bg-dark-light shadow dark:bg-[#1b2e4b]">
                                  <div class="h-full w-full rounded-full bg-gradient-to-r from-[#f09819] to-[#ff5858]" style="width: 80%"></div>
                              </div>
                          </div>
                      </div>
                  </div>
              </div>


uuid: 24688211-6c13-4ff1-a4ae-94152842d14b
name: Recent Activities
entity_name: recent_activities
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["id"],"company_id":1,"limit_range":5,"print_query":true,"start_index":0,"sort_columns":[["id","desc"]],"primary_table":"webservice_logs","select_columns":[["service_type","service_type"],["TO_CHAR(created_at, 'MM YYYY')","created_at"],["status_id","status_id"]]}

static_page_content:
  <div class="panel h-full pb-0 sm:col-span-2 xl:col-span-1">
                  <h5 class="mb-5 text-lg font-semibold dark:text-white-light">Recent Activities</h5>

                  <ng-scrollbar class="relative mb-4 !h-[290px] ltr:-mr-3 ltr:pr-3 rtl:-ml-3 rtl:pl-3">
                      <div class="cursor-pointer text-sm">
                            {{#each (limit data_list 5)}}
          <div class="group relative flex items-center py-1.5">
              <div class="h-1.5 w-1.5 rounded-full {{#if status_id }}bg-success{{else}}bg-danger{{/if}} ltr:mr-1 rtl:ml-1.5"></div>
                      <div class="flex-1">{{service_type}}</div>
                      <div class="text-xs text-white-dark ltr:ml-auto rtl:mr-auto dark:text-gray-500">{{created_at}}</div>
                      <!-- Conditional badge text based on status_id -->
                      <span class="badge {{#if status_id }}badge-outline-success bg-success-light{{else}}badge-outline-danger bg-danger-light{{/if}} absolute text-xs opacity-0 group-hover:opacity-100 ltr:right-0 rtl:left-0 dark:bg-[#0e1726]">
                          {{#if status_id }}Active{{else}}Inactive{{/if}}
                      </span>
          </div>
          {{/each}}
                          
                          
                      </div>
                  </ng-scrollbar>
                  
              </div>


uuid: 8deee6d6-622d-4987-abc6-dbe5dcd3866b
name: Transactions
entity_name: transactions
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["id"],"company_id":1,"limit_range":7,"print_query":true,"start_index":0,"sort_columns":[["id","desc"]],"primary_table":"return_items","select_columns":[["id","id"],["return_no","return_no"],["TO_CHAR(return_date_time, 'DD MM YYYY')","return_date_time"],["tax_amount","tax_amount"]]}

static_page_content:
   <div class="panel h-full">
                  <div class="mb-5 flex items-center justify-between dark:text-white-light">
                      <h5 class="text-lg font-semibold">Return Items</h5>
                     
                  </div>
                  <div>
                      <div class="space-y-6">
                          {{#each (limit data_list 7)}}
          <div class="flex">
              <span
                  class="grid h-9 w-9 shrink-0 place-content-center rounded-md bg-success-light text-base text-success dark:bg-success dark:text-success-light"
                  >{{id}}</span
              >
              <div class="flex-1 px-3">
                  <div>{{return_no}}</div>
                  <div class="text-xs text-white-dark dark:text-gray-500">{{return_date_time}}</div>
              </div>
              <span class="whitespace-pre px-1 text-base text-success ltr:ml-auto rtl:mr-auto">+${{tax_amount}}</span>
          </div>
          {{/each}}
                          
                         
                          
                      </div>
                  </div>
              </div>


uuid: 3741f0a0-8f55-4012-89ba-117c7b70fa51
name: Outlet Limit Wallet
entity_name: walletbalance
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["users.id","users.email","user_details.first_name","user_details.last_name"],"includes":[{"join_type":"INNER","table_name":"user_details","join_condition":"user_details.user_id = users.id"},{"join_type":"INNER","table_name":"outlet_credit_limits","join_condition":"outlet_credit_limits.salesman_id = users.id"}],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["users.id","asc"]],"primary_table":"users","select_columns":[["users.email","email"],["user_details.first_name","first_name"],["user_details.last_name","last_name"],["sum(outlet_credit_limits.outlet_limit)","outlet_limit"],["sum(outlet_credit_limits.available_credit_limit)","available_credit_limit"],["sum(outlet_credit_limits.return_amount)","return_amount"]]}

static_page_content:
    <div class="panel h-full overflow-hidden border-0 p-0">
                  <div class="min-h-[190px] bg-gradient-to-r from-[#4361ee] to-[#160f6b] p-6">
                      <div class="mb-6 flex items-center justify-between">
                          <div class="flex items-center rounded-full bg-black/50 p-1 font-semibold text-white ltr:pr-3 rtl:pl-3">
                              
                              <i class="fas fa-user block  rounded-full border-2 border-white/50 object-cover ltr:mr-1 rtl:ml-1"></i>
                              {{first_name}} {{last_name}}
                          </div>
                          <button
                              type="button"
                              class="flex h-9 w-9 items-center justify-between rounded-md bg-black text-white hover:opacity-80 ltr:ml-auto rtl:mr-auto"
                          >
                          <i class="m-auto h-6 w-6 fa-solid fa-plus"></i>
                              
                          </button>
                      </div>
                      <div class="flex items-center justify-between text-white">
                          <p class="text-xl">Outlet Limit</p>
                          <h5 class="text-2xl ltr:ml-auto rtl:mr-auto"><span class="text-white-light">$</span>{{outlet_limit}}</h5>
                      </div>
                  </div>
                  <div class="-mt-12 grid grid-cols-2 gap-2 px-8">
                      <div class="rounded-md bg-white px-4 py-2.5 shadow dark:bg-[#060818]">
                          <span class="mb-4 flex items-center justify-between dark:text-white"
                              >Available Credit Limit
                              
                          </span>
                          <div class="btn w-full border-0 bg-[#ebedf2] py-1 text-base text-[#515365] shadow-none dark:bg-black dark:text-[#bfc9d4]">$ {{available_credit_limit}}</div>
                      </div>
                      <div class="rounded-md bg-white px-4 py-2.5 shadow dark:bg-[#060818]">
                          <span class="mb-4 flex items-center justify-between dark:text-white"
                              >Return Amount
                              
                          </span>
                          <div class="btn w-full border-0 bg-[#ebedf2] py-1 text-base text-[#515365] shadow-none dark:bg-black dark:text-[#bfc9d4]">$ {{return_amount}}</div>
                      </div>
                  </div>
                  <div class="p-5">
                      <div class="mb-5">
                          <span
                              class="rounded-full bg-[#1b2e4b] px-4 py-1.5 text-xs text-white   ltr:before:mr-2 rtl:before:ml-2"
                              >{{email}}</span
                          >
                      </div>
                      <div class="mb-5 space-y-1">
                          <div class="flex items-center justify-between">
                              <p class="font-semibold text-[#515365]">Static Info</p>
                              <p class="text-base"><span>$ </span> <span class="font-semibold">00.00</span></p>
                          </div>
                          <div class="flex items-center justify-between">
                              <p class="font-semibold text-[#515365]">Static Info</p>
                              <p class="text-base"><span>$ </span> <span class="font-semibold">00.00</span></p>
                          </div>
                      </div>
                      <div class="flex justify-around px-2 text-center">
                          <button type="button" class="btn btn-secondary ltr:mr-2 rtl:ml-2">View Details</button>
                          <button type="button" class="btn btn-success">Pay Now $00.00</button>
                      </div>
                  </div>
              </div>


uuid: 4a3d7db8-d427-45ad-9881-c102c3ace491
name: Recent Invoices
entity_name: recentorders
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["id"],"company_id":1,"limit_range":5,"print_query":true,"start_index":0,"sort_columns":[["id","desc"]],"primary_table":"invoices","select_columns":[["invoice_no","invoice_no"],["payment_type","payment_type"],["transaction_type","transaction_type"],["bank_name","bank_name"],["process_status_id","process_status_id"]]}

static_page_content:
   <div class="panel h-full w-full">
                  <div class="mb-5 flex items-center justify-between">
                      <h5 class="text-lg font-semibold dark:text-white-light">Recent Invoices</h5>
                  </div>
                  <div class="table-responsive">
                      <table>
                          <thead>
                              <tr>
                                  <th class="ltr:rounded-l-md rtl:rounded-r-md">Invoice</th>
                                  <th>Payment</th>
                                  <th>Transaction</th>
                                  <th>Bank</th>
                                  <th class="ltr:rounded-r-md rtl:rounded-l-md">Status</th>
                              </tr>
                          </thead>
                          <tbody>
                              {{#each data_list}}
          <tr class="group text-white-dark hover:text-black dark:hover:text-white-light/90">
              <td class="min-w-[150px] text-black dark:text-white">
                  <div class="flex items-center">
                      
                      <i class="fas fa-user h-8 w-8 rounded-md object-cover ltr:mr-3 rtl:ml-3"></i>
                      <span class="whitespace-nowrap">{{invoice_no}}</span>
                  </div>
              </td>
              <td class="text-primary">{{payment_type}}</td>
              <td><a href="javascript:void(0);">{{transaction_type}}</a></td>
              <td>{{bank_name}}</td>
              <td><span class="badge {{#if process_status_id }}bg-success{{else}}bg-danger{{/if}} shadow-md dark:group-hover:bg-transparent">
                  {{#if process_status_id }}Active{{else}}Inactive{{/if}}
                  </span></td>
          </tr>
          {{/each}}
                          </tbody>
                      </table>
                  </div>
              </div>


uuid: 128807d6-9eb7-400e-8f01-e5c81d3926bd
name: Free Items
entity_name: topsellingproduct
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["id"],"company_id":1,"limit_range":5,"print_query":true,"start_index":0,"sort_columns":[["id","desc"]],"primary_table":"free_items","select_columns":[["trade_name","trade_name"],["quantity","quantity"],["TO_CHAR(start_date, 'DD Mon YYYY')","start_date"],["TO_CHAR(end_date, 'DD Mon YYYY')","end_date"],["TO_CHAR(created_at, 'Mon YYYY')","created_date"],["item_status_id","item_status_id"]]}

static_page_content:
   <div class="panel h-full w-full">
                  <div class="mb-5 flex items-center justify-between">
                      <h5 class="text-lg font-semibold dark:text-white-light">Free Items</h5>
                  </div>
                  <div class="table-responsive">
                      <table>
                          <thead>
                              <tr class="border-b-0">
                                  <th class="ltr:rounded-l-md rtl:rounded-r-md">Trade</th>
                                  <th>Quantity</th>
                                  <th>Start</th>
                                  <th>End</th>
                                  <th class="ltr:rounded-r-md rtl:rounded-l-md">Status</th>
                              </tr>
                          </thead>
                          <tbody>
                              {{#each data_list}}
          <tr class="group text-white-dark hover:text-black dark:hover:text-white-light/90">
              <td class="min-w-[150px] text-black dark:text-white">
                  <div class="flex">
                      
                      <i class="fas fa-user h-8 w-8 rounded-md object-cover ltr:mr-3 rtl:ml-3"></i>
                      <p class="whitespace-nowrap">{{trade_name}} <span class="block text-xs text-primary">{{created_date}}</span></p>
                  </div>
              </td>
              <td>{{quantity}}</td>
              <td>{{start_date}}</td>
              <td>{{end_date}}</td>
              <td>
                  <a class="flex items-center  {{#if process_status_id }}text-success{{else}}text-danger{{/if}} " href="javascript:;">
                     

                      {{#if item_status_id }}Active{{else}}Inactive{{/if}}
                  </a>
              </td>
          </tr>
          {{/each}}
                          </tbody>
                      </table>
                  </div>
              </div>


uuid: 26744462-c1d3-41bf-bd88-00422ad46bb0
name: Damage Requests
entity_name: expenses
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["damage_requests.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["damage_requests.id","desc"]],"primary_table":"damage_requests","select_columns":[["count(id)","count"]]}

static_page_content:
  <div class="panel h-full">
                  <div class="mb-5 flex items-center justify-between dark:text-white-light">
                      <h5 class="text-lg font-semibold">Damage Requests</h5>
                     
                  </div>
                  <div class="my-10 text-3xl font-bold text-[#e95f2b]">
                      <span class="ltr:mr-2 rtl:ml-2">{{count}}</span>
                      <span class="text-sm text-black ltr:mr-1 rtl:ml-1 dark:text-white-light">this week </span>
                      <i class="fas fa-chart-line"></i>
                  </div>
                  <div class="flex items-center justify-between">
                      <div class="h-5 w-full overflow-hidden rounded-full bg-dark-light p-1 shadow-3xl dark:bg-dark-light/10 dark:shadow-none">
                          <div
                              class="relative h-full w-full rounded-full bg-gradient-to-r from-[#4361ee] to-[#805dca] before:absolute before:inset-y-0 before:m-auto before:h-2 before:w-2 before:rounded-full before:bg-white ltr:before:right-0.5 rtl:before:left-0.5"
                              style="width: 65%"
                          ></div>
                      </div>
                      <span class="ltr:ml-5 rtl:mr-5 dark:text-white-light">57%</span>
                  </div>
              </div>


uuid: f45fe704-d7a5-4a09-a75e-8ff2b0c6c8bb
name: Total Items
entity_name: totalbalance
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["items.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["items.id","desc"]],"primary_table":"items","select_columns":[["count(id)","count"]]}

static_page_content:
    <div
                  class="panel grid h-full grid-cols-1 content-between overflow-hidden before:absolute before:-right-44 before:bottom-0 before:top-0 before:m-auto before:h-96 before:w-96 before:rounded-full before:bg-[#1937cc]"
                  style="background: linear-gradient(0deg, #00c6fb -227%, #005bea) !important"
              >
                  <div class="z-[7] mb-16 flex items-start justify-between text-white-light">
                      <h5 class="text-lg font-semibold">Total Items</h5>

                      <div class="relative whitespace-nowrap text-xl">
                          {{count}}
                          <span class="mt-1 table rounded bg-[#4361ee] p-1 text-xs text-[#d3d3d3] ltr:ml-auto rtl:mr-auto">+ 2453</span>
                      </div>
                  </div>
                  <div class="z-10 flex items-center justify-between">
                      <div class="flex items-center justify-between">
                          <a
                              href="javascript:;"
                              class="place-content-center rounded p-1 text-white-light shadow-[0_0_2px_0_#bfc9d4] hover:bg-[#1937cc] ltr:mr-2 rtl:ml-2"
                          >
                              <i class="fas fa-inbox"></i>
                          </a>
                          <a href="javascript:;" class="grid place-content-center rounded p-1 text-white-light shadow-[0_0_2px_0_#bfc9d4] hover:bg-[#1937cc]">
                              <i class="fas fa-inbox"></i>
                          </a>
                      </div>
                      <a href="javascript:;" class="z-10 rounded p-1 text-white-light shadow-[0_0_2px_0_#bfc9d4] hover:bg-[#4361ee]"> Upgrade </a>
                  </div>
              </div>


uuid: b53c6a8c-4643-46b2-ba66-6149c21a930e
name: Activity Log
entity_name: activitylog
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["id"],"company_id":1,"limit_range":3,"print_query":true,"start_index":0,"sort_columns":[["id","desc"]],"primary_table":"request_logs","select_columns":[["req_device","req_device"],["TO_CHAR(created_at, 'DD Mon, YYYY')","created_at"],["req_url","req_url"],["req_method","req_method"],["status_id","status_id"]]}

static_page_content:
   <div class="panel h-full">
                  <div class="-mx-5 mb-5 flex items-start justify-between border-b border-[#e0e6ed] p-5 pt-0 dark:border-[#1b2e4b] dark:text-white-light">
                      <h5 class="text-lg font-semibold">Request Log</h5>
                     
                  </div>
                  <ng-scrollbar class="relative !h-[360px] ltr:-mr-3 ltr:pr-3 rtl:-ml-3 rtl:pl-3">
                     <div class="space-y-7">
              {{#each data_list}}
              <div class="flex" >
                <div class="relative z-10 shrink-0 before:absolute before:left-4 before:top-10 before:h-[calc(100%-24px)] before:w-[2px] before:bg-white-dark/30 ltr:mr-2 rtl:ml-2">
                  <div class="flex h-8 w-8 items-center justify-center rounded-full bg-secondary text-white shadow shadow-secondary" >
                    <i class="fas fa-chart-line h-4 w-4"></i>
                  </div>
                </div>
                <div>
                  <h5 class="font-semibold dark:text-white-light">
                    {{ req_device }}
                    <a href="javascript:void(0);" class="text-success">{{ req_url }}</a>
                    <span >
                      | <a href="javascript:void(0);" class="text-white-dark">{{ req_method }}</a>
                    </span>
                  </h5>
                  <p class="text-xs text-white-dark">{{ created_at }}</p>
                </div>
              </div>
              {{/each}}
            </div>
                  </ng-scrollbar>
              </div>


uuid: e6d4f73a-dbb0-470b-8d5f-bb023008197c
name: User Role Details
entity_name: visitorsbybrowser
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["roles.name","roles.id"],"includes":[{"join_type":"INNER","table_name":"user_roles","join_condition":"roles.id = user_roles.role_id"}],"company_id":1,"limit_range":3,"print_query":true,"start_index":0,"sort_columns":[["percentage","desc"]],"primary_table":"roles","select_columns":[["roles.name","role"],["count(user_roles)","count"],["ROUND((COUNT(user_roles.user_id) * 100.0 / (SELECT COUNT(*) FROM user_roles)), 2)","percentage"]]}

static_page_content:
   <div class="panel h-full sm:col-span-3 xl:col-span-2">
                  <div class="mb-5 flex items-start justify-between">
                      <h5 class="text-lg font-semibold dark:text-white-light">User Role Details</h5>
                  </div>
                  <div class="flex flex-col space-y-5">
                     {{#each data_list}}
          <div class="flex items-center">
              <div class="h-9 w-9">
                  <div class="flex h-9 w-9 items-center justify-center rounded-xl bg-primary/10 text-primary dark:bg-primary dark:text-white-light">
                      <i class="fas fa-inbox h-5 w-5"></i>
                  </div>
              </div>
              <div class="w-full flex-initial px-3">
                  <div class="w-summary-info mb-1 flex justify-between font-semibold text-white-dark">
                      <h6>{{role}} - {{count}}</h6>
                      <p class="text-xs ltr:ml-auto rtl:mr-auto">{{percentage}}%</p>
                  </div>
                  <div>
                      <div class="h-5 w-full overflow-hidden rounded-full bg-dark-light p-1 shadow-3xl dark:bg-dark-light/10 dark:shadow-none">
                          <div
                              class="relative h-full w-full rounded-full bg-gradient-to-r from-[#009ffd] to-[#2a2a72] before:absolute before:inset-y-0 before:m-auto before:h-2 before:w-2 before:rounded-full before:bg-white ltr:before:right-0.5 rtl:before:left-0.5"
                              style="width: {{percentage}}%"
                          ></div>
                      </div>
                  </div>
              </div>
          </div>
          {{/each}}
                     
                  </div>
              </div>


uuid: cadcafba-aed2-4de1-9368-88ed6d62c769
name: Last Person
entity_name: jimmyturner
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["users.id","user_details.phone_number","user_details.address","user_details.first_name","user_details.last_name"],"includes":[{"join_type":"INNER","table_name":"user_details","join_condition":"users.id = user_details.user_id"}],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["users.id","desc"]],"primary_table":"users","select_columns":[["users.email","email"],["user_details.phone_number","phone_number"],["user_details.address","address"],["user_details.first_name","first_name"],["user_details.last_name","last_name"],["TO_CHAR(users.created_at, 'DD Mon,YYYY')","created_at"]]}

static_page_content:
   <div class="panel h-full">
                  <div class="-m-5 mb-5 flex items-start border-b border-[#e0e6ed] p-5 dark:border-[#1b2e4b]">
                      <div class="shrink-0 rounded-full ring-2 ring-white-light ltr:mr-4 rtl:ml-4 dark:ring-dark">
                          
                          <i class="fas fa-user"></i>
                      </div>
                      <div class="font-semibold">
                          <h6>Last User: {{first_name}} {{last_name}}</h6>
                          <p class="mt-1 text-xs text-white-dark">{{created_at}}</p>
                      </div>
                  </div>
                  <div>
                      <div class="pb-8 text-white-dark">
                         Phone: {{phone_number}}
                         
                      </div>
                      <div class="pb-8 text-white-dark">
                         
                         Email: {{email}}
                         
                      </div>
                      <div class="pb-8 text-white-dark">
                         
                         
                         Address: {{address}}
                      </div>
                      <div class="absolute bottom-0 -mx-5 flex w-full items-center justify-between p-5">
                          <div class="flex items-center">
                              <i class="fas fa-chart-line relative -top-0.5 inline h-5 w-5 text-info ltr:mr-1.5 rtl:ml-1.5"></i>
                              
                              <span class="dark:text-info">{{created_at}}</span>
                          </div>
                          <a
                              href="javascript:;"
                              class="flex items-center rounded-md bg-success/30 px-1.5 py-1 text-xs text-success hover:shadow-[0_10px_20px_-10px] hover:shadow-success"
                              >Read More
                             
                              <i class="fas fa-chart-line h-4 w-4 -rotate-90 ltr:ml-1.5 rtl:mr-1.5 rtl:rotate-90"></i>
                          </a>
                      </div>
                  </div>
              </div>


uuid: a49be0ee-24db-441c-a84e-465523ac98b8
name: Last Bank
entity_name: devsummit
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["banks.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["banks.id","desc"]],"primary_table":"banks","select_columns":[["banks.name","name"],["banks.code","code"],["banks.description","description"]]}

static_page_content:
  <div class="panel h-full">
                  <div class="-m-5 mb-5 flex items-center justify-between border-b border-[#e0e6ed] p-5 dark:border-[#1b2e4b]">
                      <div class="flex">
                          <div class="media-aside align-self-start">
                              <div class="shrink-0 rounded-full ring-2 ring-white-light ltr:mr-4 rtl:ml-4 dark:ring-dark">
                                   <i class="fas fa-bank"></i>
                              </div>
                          </div>
                          <div class="font-semibold">
                              <h6>Last Bank: {{name}}</h6>
                              <p class="mt-1 text-xs text-white-dark">{{description}}</p>
                          </div>
                      </div>
                  </div>
                  <div class="pb-8 text-center font-semibold">
                      <div class="mb-4 text-primary">4 Banks</div>
                      <div class="flex items-center justify-center gap-3 pb-8">
                                 <i class="fas fa-bank h-10 w-10 overflow-hidden rounded-lg object-cover  "></i>
                                 <i class="fas fa-bank h-10 w-10 overflow-hidden rounded-lg object-cover  "></i>
                                 <i class="fas fa-bank h-10 w-10 overflow-hidden rounded-lg object-cover  "></i>
                                 <i class="fas fa-bank h-10 w-10 overflow-hidden rounded-lg object-cover  "></i>

                      </div>

                      <div class="absolute bottom-0 -mx-5 flex w-full items-center justify-between p-5">
                          <a href="javascript:;" class="btn btn-secondary btn-lg w-full border-0 bg-gradient-to-r from-[#3d38e1] to-[#1e9afe]">View Details</a>
                      </div>
                  </div>
              </div>


uuid: 8738de47-afd2-4071-8397-e38e053b9db2
name: Role Percentage
entity_name: figmadesign
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["roles.name","roles.id"],"includes":[{"join_type":"INNER","table_name":"user_roles","join_condition":"roles.id = user_roles.role_id"}],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["percentage","desc"]],"primary_table":"roles","select_columns":[["roles.name","role"],["count(user_roles)","count"],["ROUND((COUNT(user_roles.user_id) * 100.0 / (SELECT COUNT(*) FROM user_roles)), 2)","percentage"],["TO_CHAR(roles.created_at, 'DD Mon YYYY')","created_at"],["TO_CHAR(roles.updated_at, 'DD Mon YYYY')","updated_at"]]}

static_page_content:
  <div class="panel h-full">
                  <div class="-m-5 mb-12 flex items-center justify-between border-b border-[#e0e6ed] p-5 dark:border-[#1b2e4b]">
                      <a href="javascript:;" class="flex font-semibold">
                          <div class="flex h-10 w-10 shrink-0 items-center justify-center rounded-md bg-secondary text-white ltr:mr-4 rtl:ml-4">
                              <span>RP</span>
                          </div>
                          <div>
                              <h6>Role Percentage</h6>
                              <p class="mt-1 text-xs text-white-dark">{{created_at}}</p>
                          </div>
                      </a>
                   
                  </div>
                  <div class="group">
                      <div class="mb-5">
                          <div class="text-white-dark">
                              {{role}}
                          </div>
                      </div>
                      <div class="mb-7 flex items-center justify-between font-semibold">
                          <div class="flex items-center">
                              <i class="fas fa-chart-line h-4 w-4 text-success"></i>

                              <div class="text-xs ltr:ml-2 rtl:mr-2">{{count}} Users</div>
                          </div>
                          <p class="text-primary">{{percentage}}%</p>
                      </div>
                      <div class="mb-5 h-2.5 rounded-full bg-dark-light p-0.5 dark:bg-dark-light/10">
                          <div class="h-full rounded-full bg-gradient-to-r from-[#1e9afe] to-[#60dfcd]" style="width: 65%"></div>
                      </div>
                      <div class="flex items-end justify-between">
                          <div class="flex items-center rounded-full bg-danger/20 px-2 py-1 text-xs font-semibold text-danger">
                              <i class="fas fa-chart-line h-4 w-4 text-success"></i>

                              {{updated_at}}
                          </div>
                          <div class="flex items-center justify-center group-hover:-space-x-2 rtl:space-x-reverse rtl:group-hover:space-x-reverse">
                              <span
                                  class="flex h-9 w-9 items-center justify-center rounded-full bg-[#bfc9d4] font-semibold text-white opacity-0 transition-all duration-300 group-hover:opacity-100 dark:bg-dark"
                                  >+6</span
                              >
                              <img
                                  class="h-9 w-9 rounded-full border-2 border-white object-cover transition-all duration-300 dark:border-dark"
                                  src="/assets/images/user.png"
                                  alt=""
                              />
                              <img
                                  class="h-9 w-9 rounded-full border-2 border-white object-cover transition-all duration-300 dark:border-dark"
                                  src="/assets/images/user.png"
                                  alt=""
                              />
                              <img
                                  class="h-9 w-9 rounded-full border-2 border-white object-cover transition-all duration-300 dark:border-dark"
                                  src="/assets/images/user.png"
                                  alt=""
                              />
                          </div>
                      </div>
                  </div>
              </div>


uuid: 66063dc0-844a-4607-9838-989a6fb54c08
name: Users
entity_name: usersvisit
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["users.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["users.id","desc"]],"primary_table":"users","select_columns":[["count(id)","count"]]}

static_page_content:
   <div class="panel bg-gradient-to-r from-cyan-500 to-cyan-400">
                  <div class="flex justify-between">
                      <div class="text-md font-semibold ltr:mr-1 rtl:ml-1">Users</div>
                      
                  </div>
                  <div class="mt-5 flex items-center">
                      <div class="text-3xl font-bold ltr:mr-3 rtl:ml-3">{{count}}</div>
                      <div class="badge bg-white/30">+ 0.00%</div>
                  </div>
                  <div class="mt-5 flex items-center font-semibold">
                      <icon-eye class="shrink-0 ltr:mr-2 rtl:ml-2" />
                      Static Information
                  </div>
              </div>


uuid: 986631d9-15e2-4733-9b3b-e4068d0f4246
name: Banks
entity_name: sessions
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["banks.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["banks.id","desc"]],"primary_table":"banks","select_columns":[["count(id)","count"]]}

static_page_content:
    <div class="panel bg-gradient-to-r from-violet-500 to-violet-400">
                  <div class="flex justify-between">
                      <div class="text-md font-semibold ltr:mr-1 rtl:ml-1">Banks</div>
                     
                  </div>
                  <div class="mt-5 flex items-center">
                      <div class="text-3xl font-bold ltr:mr-3 rtl:ml-3">{{count}}</div>
                      <div class="badge bg-white/30">- 0.35%</div>
                  </div>
                  <div class="mt-5 flex items-center font-semibold">
                      <icon-eye class="shrink-0 ltr:mr-2 rtl:ml-2" />
                      Static Information
                  </div>
              </div>


uuid: f2039e4b-dd96-4482-8576-5c992eb355ab
name: Outlets
entity_name: timeonsite
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["outlets.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["outlets.id","desc"]],"primary_table":"outlets","select_columns":[["count(id)","count"]]}

static_page_content:
  <div class="panel bg-gradient-to-r from-blue-500 to-blue-400">
                  <div class="flex justify-between">
                      <div class="text-md font-semibold ltr:mr-1 rtl:ml-1">Outlets</div>
                      
                  </div>
                  <div class="mt-5 flex items-center">
                      <div class="text-3xl font-bold ltr:mr-3 rtl:ml-3">{{count}}</div>
                      <div class="badge bg-white/30">+ 0.00%</div>
                  </div>
                  <div class="mt-5 flex items-center font-semibold">
                      <icon-eye class="shrink-0 ltr:mr-2 rtl:ml-2" />
                      Static Information
                  </div>
              </div>


uuid: a71e2f69-5919-472b-bd81-6e0b803ebecf
name: Error Logs
entity_name: bouncerate
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["webservice_logs.id"],"company_id":1,"limit_range":1,"print_query":true,"start_index":0,"sort_columns":[["webservice_logs.id","desc"]],"primary_table":"webservice_logs","select_columns":[["COUNT(*)","count"],["webservice_logs.id","id"]]}

static_page_content:
   <div class="panel bg-gradient-to-r from-fuchsia-500 to-fuchsia-400">
                  <div class="flex justify-between">
                      <div class="text-md font-semibold ltr:mr-1 rtl:ml-1">Error Logs</div>
                     
                  </div>
                  <div class="mt-5 flex items-center">
                      <div class="text-3xl font-bold ltr:mr-3 rtl:ml-3">{{count}}</div>
                      <div class="badge bg-white/30">- 0.35%</div>
                  </div>
                  <div class="mt-5 flex items-center font-semibold">
                      <icon-eye class="shrink-0 ltr:mr-2 rtl:ml-2" />
                      Static Information
                  </div>
              </div>


uuid: 1652924d-700b-4b3d-8fd7-276c6aa2ba55
name: Invoices Statement
entity_name: previous_statement
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["invoices.id"],"company_id":1,"limit_range":10,"print_query":true,"start_index":0,"sort_columns":[["invoices.id","asc"]],"primary_table":"invoices","select_columns":[["sum(redeem_amount)","redeem"],["sum(tax_amount)","tax"],["sum(outlet_discount_amount)","outlet_discount"]]}

static_page_content:
  <div class="panel overflow-hidden">
                      <div class="flex items-center justify-between">
                          <div>
                              <div class="text-lg font-bold">Invoices Statement</div>
                              <div class="text-success">Static Information</div>
                          </div>
                         
                      </div>
                      <div class="relative mt-10">
                          <div class="absolute -bottom-12 h-24 w-24 ltr:-right-12 rtl:-left-12">
                              
                              
                          </div>
                          <div class="grid grid-cols-2 gap-6 md:grid-cols-3">
                              <div>
                                  <div class="text-primary">Redeem</div>
                                  <div class="mt-2 text-2xl font-semibold">${{redeem}}</div>
                              </div>
                              <div>
                                  <div class="text-primary">Tax</div>
                                  <div class="mt-2 text-2xl font-semibold">${{tax}}</div>
                              </div>
                              <div>
                                  <div class="text-primary">Discount</div>
                                  <div class="mt-2 text-2xl font-semibold">${{outlet_discount}}</div>
                              </div>
                          </div>
                      </div>
                  </div>


uuid: cf086cc1-32f6-421e-992b-f73f438170bd
name: Outlet Credit Statement
entity_name: current_statement
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["outlet_credit_limits.id"],"company_id":1,"limit_range":10,"print_query":true,"start_index":0,"sort_columns":[["outlet_credit_limits.id","asc"]],"primary_table":"outlet_credit_limits","select_columns":[["sum(outlet_limit)","outlet_limit"],["sum(available_credit_limit)","available_credit_limit"],["sum(return_amount)","return_amount"]]}

static_page_content:
   <div class="panel overflow-hidden">
                      <div class="flex items-center justify-between">
                          <div>
                              <div class="text-lg font-bold">Outlet Credit Statement</div>
                              <div class="text-danger">Static Information</div>
                          </div>
                         
                      </div>
                      <div class="relative mt-10">
                          <div class="absolute -bottom-12 h-24 w-24 ltr:-right-12 rtl:-left-12">
                              
                              
                          </div>

                          <div class="grid grid-cols-2 gap-6 md:grid-cols-3">
                              <div>
                                  <div class="text-primary">Outlet Limit</div>
                                  <div class="mt-2 text-2xl font-semibold">${{outlet_limit}}</div>
                              </div>
                              <div>
                                  <div class="text-primary">Available Credit Limit</div>
                                  <div class="mt-2 text-2xl font-semibold">${{available_credit_limit}}</div>
                              </div>
                              <div>
                                  <div class="text-primary">Return Amount</div>
                                  <div class="mt-2 text-2xl font-semibold">${{return_amount}}</div>
                              </div>
                          </div>
                      </div>
                  </div>


uuid: 1b3b8675-90e8-4ddc-821e-81055866bf05
name: Recent Transactions
entity_name: recent_transactions
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: static
dashboard_wizard_options: null
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["users.id","user_details.first_name","user_details.last_name"],"includes":[{"join_type":"INNER","table_name":"user_details","join_condition":"user_details.user_id = users.id"}],"company_id":1,"limit_range":10,"print_query":true,"start_index":0,"sort_columns":[["users.id","desc"]],"primary_table":"users","select_columns":[["users.email","email"],["users.role","role"],["users.status_id","status_id"],["user_details.first_name","first_name"],["user_details.last_name","last_name"]]}

static_page_content:
   <div class="panel">
                  <div class="mb-5 text-lg font-bold">Recent Users</div>
                  <div class="table-responsive">
                      <table>
                          <thead>
                              <tr>
                                  <th>Email</th>
                                  <th>First Name</th>
                                  <th>Last Name</th>
                                  <th>Role</th>
                                  <th class="text-center ltr:rounded-r-md rtl:rounded-l-md">STATUS</th>
                              </tr>
                          </thead>
                          <tbody>
                             {{#each data_list}}
            <tr>
              <td class="font-semibold">{{email}}</td>
              <td class="whitespace-nowrap">{{first_name}}</td>
              <td class="whitespace-nowrap">{{last_name}}</td>
              <td>{{role}}</td>
              <td class="text-center">
                  <span class="badge rounded-full {{#if status_id }} bg-success/20 text-success{{else}} bg-danger/20 text-danger{{/if}}  hover:top-0">{{#if status_id }}Active{{else}}Inactive{{/if}}</span>
              </td>
          </tr>
          {{/each}}
                          </tbody>
                      </table>
                  </div>
              </div>


uuid: 4cc5d386-2b22-460c-92c3-bb088b30923d
name: Return Items Line
entity_name: simple_line
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: chart
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["EXTRACT(MONTH FROM return_date_time)","TO_CHAR(return_date_time, 'Mon')"],"company_id":1,"search_all":[],"print_query":false,"start_index":0,"sort_columns":[["EXTRACT(MONTH FROM return_date_time)","asc"]],"primary_table":"return_items","select_columns":[["TO_CHAR(return_date_time, 'Mon')","labels"],["sum(tax_amount)","income"],["count(*)","count"]]}

dashboard_wizard_options:
  [{"grid":{"borderColor":"#e0e6ed"},"chart":{"type":"line","height":300,"toolbar":{"show":false}},"xaxis":{"axisBorder":{"color":"#e0e6ed"}},"yaxis":{"labels":{"offsetX":0},"opposite":false},"colors":["#4361ee"],"stroke":{"curve":"smooth","width":2},"tooltip":{"y":{"formatter":"function (number) { return '$' + number; }"},"theme":"light","marker":false}}]


uuid: dae52b09-619d-46d4-9988-e1d9efaa1b56
name: Outlet Credit Limits Area
entity_name: outletcreditlimitsarea
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: chart
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["EXTRACT(MONTH FROM start_date)","TO_CHAR(start_date, 'Mon')","quantity"],"company_id":1,"search_all":[],"print_query":false,"start_index":0,"sort_columns":[["EXTRACT(MONTH FROM start_date)","asc"]],"primary_table":"free_items","select_columns":[["TO_CHAR(start_date, 'Mon')","labels"],["quantity","quantity"]]}

dashboard_wizard_options:
  [{"grid":{"borderColor":"#e0e6ed"},"chart":{"type":"area","height":300,"toolbar":{"show":false}},"xaxis":{"axisBorder":{"color":"#e0e6ed"}},"yaxis":{"labels":{"offsetX":0},"opposite":false},"colors":["#4361ee"],"stroke":{"curve":"smooth","width":2},"tooltip":{"y":{"formatter":"function (number) { return '$' + number; }"},"theme":"light","marker":false}}]


uuid: d6857d9c-e58d-4d82-81ee-d3d3142d4268
name: Outlet Credit Limits Bar
entity_name: outletcreditlimitsbar
entity_type: dashboard_wizard_builder_module
dashboard_wizard_type: chart
created_at: 2024-09-04 03:56:44
query_information:
  {"group_by":["EXTRACT(MONTH FROM start_date)","TO_CHAR(start_date, 'Mon')","quantity"],"company_id":1,"search_all":[],"print_query":false,"start_index":0,"sort_columns":[["EXTRACT(MONTH FROM start_date)","asc"]],"primary_table":"free_items","select_columns":[["TO_CHAR(start_date, 'Mon')","labels"],["quantity","quantity"]]}

dashboard_wizard_options:
  [{"grid":{"borderColor":"#e0e6ed"},"chart":{"type":"bar","height":300,"toolbar":{"show":false}},"xaxis":{"axisBorder":{"color":"#e0e6ed"}},"yaxis":{"labels":{"offsetX":0},"opposite":false},"colors":["#4361ee"],"stroke":{"curve":"smooth","width":2},"tooltip":{"y":{"formatter":"function (number) { return '$' + number; }"},"theme":"light","marker":false}}]


