public function getNewNum($type_id, $company) { $type = new Erp_Model_Sale_Type(); $pre = $type->getPrefix($type_id); $num_pre = $pre . date('y'); $data = $this->fetchAll("number like '" . $num_pre . "%'", array('number desc')); if ($data->count() == 0) { $num = '0001'; } else { $last_item = $data->getRow(0)->toArray(); $new_order = intval(substr($last_item['number'], strlen($pre) + 4)) + 1; $num = sprintf("%04d", $new_order); } return $num_pre . $num; }