当前位置:Gxlcms > PHP教程 > CI框架里用pChart作报表数组不好识别

CI框架里用pChart作报表数组不好识别

时间:2021-07-01 10:21:17 帮助过:24人阅读

CI框架里用pChart做报表数组不好识别
这是查询的代码
$array1[0]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='01'");
$array1[1]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='02'");
$array1[2]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='03'");
$array1[3]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='04'");
$array1[4]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='05'");
$array1[5]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='06'");
$array1[6]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='07'");
$array1[7]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='08'");
$array1[8]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='09'");
$array1[9]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='10'");
$array1[10]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='11'");
$array1[11]= $this->db->query('select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"]." and year(create_time)='2012' and month(create_time)='12'");


$result = array();


foreach ( $array1 as $v ) {
$result[] = $v->row_array();

}

print_r($result);
exit();
$_SESSION =$v;



结果是:
Array
(
[0] => Array
(
[count(customer_id)] => 4
)

[1] => Array
(
[count(customer_id)] => 1
)

[2] => Array
(
[count(customer_id)] => 1
)

[3] => Array
(
[count(customer_id)] => 2
)

[4] => Array
(
[count(customer_id)] => 2
)

[5] => Array
(
[count(customer_id)] => 1
)

[6] => Array
(
[count(customer_id)] => 1
)

[7] => Array
(
[count(customer_id)] => 3
)

[8] => Array
(
[count(customer_id)] => 2

人气教程排行