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

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

��ѧ٧ѧ�
<?php namespace App\Models; class Milestones_model extends Crud_model { protected $table = null; function __construct() { $this->table = 'milestones'; parent::__construct($this->table); parent::init_activity_log("milestone", "title", "project", "project_id"); } function schema() { return array( "id" => array( "label" => app_lang("id"), "type" => "int" ), "title" => array( "label" => app_lang("title"), "type" => "text" ), "project_id" => array( "label" => app_lang("project"), "type" => "foreign_key", "linked_model" => model("App\Models\Projects_model"), "label_fields" => array("title"), ), "due_date" => array( "label" => app_lang("due_date"), "type" => "date" ), "deleted" => array( "label" => app_lang("deleted"), "type" => "int" ) ); } function get_details($options = array()) { $milestones_table = $this->db->prefixTable('milestones'); $tasks_table = $this->db->prefixTable('tasks'); $where = ""; $id = get_array_value($options, "id"); if ($id) { $where = " AND $milestones_table.id=$id"; } $project_id = get_array_value($options, "project_id"); if ($project_id) { $where = " AND $milestones_table.project_id=$project_id"; } $sql = "SELECT $milestones_table.*, total_points_table.total_points, completed_points_table.completed_points FROM $milestones_table LEFT JOIN (SELECT milestone_id, SUM(points) AS total_points FROM $tasks_table WHERE deleted=0 AND milestone_id !=0 GROUP BY milestone_id) AS total_points_table ON total_points_table.milestone_id= $milestones_table.id LEFT JOIN (SELECT milestone_id, SUM(points) AS completed_points FROM $tasks_table WHERE deleted=0 AND milestone_id !=0 AND status_id=3 GROUP BY milestone_id) AS completed_points_table ON completed_points_table.milestone_id= $milestones_table.id WHERE $milestones_table.deleted=0 $where ORDER BY $milestones_table.due_date DESC"; return $this->db->query($sql); } }

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