/** * 获取供应商列表 * @param number $type * @return unknown */ public function getList($type = 0) { $sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name), array('id', 'tax_id', 'name' => new Zend_Db_Expr("concat(t1.code, ' ', case when t1.cname = '' then t1.ename else t1.cname end)"), 'currency_id' => 'bank_currency'))->joinLeft(array('t2' => $this->_dbprefix . 'erp_setting_currency'), "t1.bank_currency = t2.id", array('currency' => 't2.code'))->joinLeft(array('t3' => $this->_dbprefix . 'erp_setting_tax'), "t1.tax_id = t3.id", array('tax_name' => 'name'))->where("t1.type = " . $type)->order("t1.code"); $data = $this->fetchAll($sql)->toArray(); $taxRateModel = new Erp_Model_Setting_Taxrate(); for ($i = 0; $i < count($data); $i++) { $data[$i]['tax_rate'] = $taxRateModel->getCurrentRate($data[$i]['tax_id']); } return $data; }
public function getData($id = null) { $sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name))->joinLeft(array('t2' => $this->_dbprefix . 'user'), "t2.id = t1.create_user", array())->joinLeft(array('t3' => $this->_dbprefix . 'employee'), "t3.id = t2.employee_id", array('creater' => 'cname'))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t4.id = t1.update_user", array())->joinLeft(array('t5' => $this->_dbprefix . 'employee'), "t5.id = t4.employee_id", array('updater' => 'cname'))->order(array('CONVERT( t1.name USING gbk )')); if ($id) { $sql->where("t1.id = " . $id); $data = $this->fetchAll($sql)->toArray(); $rate = new Erp_Model_Setting_Taxrate(); $data[0]['rate'] = $rate->getCurrentRate($data[0]['id']); return $data[0]; } $data = $this->fetchAll($sql)->toArray(); $tax = new Erp_Model_Setting_Taxrate(); for ($i = 0; $i < count($data); $i++) { $data[$i]['create_time'] = strtotime($data[$i]['create_time']); $data[$i]['update_time'] = strtotime($data[$i]['update_time']); $data[$i]['active'] = $data[$i]['active'] == 1 ? true : false; $data[$i]['default'] = $data[$i]['default'] == 1 ? true : false; $data[$i]['current_rate'] = $tax->getCurrentRate($data[$i]['id']); } return $data; }