��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/rickpfrv/clients.dominiquerickard.com/app/Models/Checklist_items_model.php

��ѧ٧ѧ�
<?php namespace App\Models; class Checklist_items_model extends Crud_model { protected $table = null; function __construct() { $this->table = 'checklist_items'; parent::__construct($this->table); } function get_details($options = array()) { $checklist_items_table = $this->db->prefixTable("checklist_items"); $where = ""; $task_id = get_array_value($options, "task_id"); if ($task_id) { $where .= " AND $checklist_items_table.task_id=$task_id"; } $sql = "SELECT $checklist_items_table.*, IF($checklist_items_table.sort!=0, $checklist_items_table.sort, $checklist_items_table.id) AS new_sort FROM $checklist_items_table WHERE $checklist_items_table.deleted=0 $where ORDER BY new_sort ASC"; return $this->db->query($sql); } function get_all_checklist_of_project($project_id) { $checklist_items_table = $this->db->prefixTable('checklist_items'); $tasks_table = $this->db->prefixTable('tasks'); $sql = "SELECT $checklist_items_table.task_id, $checklist_items_table.title FROM $checklist_items_table WHERE $checklist_items_table.deleted=0 AND $checklist_items_table.task_id IN(SELECT $tasks_table.id FROM $tasks_table WHERE $tasks_table.deleted=0 AND $tasks_table.project_id=$project_id)"; return $this->db->query($sql); } }

| ver. 1.4 | Github | . | PHP 7.4.33 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.12 | proxy | phpinfo | ��ѧ��ۧܧ�