public function getcontactAction()
{
// 请求参数
$request = $this->getRequest()->getParams();
$contact = new Erp_Model_Contact();
// 查询条件
$condition = array('type' => 1, 'key' => isset($request['key']) && $request['key'] != '' ? $request['key'] : null, 'page' => isset($request['page']) ? $request['page'] : 1, 'limit' => isset($request['limit']) ? $request['limit'] : 0);
echo Zend_Json::encode($contact->getContact($condition));
exit;
}
public function getprintAction()
{
$result = array('success' => true, 'info' => '');
$request = $this->getRequest()->getParams();
if (isset($request['id']) && isset($request['tpl_id'])) {
$order = new Erp_Model_Purchse_Order();
$buyer = new Erp_Model_Purchse_Buyer();
$items = new Erp_Model_Purchse_Orderitems();
$helper = new Application_Model_Helpers();
$supplier_contact = new Erp_Model_Contact();
$tax = new Erp_Model_Setting_Tax();
$currency = new Erp_Model_Setting_Currency();
$orderData = $order->getData(null, $request['id']);
$itemsData = $items->getData($request['id']);
$buyerData = $buyer->getData($orderData['buyer_id']);
$supplierContactData = $supplier_contact->getData($orderData['supplier_contact_id']);
$taxData = $tax->getData($orderData['supplier_tax_id']);
$currencyData = $currency->getInfoByCode($orderData['currency']);
$tpl = new Erp_Model_Tpl();
$tplHtmlData = $tpl->fetchRow("id = " . $request['tpl_id'])->toArray();
$tplHtml = $tplHtmlData['html'];
$itemsHtml = '';
$itemsHtml_en = '';
$itemsHtml_other = '';
$i = 0;
foreach ($itemsData as $item) {
$i++;
$req_number = str_replace(',', '<br>', $item['items_req_number']);
$itemsHtml .= '
<tr>
<td>' . $i . '</td>
<td>' . $item['items_code'] . '</td>
<td width="100px">' . $item['items_name'] . '</td>
<td width="150px">' . $item['items_description'] . '</td>
<td>' . $item['items_qty'] . '</td>
<td>' . $item['items_unit'] . '</td>
<td>' . $currencyData['symbol'] . $item['items_price'] . '</td>
<td>' . $currencyData['symbol'] . $item['items_total'] . '</td>
<td>' . $req_number . '</td>
<td>' . $item['items_request_date'] . '</td>
<td>' . $item['items_remark'] . '</td>
</tr>';
$itemsHtml_en .= '
<tr>
<td>' . $i . '</td>
<td>' . $item['items_code'] . '</td>
<td width="100px" style="word-wrap:break-word;">' . $item['items_name'] . '</td>
<td width="150px" style="word-wrap:break-word;">' . $item['items_description'] . '</td>
<td>' . $item['items_qty'] . '</td>
<td>' . $item['items_unit'] . '</td>
<td>' . $currencyData['symbol'] . $item['items_price'] . '</td>
<td>' . $currencyData['symbol'] . $item['items_total'] . '</td>
<td>' . $req_number . '</td>
<td>' . $item['items_request_date'] . '</td>
<td>' . $item['items_remark'] . '</td>
</tr>';
$itemsHtml_other .= '
<tr>
<td>' . $i . '</td>
<td>' . $item['items_code'] . '</td>
<td width="250px" style="word-wrap:break-word;">' . $item['items_name'] . ' [' . $item['items_description'] . ']</td>
<td>' . $item['items_qty'] . '</td>
<td>' . $item['items_unit'] . '</td>
<td>' . $currencyData['symbol'] . $item['items_price'] . '</td>
<td>' . $currencyData['symbol'] . $item['items_total'] . '</td>
<td>' . $req_number . '</td>
<td>' . $item['items_request_date'] . '</td>
<td>' . $item['items_remark'] . '</td>
</tr>';
}
$receive = array();
if ($orderData['receiver_id']) {
// 公司收货人
$receiver = new Erp_Model_Warehouse_Warehousereceiver();
$receiverData = $receiver->getData($orderData['receiver_id']);
$receive['address'] = $receiverData['address'];
$receive['address_en'] = $receiverData['address_en'];
$receive['cname'] = $receiverData['cname'];
$receive['ename'] = $receiverData['ename'];
$receive['tel'] = $receiverData['tel'];
$receive['fax'] = $receiverData['fax'];
} else {
// 客户收货人
$receiverData = $supplier_contact->getDataByCode($orderData['customer_address_code']);
$receive['address'] = $receiverData['address'];
$receive['address_en'] = $receiverData['address'];
$receive['cname'] = $receiverData['name'];
$receive['ename'] = $receiverData['name'];
$receive['tel'] = $receiverData['tel'];
$receive['fax'] = $receiverData['fax'];
}
$orderInfo = array('order_symbol' => $currencyData['symbol'], 'company_name' => '成都欧飞凌通讯技术有限公司', 'company_tel' => '028-85161178', 'company_fax' => '028-85161176', 'company_address' => '成都市高新区云华路333号1-5栋 3层', 'company_logo' => HOME_PATH . '/public/images/company.png', 'company_tax' => '510198698882411', 'company_account' => '128904731510811', 'company_bank' => '招商银行成都分行高新支行', 'order_title' => '采 购 合 同', 'type' => ' - 物料原材料', 'number' => $orderData['number'], 'date' => date('Y-m-d', strtotime($orderData['create_time'])), 'contact_name' => $buyerData['cname'], 'contact_ename' => $buyerData['ename'], 'contact_tel' => $buyerData['tel'], 'contact_fax' => $buyerData['fax'], 'supplier_cname' => $orderData['supplier_cname'], 'supplier_ename' => $orderData['supplier_ename'], 'supplier_code' => $orderData['supplier_code'], 'supplier_bank_type' => $orderData['supplier_bank_type'], 'supplier_bank_account' => $orderData['supplier_bank_account'], 'supplier_address' => $supplierContactData['address'], 'supplier_contact_name' => $supplierContactData['name'], 'supplier_contact_tel' => $supplierContactData['tel'], 'supplier_contact_fax' => $supplierContactData['fax'], 'receive_address' => $receive['address'], 'receive_address_en' => $receive['address_en'], 'receive_cname' => $receive['cname'], 'receive_ename' => $receive['ename'], 'receive_tel' => $receive['tel'], 'receive_fax' => $receive['fax'], 'total_upper' => $helper->num2rmb($orderData['total']), 'total_lower' => $orderData['currency_rate'] != 1 ? $orderData['forein_total'] : $orderData['total'], 'supplier_tax' => $orderData['supplier_tax_num'], 'supplier_tax_name' => $taxData['name'], 'supplier_tax_rate' => $taxData['rate'], 'supplier_payment_days' => $orderData['supplier_payment'], 'settle_way' => $orderData['settle_way'], 'delvery_clause' => $orderData['delvery_clause'], 'manufacture' => $orderData['manufacture'], 'responsible' => $orderData['responsible'], 'table' => $itemsHtml, 'table_en' => $itemsHtml_en, 'table_other' => $itemsHtml_other, 'order_other_info' => $orderData['remark'], 'responsible' => $orderData['responsible'], 'order_title_en' => 'Purchase Order', 'order_title_other' => '设 备 类 采 购 合 同', 'company_name_en' => 'OPhylink Communication Technology Inc.');
foreach ($orderInfo as $key => $val) {
$tplHtml = str_replace('<tpl_' . $key . '>', $val, $tplHtml);
}
$result['info'] = $tplHtml;
} else {
$result['success'] = false;
}
/* echo $tplHtml;
exit; */
echo Zend_Json::encode($result);
exit;
}
/**
* 根据业务伙伴ID获取联系方式列表
*/
public function getcontactAction()
{
$data = array();
$request = $this->getRequest()->getParams();
$partner_id = isset($request['partner_id']) ? $request['partner_id'] : 0;
if ($partner_id > 0) {
$contact = new Erp_Model_Contact();
$record = $contact->fetchAll("partner_id = " . $partner_id)->toArray();
foreach ($record as $rec) {
$active = $rec['active'] == 1 ? true : false;
array_push($data, array('contact_id' => $rec['id'], 'contact_partner_id' => $rec['partner_id'], 'contact_active' => $active, 'contact_name' => $rec['name'], 'contact_post' => $rec['post'], 'contact_tel' => $rec['tel'], 'contact_fax' => $rec['fax'], 'contact_email' => $rec['email'], 'contact_country' => $rec['country'], 'contact_area' => $rec['area'], 'contact_address' => $rec['address'], 'contact_zip_code' => $rec['zip_code'], 'contact_remark' => $rec['remark']));
}
}
echo Zend_Json::encode($data);
exit;
}
/**
* 获取联系人信息
*/
public function getlinkmanAction()
{
$partner_id = $this->getRequest()->getParam('partner_id');
if ($partner_id) {
$contact = new Erp_Model_Contact();
$where = "email != '' and partner_id = {$partner_id}";
$data = $contact->getJoinList($where, array(), array('id', 'email', 'name' => "concat(name, '(', email, ')')"));
echo Zend_Json::encode($data);
exit;
} else {
echo Zend_Json::encode(array());
exit;
}
}
/**
* 根据业务伙伴ID获取联系方式列表
*/
public function getcontactAction()
{
$data = array();
$request = $this->getRequest()->getParams();
$option = isset($request['option']) ? $request['option'] : 'data';
$partner_id = isset($request['partner_id']) ? $request['partner_id'] : 0;
if ($partner_id > 0) {
$contact = new Erp_Model_Contact();
$record = $contact->fetchAll("partner_id = " . $partner_id, 'CONVERT( name USING gbk )')->toArray();
if ($option == 'list') {
foreach ($record as $rec) {
$active = $rec['active'] == 1 ? true : false;
$default = $rec['default'] == 1 ? true : false;
array_push($data, array('id' => $rec['id'], 'partner_id' => $rec['partner_id'], 'active' => $active, 'default' => $default, 'name' => $rec['name'], 'post' => $rec['post'], 'tel' => $rec['tel'], 'fax' => $rec['fax'], 'email' => $rec['email'], 'country' => $rec['country'], 'area' => $rec['area'], 'address' => $rec['address'], 'zip_code' => $rec['zip_code'], 'remark' => $rec['remark']));
}
} else {
foreach ($record as $rec) {
$active = $rec['active'] == 1 ? true : false;
$default = $rec['default'] == 1 ? true : false;
array_push($data, array('contact_id' => $rec['id'], 'contact_partner_id' => $rec['partner_id'], 'contact_active' => $active, 'contact_default' => $default, 'contact_name' => $rec['name'], 'contact_post' => $rec['post'], 'contact_tel' => $rec['tel'], 'contact_fax' => $rec['fax'], 'contact_email' => $rec['email'], 'contact_country' => $rec['country'], 'contact_area' => $rec['area'], 'contact_area_city' => $rec['area_city'], 'contact_area_code' => $rec['area_code'], 'contact_person_liable' => $rec['person_liable'], 'contact_address' => $rec['address'], 'contact_zip_code' => $rec['zip_code'], 'contact_remark' => $rec['remark']));
}
}
}
echo Zend_Json::encode($data);
exit;
}
public function getprintAction()
{
$result = array('success' => true, 'info' => '');
$request = $this->getRequest()->getParams();
if (isset($request['id']) && isset($request['tpl_id'])) {
$helper = new Application_Model_Helpers();
$order = new Erp_Model_Sale_Order();
$orderData = $order->getData(null, $request['id']);
$items = new Erp_Model_Sale_Orderitems();
$itemsData = $items->getData($request['id']);
$currency = new Erp_Model_Setting_Currency();
$currencyData = $currency->getInfoByCode($orderData['currency']);
$contactModel = new Erp_Model_Contact();
$contactData = $contactModel->getDataByCode($orderData['customer_address_code']);
$tpl = new Erp_Model_Tpl();
$tplHtmlData = $tpl->fetchRow("id = " . $request['tpl_id'])->toArray();
$tplHtml = $tplHtmlData['html'];
$itemsHtml = '';
if ($request['tpl_id'] == 16) {
$i = 0;
foreach ($itemsData as $item) {
$i++;
$itemsHtml .= '
<tr>
<td>' . $i . '</td>
<td>' . $item['items_code'] . '</td>
<td>' . $item['items_description'] . '</td>
<td>' . $item['items_qty'] . '</td>
<td>' . $currencyData['symbol'] . number_format($item['items_price'], 4) . '</td>
<td>' . $currencyData['symbol'] . $item['items_total'] . '</td>
<td>' . $item['items_remark'] . '</td>
</tr>';
}
} else {
foreach ($itemsData as $item) {
$itemsHtml .= '
<tr>
<td>' . $item['items_customer_code'] . '</td>
<td>' . $item['items_code'] . '</td>
<td>' . $item['items_description'] . '</td>
<td>' . $item['items_qty'] . '</td>
<td>' . $currencyData['symbol'] . number_format($item['items_price'], 4) . '</td>
<td>' . $currencyData['symbol'] . $item['items_total'] . '</td>
</tr>';
}
}
$rate = $orderData['tax_rate'] * 100;
$total_lower = $orderData['currency_rate'] != 1 ? $orderData['forein_total'] : $orderData['total'];
$orderInfo = array('company_logo' => HOME_PATH . '/public/images/company.png', 'order_address' => '成都', 'order_number' => $orderData['number'], 'order_date' => $orderData['order_date'], 'order_remark' => $orderData['remark'], 'tax_name' => $orderData['tax_name'] . '( ' . $rate . '% )', 'total_upper' => $helper->num2rmb($orderData['total']), 'total_lower' => $currencyData['symbol'] . $total_lower, 'company_name' => '成都欧飞凌通讯技术有限公司', 'company_name_en' => 'OPhylink Communication Technology Inc.', 'customer_cname' => $orderData['customer_cname'], 'customer_ename' => $orderData['customer_ename'], 'company_tel' => '028-85161178', 'company_fax' => '028-85161176', 'company_address' => '四川成都高新区云华路333号1幢-5A座3层', 'company_bank' => '招商银行成都分行高新支行', 'company_account' => '128904731510811', 'company_tax' => '510198698882411', 'customer_tel' => $contactData['tel'], 'customer_fax' => $contactData['fax'], 'customer_address' => $contactData['address'], 'customer_bank' => $orderData['customer_bank_type'], 'customer_account' => $orderData['customer_bank_account'], 'customer_tax' => $orderData['customer_tax_num'], 'customer_payment_days' => $orderData['customer_bank_payment_days'], 'items' => $itemsHtml);
//echo '<pre>';print_r($orderInfo);exit;
foreach ($orderInfo as $key => $val) {
$tplHtml = str_replace('<tpl_' . $key . '>', $val, $tplHtml);
}
$result['info'] = $tplHtml;
} else {
$result['success'] = false;
}
/* echo $tplHtml;
exit; */
echo Zend_Json::encode($result);
exit;
}
