public function getlistAction()
{
$request = $this->getRequest()->getParams();
if (!isset($request['recordkey']) || !$request['recordkey']) {
exit;
}
$recordkey = $request['recordkey'];
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$db = $fa->getAdapter();
$data = $fa->getOne($recordkey);
$bom = array();
for ($i = 0; $i < count($data); $i++) {
if ($i == 0) {
$row = $data[$i];
$bom = array('sid' => $row['sid'], 'nid' => $row['nid'], 'recordkey' => $row['recordkey'], 'id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'remark' => $row['remark'], 'project_no_name' => $row['project_no_name'], 'bom_file' => $row['bom_file'], 'code' => $row['code'], 'qty' => $row['qty'], 'ver' => $row['ver'], 'partposition' => "", 'replace' => "", 'state' => $row['state'], 'count' => 1, 'leaf' => false, 'children' => $this->getData($fa, $son, $recordkey, 2, $row['sid']));
}
}
$result = array('sid' => '', 'nid' => '', 'recordkey' => '', 'id' => '', 'name' => '', 'description' => '', 'remark' => '', 'code' => '', 'qty' => '', 'partposition' => '', 'replace' => '', 'state' => '', 'leaf' => false, 'children' => $bom);
// 将类别数据转为json格式并输出
$this->view->recordkey = $row['recordkey'];
$this->view->code = $row['code'];
$this->view->ver = $row['ver'];
echo Zend_Json::encode($result);
exit;
}
/**
* @abstract 保存
* @return null
*/
public function saveAction()
{
// 返回值数组
$result = array('success' => true, 'info' => '保存成功');
$request = $this->getRequest()->getParams();
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$bomId = $request['code_id'];
$userId = $request['employee_id'];
$bomIds = array();
$userIds = array();
if ($bomId) {
$bomIds = explode(',', $bomId);
}
if ($userId) {
$userIds = explode(',', $userId);
}
$bomrole = new Product_Model_Bomrole();
$fa = new Product_Model_Fa();
$emp = new Hra_Model_Employee();
try {
foreach ($bomIds as $b) {
$bomCodes = $fa->getById($b);
$bomCode = $bomCodes['code'];
foreach ($userIds as $u) {
$userNames = $emp->getById($u);
$userName = $userNames['cname'];
$data = array('bom' => $bomCode, 'employee_id' => $u, 'employee_name' => $userName, 'relation' => '管理员增加', 'create_user' => $user, 'create_time' => $now);
$bomrole->insert($data);
}
}
} catch (Exception $e) {
$result['result'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
echo Zend_Json::encode($result);
exit;
}
public function exportcsvoneAction()
{
$request = $this->getRequest()->getParams();
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$db = $fa->getAdapter();
$explanded = array();
$whereSearch = "1=1";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_key') {
$whereSearch .= " and (ifnull(t1.remark,'') like '%{$v}%' or ifnull(t3.name,'') like '%{$v}%' or ifnull(t3.description,'') like '%{$v}%' or ifnull(t5.model_internal, '') like '%{$v}%')";
} else {
if ("search_archive_date_from" == $k && $v) {
$whereSearch .= " and t1.bom_upd_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_archive_date_to" == $k && $v) {
$whereSearch .= " and t1.bom_upd_time <= '" . str_replace('T00:00:00', ' 23:59:59', $v) . "'";
} else {
if ("search_fa" == $k && $v) {
$whereSearch .= " and t1.code like '%" . $v . "%'";
} else {
if ("search_son" == $k && $v) {
$recordkey = "";
$sonData = $db->query("select group_concat(recordkey) as recordkey from oa_product_bom_son where code like '%{$v}%'")->fetchObject();
if ($sonData && $sonData->recordkey) {
$recordkey = $sonData->recordkey;
}
if (!$recordkey) {
$recordkey = "0";
}
$whereSearch .= " and t1.recordkey in ({$recordkey})";
} else {
if ("search_recordkey" == $k && $v) {
$whereSearch .= " and t1.recordkey = '{$v}'";
} else {
if ("explanded" == $k && $v) {
$explanded = json_decode($v);
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
}
}
}
$updflg = false;
if (isset($request['upd_flg']) && $request['upd_flg'] == 1) {
// 只导出升版
$whereSearch .= " and t1.ver > 1.0";
$updflg = true;
}
if (isset($request['my']) && $request['my'] == 1) {
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
if (isset($request['step']) && $request['step'] == 'dev') {
// 从升版里取
$data = $db->query("select group_concat(id) as nids from oa_product_bom_upd where create_user = {$user} and state = 'Active'")->fetchObject();
if ($data && $data->nids) {
$nids = $data->nids;
}
} else {
$data = $db->query("select group_concat(id) as nids from oa_product_bom_new where create_user = {$user} and state = 'Active'")->fetchObject();
if ($data && $data->nids) {
$nids = $data->nids;
}
}
if (isset($nids) && $nids) {
$whereSearch .= " and t1.nid in ({$nids})";
}
}
// 获取物料数据
$data = $fa->getList($whereSearch, null, null);
print chr(0xef) . chr(0xbb) . chr(0xbf);
// 获取物料数据
$data_csv = array();
$title = array('cnt' => '#', 'code' => '物料号', 'state' => '状态', 'name' => '物料名称', 'description' => '物料描述', 'project_no_name' => '产品型号', 'qty' => '数量', 'replace' => '替代料', 'partposition' => '器件位置', 'remark' => '备注');
if ($updflg) {
$title['upd_type'] = '升版类型';
$title['reason_type'] = '升版原因分类';
$title['upd_reason'] = '升版原因';
$title['description_upd'] = '升版描述';
}
// 文件名
if (count($data) == 1) {
$name = $data[0]['code'];
} else {
$name = "bom_list";
}
$title = $this->object_array($title);
$date = date('YmdHsi');
$filename = $name . '-' . $date;
$path = "../temp/" . $filename . ".csv";
$file = fopen($path, "w");
fputcsv($file, $title);
array_push($data_csv, $title);
$typeids = array();
$typenames = array();
$k = 0;
$push_data = array();
for ($i = 0; $i < count($data); $i++) {
$d = $data[$i];
$k++;
$info = array('cnt' => $k, 'code' => $this->ifNull($d, 'code') . " V" . $d['ver'], 'state' => $this->ifNull($d, 'state'), 'name' => $this->ifNull($d, 'name'), 'description' => $this->ifNull($d, 'description'), 'project_no_name' => $this->ifNull($d, 'project_no_name'), 'qty' => $d['qty'], 'replace' => $this->ifNull($d, 'replace'), 'partposition' => $this->ifNull($d, 'partposition'), 'remark' => $this->ifNull($d, 'remark'));
if ($updflg) {
$info['upd_type'] = $this->ifNull($d, 'upd_type');
$info['reason_type'] = $this->ifNull($d, 'reason_type_name');
$info['upd_reason'] = $this->ifNull($d, 'upd_reason');
$info['description_upd'] = $this->ifNull($d, 'description_upd');
}
$info['count'] = 0;
$push_data[] = $info;
$push_data = $this->getBomInfo($push_data, $fa, $son, $d['recordkey'], 1, $explanded);
}
foreach ($push_data as $data) {
$count = $data['count'];
$data['count'] = "";
$prefix = "";
for ($i = 0; $i < $count; $i++) {
$prefix .= " ";
}
$data['code'] = $prefix . $data['code'];
$d = $this->object_array($data);
fputcsv($file, $d);
}
fclose($file);
$this->operate("BOM导出");
echo $filename;
exit;
}
public function getlistAction()
{
$request = $this->getRequest()->getParams();
$fa = new Product_Model_Fa();
$fadev = new Product_Model_Fadev();
$db = $fa->getAdapter();
if (!isset($request['left_code']) || !isset($request['left_ver']) || !isset($request['right_code']) || !isset($request['right_ver']) || !$request['left_code'] || !$request['left_ver'] || !$request['right_code'] || !$request['right_ver']) {
echo Zend_Json::encode("");
exit;
}
$left_code = $request['left_code'];
$left_ver = $request['left_ver'];
$right_code = $request['right_code'];
$right_ver = $request['right_ver'];
$whereleft = "code='{$left_code}' and ver='{$left_ver}'";
$whereright = "code='{$right_code}' and ver='{$right_ver}'";
$left_recordkey = "";
$right_recordkey = "";
$left_type = "";
$right_type = "";
if ($fa->getJoinCount($whereleft) || $fadev->getJoinCount($whereleft)) {
$left_fa = $fa->getJoinList($whereleft, array(), array('recordkey'));
if ($left_fa && count($left_fa) > 0) {
$left_recordkey = $left_fa[0]['recordkey'];
} else {
$left_fa = $fadev->getJoinList($whereleft, array(), array('recordkey'));
if ($left_fa && count($left_fa) > 0) {
$left_recordkey = $left_fa[count($left_fa) - 1]['recordkey'];
$left_type = "dev";
}
}
}
if ($fa->getJoinCount($whereright) || $fadev->getJoinCount($whereright)) {
$right_fa = $fa->getJoinList($whereright, array(), array('recordkey'));
if ($right_fa && count($right_fa) > 0) {
$right_recordkey = $right_fa[0]['recordkey'];
} else {
$right_fa = $fadev->getJoinList($whereright, array(), array('recordkey'));
if ($right_fa && count($right_fa) > 0) {
$right_recordkey = $right_fa[count($right_fa) - 1]['recordkey'];
$right_type = "dev";
}
}
}
if ($left_recordkey && $right_recordkey) {
if ($left_type == 'dev') {
$son_left = new Product_Model_Sondev();
} else {
$son_left = new Product_Model_Son();
}
if ($right_type == 'dev') {
$son_right = new Product_Model_Sondev();
} else {
$son_right = new Product_Model_Son();
}
$leftData = $son_left->getSon($left_recordkey);
$rightData = $son_right->getSon($right_recordkey);
if ($leftData && $rightData) {
$leftCode = array();
$rightCode = array();
foreach ($rightData as $d) {
$rightCode[] = $d['code'];
}
foreach ($leftData as $d) {
$leftCode[] = $d['code'];
}
$result = array();
for ($i = 0; $i < count($rightData); $i++) {
$data = array();
$row = $rightData[$i];
$data['code'] = $row['code'];
$data['code2'] = $row['code'];
$data['name'] = $row['name'];
$data['description'] = $row['description'];
$data['qty2'] = $row['qty'];
$data['partposition2'] = $row['partposition'];
$data['replace2'] = $row['replace'];
$left = $this->getRowFromArrayByCode($leftData, $row['code']);
$leftData = $this->removeFromArray($leftData, $row['code']);
$data['code1'] = $left['code'];
$data['qty1'] = $left['qty'];
$data['partposition1'] = $left['partposition'];
$data['replace1'] = $left['replace'];
$result[] = $data;
}
if (count($leftData) > 0) {
foreach ($leftData as $row) {
$data = array();
$data['code'] = $row['code'];
$data['code1'] = $row['code'];
$data['name'] = $row['name'];
$data['description'] = $row['description'];
$data['qty1'] = $row['qty'];
$data['partposition1'] = $row['partposition'];
$data['replace1'] = $row['replace'];
$data['code2'] = "";
$data['qty2'] = "";
$data['partposition2'] = "";
$data['replace2'] = "";
$result[] = $data;
}
}
// 将类别数据转为json格式并输出
echo Zend_Json::encode($result);
exit;
} else {
echo Zend_Json::encode($leftData);
exit;
}
}
$msg = "BOM不存在";
if (!$left_recordkey) {
$msg = $left_code . " V" . $left_ver . "不存在";
} else {
if (!$right_recordkey) {
$msg = $right_code . " V" . $right_ver . "不存在";
}
}
echo Zend_Json::encode(array("msg" => $msg));
exit;
}
public function importAction()
{
$result = array('success' => true, 'info' => '导入成功');
$request = $this->getRequest()->getParams();
$type = isset($request['type']) ? $request['type'] : null;
$nid = isset($request['nid']) ? $request['nid'] : "";
if (isset($_FILES['csv'])) {
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$file = $_FILES['csv'];
$file_extension = strrchr($file['name'], ".");
$h = new Application_Model_Helpers();
$tmp_file_name = $h->getMicrotimeStr() . $file_extension;
$savepath = "../temp/";
$tmp_file_path = $savepath . $tmp_file_name;
move_uploaded_file($file["tmp_name"], $tmp_file_path);
$materiel = new Product_Model_Materiel();
$db = $materiel->getAdapter();
if ($type == 'dev') {
$fa = new Product_Model_Fadev();
$son = new Product_Model_Sondev();
$table = "oa_product_bom_fa_dev";
} else {
if ($type == 'bom') {
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$table = "oa_product_bom_fa";
}
}
if ($type == 'dev' || $type == 'bom') {
$file = fopen($tmp_file_path, "r");
$data = array();
while (!feof($file)) {
array_push($data, fgetcsv($file));
}
// 数据校验
if (count($data) <= 1) {
$result['success'] = false;
$result['info'] = "文件中无数据！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
for ($i = 1; $i < count($data); $i++) {
$num = $i + 1;
$row = $data[$i];
if ($i == 1 && !$row[1]) {
$result['success'] = false;
$result['info'] = "请以上级物料开头：第" . $num . "行！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
if (!$row[1] && !$row[2]) {
continue;
}
if ($row[1] && $row[2]) {
$result['success'] = false;
$result['info'] = "上级物料和下级物料不能同时存在：第" . $num . "行！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
if ($row[1]) {
if (!$materiel->checkExist($row[1])) {
$result['success'] = false;
$result['info'] = "物料“" . $row[1] . "”不存在：第" . $num . "行！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
$m = $materiel->getMaterielByCode($row[1]);
}
if ($row[2]) {
if (!$materiel->checkExist($row[2])) {
$result['success'] = false;
$result['info'] = "物料“" . $row[2] . "”不存在：第" . $num . "行！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
}
if ($row[2] && $row[7]) {
$replace = explode(',', $row[7]);
foreach ($replace as $r) {
$r = iconv('utf-8', 'gbk//IGNORE', $r);
if (!$materiel->checkExist($r)) {
$result['success'] = false;
$result['info'] = "物料“" . $r . "”不存在：第" . $i . "行！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
}
}
if ($i > 1 && $row[1] && $data[$i - 1][1]) {
$result['success'] = false;
$result['info'] = "BOM“" . $data[$i - 1][1] . "”不存在子物料：第{$i行！}";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
}
// 只取一次最大值，可能遇到重号
$maxkeys = $fa->getAdapter()->query("select ifnull(max(recordkey),0) as maxkey from {$table}")->fetchObject();
$recordkey = $maxkeys->maxkey;
$pid = "";
$faArr = array();
$sonArr = array();
$obsoleteWhere = "1=0";
// 校验成功，开始保存数据
for ($i = 1; $i < count($data); $i++) {
$row = $data[$i];
if ($row[1]) {
$m = $materiel->getMaterielByCode($row[1]);
$recordkey++;
$pid = $m['id'];
$faData = array('nid' => $nid, 'recordkey' => $recordkey, 'id' => $m['id'], 'code' => $row[1], 'qty' => 1, 'state' => $row[3] ? $row[3] : 'EBOM', 'ver' => $row[4] ? $row[4] : '1.0');
if ($faData['ver'] > '1.0') {
$obsoleteWhere .= " or (code='" . $row[1] . "' and ver < '" . $faData['ver'] . "')";
}
// 检查是否已经存在
if ($type == 'dev') {
$list = $fa->getFaList("nid = {$nid} and ver = '" . $faData['ver'] . "' and id = " . $m['id']);
} else {
$list = $fa->getFaList("ver = '" . $faData['ver'] . "' and id = " . $m['id']);
}
if ($list && count($list) > 0) {
$result['success'] = false;
$result['info'] = "数据已存在：" . $faData['code'] . " " . $faData['ver'] . "！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
$faArr[] = $faData;
}
if ($row[2]) {
$m = $materiel->getMaterielByCode($row[2]);
$sonData = array('nid' => $nid, 'recordkey' => $recordkey, 'pid' => $pid, 'id' => $m['id'], 'code' => $row[2], 'qty' => $row[5] ? $row[5] : 1, 'partposition' => $row[6] ? $row[6] : '', 'replace' => $row[7] ? $row[7] : '', 'remark' => $row[8] ? $row[8] : '');
// 检查是否已经存在
if ($type == 'dev') {
$list = $son->getList("nid = {$nid} and id = " . $m['id']);
} else {
$list = $son->getList("recordkey = {$recordkey} and id = " . $m['id']);
}
if ($list && count($list) > 0) {
$result['success'] = false;
$result['info'] = "数据已存在：" . $sonData['code'] . "！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
$sonArr[] = $sonData;
}
}
$db->beginTransaction();
try {
foreach ($faArr as $faData) {
$fa->insert($faData);
}
foreach ($sonArr as $sonData) {
$son->insert($sonData);
}
// 旧版作废
if ($type == 'bom') {
$bosoleteData = array("state" => "Obsolete");
$fa->update($bosoleteData, $obsoleteWhere);
}
$db->commit();
//执行commit
} catch (Exception $e) {
$db->rollBack();
//如果出现错误，执行回滚操作
$result['result'] = false;
$result['info'] = $e->getMessage();
fclose($file);
echo Zend_Json::encode($result);
exit;
}
fclose($file);
}
}
echo Zend_Json::encode($result);
exit;
}
public function exportcsvAction()
{
set_time_limit(0);
$fa = new Product_Model_Fa();
$bomPrice = new Product_Model_BomPrice();
$son = new Product_Model_Son();
$catalog = new Product_Model_Catalog();
$materiel = new Product_Model_Materiel();
$request = $this->getRequest()->getParams();
$faName = $fa->getName();
$priceName = $bomPrice->getName();
$mName = $materiel->getName();
$catalogName = $catalog->getName();
$db = $fa->getAdapter();
$whereSearch = "{$faName}.state != 'Obsolete'";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_key') {
$whereSearch .= " and (ifnull({$faName}.remark,'') like '%{$v}%' or ifnull({$mName}.name,'') like '%{$v}%' or ifnull({$mName}.description,'') like '%{$v}%' or ifnull({$catalogName}.model_internal, '') like '%{$v}%')";
} else {
if ("search_fa" == $k && $v) {
$whereSearch .= " and {$faName}.code like '%{$v}%'";
} else {
if ("search_archive_date_from" == $k && $v) {
$whereSearch .= " and {$faName}.bom_upd_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_archive_date_to" == $k && $v) {
$whereSearch .= " and v.bom_upd_time <= '" . str_replace('T00:00:00', ' 23:59:59', $v) . "'";
} else {
if ("search_son" == $k && $v) {
$recordkey = "";
$sonData = $db->query("select group_concat(recordkey) as recordkey from oa_product_bom_son where code like '%{$v}%'")->fetchObject();
if ($sonData && $sonData->recordkey) {
$recordkey = $sonData->recordkey;
}
if (!$recordkey) {
$recordkey = "0";
}
$whereSearch .= " and {$faName}.recordkey in ({$recordkey})";
} else {
if ("search_recordkey" == $k && $v) {
$whereSearch .= " and {$faName}.recordkey = '{$v}'";
} else {
if ("explanded" == $k && $v) {
$explanded = json_decode($v);
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull({$faName}." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
}
}
}
$rate = new Erp_Model_Setting_Currencyrate();
$date = date('Y-m-d');
$rateCny = $rate->getRateByCode('CNY', $date);
$rateUsd = $rate->getRateByCode('USD', $date);
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$sort = $this->getRequest()->getParam('sort');
if ($sort) {
$sort = json_decode($sort);
$sort = $sort[0];
$property = $sort->property;
$direction = $sort->direction;
if (in_array($property, array('code', 'ver', 'state', 'remark'))) {
$order = array($faName . '.' . $property . ' ' . $direction);
} else {
if (in_array($property, array('low_cny', 'low_usd', 'high_cny', 'high_usd', 'average_cny', 'average_usd', 'update_time'))) {
$order = array($bomPrice->getName() . '.' . $property . ' ' . $direction);
} else {
if (in_array($property, array('description', 'name'))) {
$order = array($mName . '.' . $property . ' ' . $direction);
}
}
}
}
if (isset($order)) {
$order[] = $faName . '.code';
} else {
$order = array($faName . '.code');
}
// 获取物料数据
$cjoin = array(array('type' => LEFTJONIN, 'table' => $catalog->getName(), 'condition' => $catalog->getName() . '.id = ' . $fa->getName() . '.project_no'), array('type' => INNERJOIN, 'table' => $bomPrice->getName(), 'condition' => $bomPrice->getName() . '.recordkey = ' . $fa->getName() . '.recordkey'), array('type' => INNERJOIN, 'table' => $materiel->getName(), 'condition' => $materiel->getName() . '.id = ' . $fa->getName() . '.id'));
$join = array(array('type' => LEFTJONIN, 'table' => $catalog->getName(), 'condition' => $catalog->getName() . '.id = ' . $fa->getName() . '.project_no', 'cols' => array('project_no_name' => 'model_internal')), array('type' => INNERJOIN, 'table' => $bomPrice->getName(), 'condition' => $bomPrice->getName() . '.recordkey = ' . $fa->getName() . '.recordkey', 'cols' => array("low_cny", "low_usd", 'high_cny', 'high_usd', 'average_cny', 'average_usd', 'update_time')), array('type' => INNERJOIN, 'table' => $materiel->getName(), 'condition' => $materiel->getName() . '.id = ' . $fa->getName() . '.id', 'cols' => array("name", "description")));
$data = $fa->getJoinList($whereSearch, $join, null, $order);
$allData = array();
for ($i = 0; $i < count($data); $i++) {
// 对于每个BOM，递归计算每个下级物料或BOM的价格
if (!$data[$i]['low_cny']) {
$price = $bomPrice->calcBomPrice($data[$i]['recordkey'], 'CNY');
$data[$i]['low_cny'] = $price['low'];
$data[$i]['high_cny'] = $price['high'];
$data[$i]['average_cny'] = $price['average'];
$data[$i]['low_usd'] = round($data[$i]['low_cny'] * ($rateCny / $rateUsd), 4);
$data[$i]['high_usd'] = round($data[$i]['high_cny'] * ($rateCny / $rateUsd), 4);
$data[$i]['average_usd'] = round($data[$i]['average_cny'] * ($rateCny / $rateUsd), 4);
}
$allData[] = $data[$i];
}
print chr(0xef) . chr(0xbb) . chr(0xbf);
// 获取物料数据
$data_csv = array();
$title = array('cnt' => '#', 'code' => 'BOM号', 'ver' => '版本', 'state' => '状态', 'low_cny' => '最低价格-人民币', 'high_cny' => '最高价格-人民币', 'average_cny' => '平均价格-人民币', 'low_usd' => '最低价格-美元', 'high_usd' => '最高价格-美元', 'average_usd' => '平均价格-美元', 'update_time' => '更新时间', 'name' => '物料名称', 'description' => '物料描述', 'project_no_name' => '产品型号', 'bom_upd_time' => '归档时间', 'remark' => '备注');
$title = $this->object_array($title);
$date = date('YmdHsi');
$filename = 'bomprice-' . $date;
$path = "../temp/" . $filename . ".csv";
$file = fopen($path, "w");
fputcsv($file, $title);
array_push($data_csv, $title);
$typeids = array();
$typenames = array();
$k = 0;
for ($i = 0; $i < count($data); $i++) {
$d = $data[$i];
$k++;
$info = array('cnt' => $k, 'code' => Helper::ifNull($d, 'code'), 'ver' => "V" . $d['ver'], 'state' => Helper::ifNull($d, 'state'), 'low_cny' => Helper::ifNull($d, 'low_cny'), 'high_cny' => Helper::ifNull($d, 'high_cny'), 'average_cny' => Helper::ifNull($d, 'average_cny'), 'low_usd' => Helper::ifNull($d, 'low_usd'), 'high_usd' => Helper::ifNull($d, 'high_usd'), 'average_usd' => Helper::ifNull($d, 'average_usd'), 'update_time' => $d['update_time'], 'name' => Helper::ifNull($d, 'name'), 'description' => Helper::ifNull($d, 'description'), 'project_no_name' => Helper::ifNull($d, 'project_no_name'), 'bom_upd_time' => $d['bom_upd_time'], 'remark' => Helper::ifNull($d, 'remark'));
$bomd = $this->object_array($info);
fputcsv($file, $bomd);
}
fclose($file);
$this->operate("BOM导出");
echo $filename;
exit;
}
public function calcBomPrice($recordkey, $currency = 'CNY')
{
$low = $high = $average = 0.0;
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$price_list = new Erp_Model_Warehouse_Pricelist();
$data = $this->getJoinList('recordkey = ' . $recordkey);
// 检查当前BOM是否已有价格
if (count($data) == 0) {
// 计算价格
$sonData = $son->getJoinList("recordkey = " . $recordkey, array(), array('code', 'qty'));
foreach ($sonData as $sonRow) {
// 检查是否有BOM数据，如果没有，当作物料处理
$sonFaData = $fa->getJoinList("code = '" . $sonRow['code'] . "'", array(), array('recordkey'), array('ver desc'));
if (count($sonFaData) == 0) {
if (isset($_SESSION['mprice'][$sonRow['code']])) {
// session 中存在
$price = $_SESSION['mprice'][$sonRow['code']];
} else {
$price = $price_list->getMultiPrice($sonRow['code'], $currency);
$_SESSION['mprice'][$sonRow['code']] = $price;
}
} else {
$price = $this->calcBomPrice($sonFaData[0]['recordkey'], $currency);
}
$low += $price['low'] * $sonRow['qty'];
$high += $price['high'] * $sonRow['qty'];
$average += $price['average'] * $sonRow['qty'];
}
} else {
$bomPrice = $data[0];
$low = $bomPrice['low_' . strtolower($currency)];
$high = $bomPrice['high_' . strtolower($currency)];
$average = $bomPrice['average_' . strtolower($currency)];
}
return array('low' => round($low, 4), 'high' => round($high, 4), 'average' => round($average, 4));
}
public function exportcsvAction()
{
set_time_limit(0);
$request = $this->getRequest()->getParams();
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$db = $fa->getAdapter();
$explanded = array();
$whereSearch = "1=1";
foreach ($request as $k => $v) {
if ($v) {
if ("search_recordkey" == $k && $v) {
$whereSearch .= " and t1.recordkey = '{$v}'";
} else {
if ("explanded" == $k && $v) {
$explanded = json_decode($v);
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
// 获取物料数据
$data = $fa->getList($whereSearch, null, null);
print chr(0xef) . chr(0xbb) . chr(0xbf);
// 获取物料数据
$data_csv = array();
$title = array('cnt' => '#', 'code' => '物料号', 'state' => '状态', 'name' => '物料名称', 'description' => '物料描述', 'low_cny' => '最低价格-人民币', 'high_cny' => '最高价格-人民币', 'average_cny' => '平均价格-人民币', 'low_usd' => '最低价格-美元', 'high_usd' => '最高价格-美元', 'average_usd' => '平均价格-美元', 'project_no_name' => '产品型号', 'qty' => '数量', 'replace' => '替代料', 'partposition' => '器件位置', 'remark' => '备注');
$date = date('YmdHsi');
// 文件名
if (count($data) == 1) {
$name = $data[0]['code'];
} else {
$zip = new ZipArchive();
$zipFileName = "boms" . $date . ".zip";
$zipFile = "../temp/{$zipFileName}";
$zipPath = "../temp/boms" . $date . "/";
if (!file_exists($zipPath)) {
mkdir($zipPath);
}
$name = "bom_list";
}
$bomPrice = new Product_Model_BomPrice();
$currencyrate = new Erp_Model_Setting_Currencyrate();
$date = date('Y-m-d');
$rateCny = $currencyrate->getRateByCode('CNY', $date);
$rateUsd = $currencyrate->getRateByCode('USD', $date);
$rate = round($rateCny / $rateUsd, 4);
$title = $this->object_array($title);
$typeids = array();
$typenames = array();
$k = 0;
for ($i = 0; $i < count($data); $i++) {
$push_data = array();
$d = $data[$i];
$k++;
$price = $bomPrice->calcBomPrice($d['recordkey'], 'CNY');
$info = array('cnt' => $k, 'code' => Helper::ifNull($d, 'code') . " V" . $d['ver'], 'state' => Helper::ifNull($d, 'state'), 'name' => Helper::ifNull($d, 'name'), 'description' => Helper::ifNull($d, 'description'), 'low_cny' => $price['low'], 'low_usd' => round($price['low'] * $rate, 4), 'high_cny' => $price['high'], 'high_usd' => round($price['high'] * $rate, 4), 'average_cny' => $price['average'], 'average_usd' => round($price['average'] * $rate, 4), 'qty' => $d['qty'], 'replace' => Helper::ifNull($d, 'replace'), 'partposition' => Helper::ifNull($d, 'partposition'), 'remark' => Helper::ifNull($d, 'remark'));
$filename = $info['code'] . '-' . $date;
if (isset($zipPath)) {
$path = $zipPath . $filename . ".csv";
} else {
$path = "../temp/" . $filename . ".csv";
}
$file = fopen($path, "w");
fputcsv($file, $title);
array_push($data_csv, $title);
$info['count'] = 0;
$push_data[] = $info;
$push_data = $this->getBomInfo($push_data, $fa, $son, $d['recordkey'], 1, $explanded, $rate);
foreach ($push_data as $bomdata) {
$count = $bomdata['count'];
$bomdata['count'] = "";
$prefix = "";
for ($ii = 0; $ii < $count; $ii++) {
$prefix .= " ";
}
$bomdata['code'] = $prefix . $bomdata['code'];
$bomd = $this->object_array($bomdata);
fputcsv($file, $bomd);
}
fclose($file);
}
/* foreach($push_data as $data) {
$count = $data['count'];
$data['count'] = "";
$prefix = "";
for($i = 0;$i < $count; $i++){
$prefix .= " ";
}
$data['code'] = $prefix.$data['code'];
$d = $this->object_array($data);
fputcsv($file, $d);
}
fclose($file); */
$this->operate("BOM导出");
if (isset($zipPath)) {
$zip = new ZipArchive();
$helper = new Application_Model_Helpers();
if ($zip->open($zipFile, ZipArchive::OVERWRITE) === TRUE) {
$datalist = $this->list_dir($zipPath);
foreach ($datalist as $val) {
if (file_exists($val)) {
$zip->addFile($val, basename($val));
//第二个参数是放在压缩包中的文件名称，如果文件可能会有重复，就需要注意一下
}
}
$zip->close();
//关闭
}
echo $zipFileName;
} else {
echo $filename;
}
exit;
}
public function exportcsvAction()
{
set_time_limit(0);
$request = $this->getRequest()->getParams();
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$db = $fa->getAdapter();
$explanded = array();
$whereSearch = "1=1";
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_key') {
$whereSearch .= " and (ifnull(t1.remark,'') like '%{$v}%' or ifnull(t3.name,'') like '%{$v}%' or ifnull(t3.description,'') like '%{$v}%' or ifnull(t5.model_internal, '') like '%{$v}%')";
} else {
if ("search_archive_date_from" == $k && $v) {
$whereSearch .= " and t1.bom_upd_time >= '" . str_replace('T', ' ', $v) . "'";
} else {
if ("search_archive_date_to" == $k && $v) {
$whereSearch .= " and t1.bom_upd_time <= '" . str_replace('T00:00:00', ' 23:59:59', $v) . "'";
} else {
if ("search_fa" == $k && $v) {
$whereSearch .= " and t1.code like '%" . $v . "%'";
} else {
if ("search_son" == $k && $v) {
$recordkey = "";
$sonData = $db->query("select group_concat(recordkey) as recordkey from oa_product_bom_son where code like '%{$v}%'")->fetchObject();
if ($sonData && $sonData->recordkey) {
$recordkey = $sonData->recordkey;
}
if (!$recordkey) {
$recordkey = "0";
}
$whereSearch .= " and t1.recordkey in ({$recordkey})";
} else {
if ("search_recordkey" == $k && $v) {
$whereSearch .= " and t1.recordkey = '{$v}'";
} else {
if ("explanded" == $k && $v) {
$explanded = json_decode($v);
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull(t1." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
}
}
}
}
}
}
// 获取物料数据
$data = $fa->getList($whereSearch, null, null);
print chr(0xef) . chr(0xbb) . chr(0xbf);
// 获取物料数据
$data_csv = array();
$title = array('cnt' => '#', 'code' => '物料号', 'state' => '状态', 'name' => '物料名称', 'description' => '物料描述', 'project_no_name' => '产品型号', 'bom_upd_time' => '归档时间', 'remark' => '备注');
$title = $this->object_array($title);
$date = date('YmdHsi');
$filename = 'bomlist-' . $date;
$path = "../temp/" . $filename . ".csv";
$file = fopen($path, "w");
fputcsv($file, $title);
array_push($data_csv, $title);
$typeids = array();
$typenames = array();
$k = 0;
for ($i = 0; $i < count($data); $i++) {
$d = $data[$i];
$k++;
$info = array('cnt' => $k, 'code' => $this->ifNull($d, 'code') . " V" . $d['ver'], 'state' => $this->ifNull($d, 'state'), 'name' => $this->ifNull($d, 'name'), 'description' => $this->ifNull($d, 'description'), 'project_no_name' => $this->ifNull($d, 'project_no_name'), 'archive_time' => $d['bom_upd_time'], 'remark' => $this->ifNull($d, 'remark'));
$bomd = $this->object_array($info);
fputcsv($file, $bomd);
}
fclose($file);
$this->operate("BOM导出");
echo $filename;
exit;
}
