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
)
[9] => Array
(
[count(customer_id)] => 1
)
[10] => Array
(
[count(customer_id)] => 3
)
[11] => Array
(
[count(customer_id)] => 2
)
)
print_r($result);
exit();
$_SESSION =$v;
但是我作图的代码是
$dataArray = array('4','1','1','2','2','1','1','3','2','1','3','2');
$lableArray = array('January','February','March','April','May','June','July','August','September','October','November','December');
我用了 $dataArray = $_SESSION;
可是不行方法只识别 array('4','1','1','2','2','1','1','3','2','1','3','2'); 这样的数组，我只需要把$result数组变为可识别的数组就可以了，但就是想不出来，求救啊。
[解决办法]
SQL串写作
$sql = 'select count(customer_id) '.$str2.' where bl_salesman_id='.$_POST["EmployeeId"].' and year(create_time)='2012' group by month(create_time) order by month(create_time)';
$this->db->query($sql); 后将取出全部12个月的数据
你看一下取出的数据就知道接下来该怎么做了
