我有一個圖表，我想從存儲在模型中的變量中獲取值。我的 Jquery 代碼：var ctx = document.getElementById('myChart').getContext('2d'); var myChart = new Chart(ctx, { type: 'bar', data: { labels: ['Quality', 'Service', 'Cleanliness', 'Staff'], datasets: [{ label: 'Average Ratings', data: [0,1,2,4,5], backgroundColor: "rgba(153,255,62,0.6)" }]}, });我的型號： public function chart_data() { $total = $this->db->query("SELECT ROUND(count((service_ans_1)+(service_ans_2)+(service_ans_3)+(quality_ans_1)+(quality_ans_2)+(quality_ans_3)+(quality_ans_4)+(cleanliness_ans_1)+(cleanliness_ans_2)+(cleanliness_ans_3)+(cleanliness_ans_4)+(cleanliness_ans_5)+(staff_ans_1)+(staff_ans_2)+(staff_ans_3))) as total from `dine_in_feedback` as f")->row()->total; $service = $this->db->query("SELECT ROUND(avg(((service_ans_1)+(service_ans_2)+(service_ans_3))/3)) as service from `dine_in_feedback` as f")->row()->service; $quality = $this->db->query("SELECT ROUND(avg(((quality_ans_1)+(quality_ans_2)+(quality_ans_3)+(quality_ans_4))/4)) as quality from `dine_in_feedback` as f")->row()->quality; $clean = $this->db->query("SELECT ROUND(avg(((cleanliness_ans_1)+(cleanliness_ans_2)+(cleanliness_ans_3)+(cleanliness_ans_4)+(cleanliness_ans_5))/5)) as clean from `dine_in_feedback` as f")->row()->clean; $staff = $this->db->query("SELECT ROUND(avg(((staff_ans_1)+(staff_ans_2)+(staff_ans_3))/15)) as staff from `dine_in_feedback` as f")->row()->staff; $result['service'] = $service / $total * 100; $result['quality'] = $quality / $total * 100; $result['clean'] = $clean / $total * 100; $result['staff'] = $staff / $total * 100; return $result; }我想要“數據：[0,1,2,4,5]”中的服務，質量，清潔和員工價值，例如數據：[服務價值，質量價值，清潔價值，員工價值]
1 回答
暮色呼如
TA貢獻1853條經驗 獲得超9個贊
首先，您需要從控制器調用模型函數“chart_data”，例如：
$chart_data= $this->model_name->chart_data();
然后將 $chart_data 變量發送到您的視圖，如下所示：
$this->load->view('your view name', $chart_data);
之后，您可以在視圖中使用 chart_data 變量，如下所示：
var ctx = document.getElementById('myChart').getContext('2d');
var myChart = new Chart(ctx, {
type: 'bar',
data: {
labels: ['Quality', 'Service', 'Cleanliness', 'Staff'],
datasets: [{
label: 'Average Ratings',
data: ['<?php echo $chart_data['service'] ?>','<?php echo $chart_data['quality'] ?>','<?php echo $chart_data['clean'] ?>','<?php echo $chart_data['staff'] ?>'],
backgroundColor: "rgba(153,255,62,0.6)"
}]},
});
- 1 回答
- 0 關注
- 187 瀏覽
添加回答
舉報
0/150
提交
取消