public function xlAction()
{
//print_r($this->_request->getParams());
$where = $this->_request->getParam('where');
$name = $this->_request->getParam('name');
$tblOrder = new Kutu_Core_Orm_Table_Order();
if ($name == 'Order') {
$data = array();
$dataset = $tblOrder->getAllOrderSummaryAdmin($where);
//var_dump($dataset);
//$data[] = array("A1" => "No","B1" => "Detail");
for ($i = 0; $i < count($dataset); $i++) {
$data[] = array("No" => $i + 1, "Description" => "User ID : " . $dataset[$i]->userId . "\n" . "Invoice : " . $dataset[$i]->invoiceNumber . "\n" . "First Name : " . $dataset[$i]->firstname . "\n" . "Last Name : " . $dataset[$i]->lastname . "\n" . "Company : " . $dataset[$i]->company, "Payment Method" => $dataset[$i]->paymentMethod, "Purchasing Date" => strftime("%Y-%m-%d", strtotime($dataset[$i]->datePurchased)), "Order Status" => $dataset[$i]->ordersStatus, "Total Price" => $dataset[$i]->orderTotal, "Qty" => $dataset[$i]->countTotal);
}
} elseif ($name == 'Transaction') {
$data = array();
$dataset = $tblOrder->getAllOrderSummaryAdmin($where);
//var_dump($dataset);
//$data[] = array("A1" => "No","B1" => "Detail");
for ($i = 0; $i < count($dataset); $i++) {
$data[] = array("No" => $i + 1, "Description" => "User ID : " . $dataset[$i]->userId . "\n" . "Invoice : " . $dataset[$i]->invoiceNumber . "\n" . "First Name : " . $dataset[$i]->firstname . "\n" . "Last Name : " . $dataset[$i]->lastname . "\n" . "Company : " . $dataset[$i]->company, "Payment Method" => $dataset[$i]->paymentMethod, "Purchasing Date" => strftime("%Y-%m-%d", strtotime($dataset[$i]->datePurchased)), "Modified Date" => !empty($dataset[$i]->lastModified) ? strftime("%Y-%m-%d", strtotime($dataset[$i]->lastModified)) : 'undefined', "Order Status" => $dataset[$i]->ordersStatus, "Total Price" => $dataset[$i]->orderTotal, "Qty" => $dataset[$i]->countTotal);
}
} elseif ($name == 'Paypal') {
$data = array();
$dataset = $tblOrder->getAllOrderSummaryAdmin($where);
//var_dump($dataset);
//$data[] = array("A1" => "No","B1" => "Detail");
for ($i = 0; $i < count($dataset); $i++) {
$data[] = array("No" => $i + 1, "Description" => "User ID : " . $dataset[$i]->userId . "\n" . "Invoice : " . $dataset[$i]->invoiceNumber . "\n" . "First Name : " . $dataset[$i]->firstname . "\n" . "Last Name : " . $dataset[$i]->lastname . "\n" . "Company : " . $dataset[$i]->company, "Payment Method" => $dataset[$i]->paymentMethod, "Purchasing Date" => strftime("%Y-%m-%d", strtotime($dataset[$i]->datePurchased)), "Modified Date" => !empty($dataset[$i]->lastModified) ? strftime("%Y-%m-%d", strtotime($dataset[$i]->lastModified)) : 'undefined', "Order Status" => $dataset[$i]->ordersStatus, "Total Price" => $dataset[$i]->orderTotal, "Qty" => $dataset[$i]->countTotal);
}
}
$this->_helper->layout->disableLayout();
$this->_helper->layout->setLayout('excell');
//print_r($data);
$xls = new PaymentGateway_ExcelExport();
/*$data_array[]=array('A' => 'A1','B' => 'B1','C' => 'C1');
$data_array[]=array('A' => 'A2','B' => 'B2','C' => 'C2');*/
$xls->toExcell($data, $name . '-' . date('Y-m-d'));
}
