function create_feeds($datafile, &$feeds, $apikey)
{
// Global variables
global $base_url, $user_interval;
// Read the feeds from file
$feedArray = json_decode(file_get_contents($datafile));
// Create each feed
foreach ($feedArray as $feed) {
// Feed interval
if (property_exists($feed, "interval")) {
$feedInterval = $feed->interval;
} else {
$feedInterval = $user_interval;
}
// Query
$datatype = get_type_id($feed->type);
$engine = get_engine_id($feed->engine);
$url = str_replace(' ', '%20', $base_url . "/feed/create.json?tag={$feed->description}&name={$feed->name}&datatype={$datatype}&engine={$engine}&apikey={$apikey}&options={\"interval\":{$feedInterval}}");
$result = json_decode(file_get_contents($url), true);
if ($result["success"] !== true) {
return false;
}
// Assign the created feed id to the feeds array
$feeds[$feed->name] = $result["feedid"];
}
return true;
}
while ($row2 = mysql_fetch_assoc($query2)) {
$arr = array("contentname" => $row2['name'], "contentid" => $row2['id'], "chemicalid" => $row2['chemical'], "chemicalname" => get_obj_name("pkn_chemical", $row2['chemical']), "unitsid" => $row2['units'], "unitsname" => get_obj_name("pkn_units", $row2['units']), "manufactorid" => $row2['manufactor'], "manufactorname" => get_obj_name("pkn_manufactor", $row2['manufactor']), "providerid" => $row2['provider'], "providername" => get_obj_name("pkn_provider", $row2['provider']), "purityid" => $row2['purity'], "purityname" => get_obj_name("pkn_purity", $row2['purity']), "storeid" => $row2['store'], "storename" => get_obj_name("pkn_store", $row2['store']), "fieldid" => $row2['field'], "fieldname" => get_obj_name("pkn_field", $row2['field']), "typeid" => $row2['type'], "typename" => get_obj_name("pkn_type", $row2['type']), "stateid" => $row2['state'], "statename" => get_obj_name("pkn_state", $row2['state']), "label" => $row2['name'] . " <> " . get_obj_name("pkn_field", $row2['field']) . " <> " . get_obj_name("pkn_manufactor", $row2['manufactor']));
array_push($reply, $arr);
}
}
} else {
if ($type == "name") {
$sql1 = "SELECT * FROM pkn_name WHERE (name LIKE '{$term}') ORDER BY name ASC";
$query1 = mysql_query($sql1);
while ($row1 = mysql_fetch_assoc($query1)) {
$arr = array("label" => $row1['name'], "id" => $row1['id'], "name" => $row1['name'], "type" => $row1['type']);
array_push($reply, $arr);
}
} else {
if ($type == "solution") {
$type1 = get_type_id($type);
$sql1 = "SELECT * FROM pkn_name WHERE (type='{$type1}' AND name LIKE '{$term}') ORDER BY name ASC";
// lay id name
$query1 = mysql_query($sql1);
while ($row1 = mysql_fetch_assoc($query1)) {
$sql2 = "SELECT * FROM {$table} WHERE name = '{$row1['id']}'";
// lay id name
$query2 = mysql_query($sql2);
while ($row2 = mysql_fetch_assoc($query2)) {
$arr = array("label" => getname($row2['name']), "id" => $row2['id'], "name" => getname($row2['name']), "units" => get_formula_units($row2['id']), "unitsname" => get_obj_name("pkn_units", get_formula_units($row2['id'])));
array_push($reply, $arr);
}
}
}
}
}
function import()
{
// 工装管理员 生产安全部
if (!has_perm(6, 1)) {
exit;
}
$name = $_FILES['files']['name'][0];
$size = $_FILES['files']['size'][0];
$tmp_name = $_FILES['files']['tmp_name'][0];
if (get_file_ext($name) != 'xls') {
$results['error'] = '对不起,系统只允许上传扩展名为 <strong>xls</strong> 的电子表格文件!';
$results['is_success'] = false;
} else {
if ($size > 2000000) {
$results['error'] = '对不起,系统只允许上传小于 <strong>2M</strong> 的电子表格文件!';
$results['is_success'] = false;
} else {
if (!empty($tmp_name)) {
$data = new \Spreadsheet_Excel_Reader();
$data->setOutputEncoding('UTF-8');
$cols = 12;
/* 每一行有12个单元格 */
$data->read($tmp_name);
error_reporting(E_ALL ^ E_NOTICE);
// 对电子表格的每一行进行循环
// 检测到某个单元格不存在时,设定其为空值
$rows = array();
//debug( $data->sheets[0]['cells'] );
foreach ($data->sheets[0]['cells'] as $row) {
for ($i = 1; $i <= $cols; $i++) {
if (!isset($row[$i])) {
$row[$i] = '';
}
// 转换部门名称为部门id值
if ($i == 6 && !empty($row[$i])) {
$row[$i] = get_group_id($row[$i]);
}
// 转换产品类型为id值
if ($i == 10) {
$row[$i] = get_type_id($row[$i]);
}
// 生产数量如果为空,则置0
if ($i == 4 && empty($row[$i])) {
$row[$i] = 0;
}
// 计划完成时间
if ($i == 5 && !empty($row[$i])) {
$row[$i] = change_date_style($row[$i]);
}
}
$rows[] = $row;
}
// 导入数据库
foreach ($rows as $row) {
//debug( $row );
$prod = new \Model\Production();
$prod->num = $row[1];
$prod->name = $row[2];
$prod->graphic_num = $row[3];
$prod->count = $row[4];
$prod->planned_completion_date = $row[5];
$prod->graphic_src = $row[6];
$prod->use_dep = 18;
$prod->completion_contact_person = $row[7];
$prod->completion_contact_phone = $row[8];
$prod->graphic_count = $row[9];
$prod->type = $row[10];
$prod->project_src = $row[11];
$prod->remark = $row[12];
$prod->user_id = $_SESSION['user_id'];
if ($prod->is_valid()) {
$prod->save();
} else {
//debug( $prod->errors );
// 如果某条导入失败
// 记录该条目的生产指令号,产品名称
// 以及具体的错误原因
$errors = array();
foreach ($prod->errors as $error) {
$errors[] = $error;
}
$results['failed_items'][] = array('num' => $prod->num, 'name' => $prod->name, 'errors' => $errors);
}
}
//debug( $rows );*/
//debug( $rows );
//debug( $rows );
$results['is_success'] = true;
}
}
}
echo json_encode($results);
}
function set_object_relation($object_id_1, $object_type_1, $object_id_2, $object_type_2)
{
global $mysqli;
$relation = get_object_relation_by_object_id($object_id_1, $object_id_2);
if (!$relation) {
if ($result = $mysqli->query("INSERT INTO objects_relations (object_id1,type_id1,object_id2,type_id2) VALUES (" . intval($object_id_1) . "," . intval(get_type_id($object_type_1)) . "," . intval($object_id_2) . "," . intval(get_type_id($object_type_2)) . ")")) {
$relation = get_object_relation_by_relation_id($mysqli->insert_id);
//insert success
return $relation;
} else {
return false;
}
} else {
return $relation;
}
}
