123456789101112131415161718192021222324252627282930313233343536373839404142 |
- <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
- class Model_Customer2 extends Lin_Model
- {
- function __construct(){
- parent::__construct();
- $this->load->database();
- $this->table = 'customer2';
- $this->load_table('customer2');
- }
- /** 通过名称查找 */
- public function get_name($name)
- {
- return $this->find("name = '$name'");
- }
- public function get_data($name,$email,$address)
- {
- return $this->find("name = '$name' or email = '$email' or address = '$address'");
- }
- public function get_email($email)
- {
- return $this->find("email = '$email'");
- }
- public function get_address($address)
- {
- return $this->find("address = '$address'");
- }
- public function get_excel($titledata,$filename)
- {
- require_once "./data/excel/PHPExcel/IOFactory.php";
- $objPHPExcel = new \PHPExcel();
- $objPHPExcel->setActiveSheetIndex(0);
- $dataArray = $titledata;
- $objPHPExcel->getActiveSheet()->fromArray($dataArray, null, 'A1');
- header('Content-Type: application/vnd.ms-excel');
- header('Content-Disposition: attachment;filename='.$filename);
- $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
- $objWriter->save('php://output');
- $objPHPExcel->disconnectWorksheets();
-
- }
- } //end class
|