public function getRasschet($rec)
{
extract($rec);
$filelink = fileserver::createdironserver($filename);
$excel = file_get_contents($this->getDir() . "/" . $template);
if (fileserver::savefile($filelink . ".txt", $rec)) {
// сохранить
if (fileserver::savefile($filelink, $excel)) {
Output::assign('rlink', fileserver::sharefilelink($filelink));
$out = $this->fetch('rlink.tpl');
$res[filename] = $filename;
$res[result] = true;
} else {
$out = "Не удалось записать файл xls";
$res[result] = false;
}
} else {
$out = "Не удалось создать файл txt";
$res[result] = false;
}
$res[out] = $out;
return $res;
}
public function getTZ($id)
{
$rec = array();
$sql = "SELECT * FROM lanch WHERE id='{$id}'";
$res = sql::fetchOne($sql);
if (empty($res)) {
return false;
}
$rec[id] = $res[tz_id];
$sql = "SELECT * FROM tz WHERE id='{$res[tz_id]}'";
$res = sql::fetchOne($sql);
if (empty($res)) {
return false;
}
$sql = "SELECT * FROM filelinks WHERE id='{$res[file_link_id]}'";
$res = sql::fetchOne($sql);
if (empty($res)) {
return false;
}
$rec[link] = fileserver::sharefilelink($res[file_link]);
return $rec;
}
public function createTZ($rec)
{
extract($rec);
// np не надо редактировать - только добавлять с текущей датой и пользователем
// определим позицию в письме
extract($_SESSION[Auth::$lss]);
//list($customer_id,$order_id,$tz_id,$posintzid) = explode(':',$idstr);
$orderid = $order_id;
$sql = "SELECT COUNT(*)+1 AS next FROM tz WHERE order_id='{$orderid}'";
$rs = sql::fetchOne($sql);
$pos_in_order = $rs[next];
// добавление
// создать файл с табличкой
// определим заказчика
$sql = "SELECT number,orderdate,customer, fullname\n FROM orders\n JOIN customers\n ON customers.id=customer_id\n WHERE orders.id='{$orderid}'";
//echo $sql;
$rs = sql::fetchOne($sql);
$order = $rs["number"];
$customer = $rs["customer"];
$fullname = $rs["fullname"];
$odate = $rs["orderdate"];
$cdate = date("m-d-Y");
$sql = "INSERT INTO tz (order_id,tz_date,user_id) VALUES ('{$orderid}',NOW(),'" . Auth::getInstance()->getUser('id') . "')";
sql::query($sql);
$tzid = sql::lastId();
do {
$filetype = $typetz == "mpp" ? "МПП" : ($typetz == "dpp" ? "ДПП" : ($typetz == "mppb" ? "МПП-Блок" : "ДПП-Блок"));
$orderstring = fileserver::removeOSsimbols($rs["number"]);
$file_link = "t:\\\\Расчет стоимости плат\\\\ТехЗад\\\\{$customer}\\\\{$tzid}-{$filetype}-{$pos_in_order}-{$orderstring} от {$rs["orderdate"]}.xls";
$filename = fileserver::createdironserver($file_link);
$fe = file_exists($filename);
if ($fe) {
$pos_in_order++;
}
} while ($fe);
// Определим идентификатор файловой ссылки
$file_id = $this->getFileId($file_link);
// добавить поля в
$sql = "UPDATE tz SET file_link_id='{$file_id}', pos_in_order='{$pos_in_order}' WHERE id='{$tzid}'";
sql::query($sql);
$rec = array('id' => $tzid, 'tzlink' => $file_link, 'success' => true);
$tzid = sprintf("%08s", $tzid);
// для отображения в заказе
$rec = array_merge($rec, compact('cdate', 'filename', 'order', 'odate', 'typetz', 'fullname', 'tzid'));
return $rec;
}
function display_note_by_id($case_id = '')
{
$note = $this->get_notes_by_module_id('CASES', $case_id);
$fileserver = new fileserver();
ob_start();
?>
<table class="casecreation_note_table">
<?php
if (is_array($note) == TRUE) {
foreach ($note as $notes) {
?>
<tr>
<td>
<span class="casecreation_noteby"><?php
echo $notes["first_name"] . ' ' . $notes["last_name"] . ' ' . $notes["n_time"];
?>
</span>
</td>
</tr>
<tr>
<td style="word-wrap: break-word;" >
<div class="casecreation_notes"><?php
echo $notes["description"];
?>
</div>
</td>
</tr>
<?php
$files = $fileserver->get_files($notes['note_id'], 'notes');
if (count($files) != 0) {
?>
<tr>
<td>Files:
<?php
foreach ($files as $file) {
echo "<a href='" . FILESERVER_REMOTE_PATH . $file['path'] . "' target='_BLANK' >" . $file['name'] . "</a>";
}
?>
</td>
</tr>
<?php
}
}
}
?>
</table>
<?php
$html = ob_get_contents();
ob_end_clean();
return $html;
}
static function cleanSessionCache() {
$path = AJAXFORM_CACHE;
fileserver::createdironserver($path);
$dirs = glob($path . "/*", GLOB_NOSORT | GLOB_ONLYDIR);
if (is_array($dirs) && count($dirs))
foreach ($dirs as $e) {
$files = glob($e . "/*.php", GLOB_NOSORT);
if (is_array($files) && count($files))
foreach ($files as $f) {
if (@filemtime($f) < time() - AJAXFORM_CACHE_LIFETIME)
@unlink($f);
}
@rmdir($e);
}
}
public function getFilesForId($table, $id)
{
$out[link] = '';
$sql = "SELECT * FROM files WHERE `table`='{$table}' AND rec_id='{$id}'";
$files = sql::fetchAll($sql);
foreach ($files as $val) {
$sql = "SELECT * FROM filelinks WHERE id='{$val[fileid]}'";
$file = sql::fetchOne($sql);
$out[file][] = $file;
if (!strstr($file[file_link], $_SERVER['DOCUMENT_ROOT'])) {
$filelink = fileserver::sharefilelink($file[file_link]);
$file = basename($filelink);
$out[link] .= "<a class='filelink' href='{$filelink}'>{$file}</a><br>";
} else {
$filelink = str_ireplace($_SERVER['DOCUMENT_ROOT'], '', $file[file_link]);
$file = basename($filelink);
$out[link] .= "<a target=_blank href='http://{$_SERVER["HTTP_HOST"]}{$filelink}'>{$file}</a><br>";
}
}
return $out;
}
session_start();
$_SESSION[est_date] = '0';
$_SESSION[total_est_day] = 0;
//echo $_SESSION['contact_id'];
//ini_set('display_errors',1);
require_once 'app_code/config.inc.php';
require_once 'class/class.contacts.php';
require_once 'class/class.project.php';
require_once 'class/class.note.php';
require_once 'class/class.tasks.php';
require_once 'class/class.GlobalTask.php';
require_once 'class/class.WorkOrder.php';
require_once 'app_code/class.Event_Contacts.php';
require_once 'app_code/zipcode.class.php';
require_once 'class/class.CalcDate.php';
$fileserver = new fileserver();
//echo "FILESERVER_PRE";
$fileserver->check_fileUpload();
//echo "FILESERVER_POST";
$page = new basic_page();
$page->auth->Checklogin();
$notify = new Notification();
$ajax = new PHPLiveX();
$workorder = new WorkOrder();
$project = new Project();
$note = new Note();
$user = new User();
$task = new Tasks();
$global_task = new GlobalTask();
$em = new Event_Contacts();
$task->SetUserObject($user);
public function getSl($rec)
{
if ($rec[dpp]) {
$rec = $this->getSlDpp($rec);
} else {
$rec = $this->getSlMpp($rec);
}
extract($rec);
// Определим идентификатор файловой ссылки
$rec["l_date"] = $l_date = date("Y-m-d");
$file_link = "z:\\Заказчики\\{$customer}\\{$blockname}\\запуски\\" . "СЛ-{$l_date}-{$lanch_id}.xml";
$rec["template"] = $dpp ? "/sldpp.xls" : "/slmpp{$class}.xls";
$fileext = explode(".", $rec["template"]);
$rec["fileext"] = $fileext[1];
$rec["file_link"] = str_replace("xml", $rec["fileext"], $file_link);
$rec["filename"] = fileserver::createdironserver($rec["file_link"]);
$rec[file_id] = $file_id = $this->getFileId($rec["file_link"]);
$sql = "UPDATE lanch\r\n SET file_link_id='{$file_id}'\r\n WHERE id='{$lanch_id}'";
sql::query($sql);
return $rec;
}
public function getDataForCalc($id)
{
$rec = array();
$sql = "SELECT *,CONCAT (number,' от ',DATE_FORMAT(orderdate,'%d.%m.%Y')) as letter, " . "boards.sizex/100.0 as psizex, " . "boards.sizey/100.0 as psizey, " . "blocks.sizex/100.0 as bsizex, " . "blocks.sizey/100.0 as bsizey, " . "immer*auarea as gold, " . "CONCAT(numlam,' ',lsizex,'x',lsizey) as lamel, " . "blocks.comment_id as bcid " . "FROM posintz JOIN (tz,orders,customers,blocks,blockpos,boards) " . "ON (posintz.tz_id=tz.id " . "AND tz.order_id=orders.id " . "AND posintz.block_id=blocks.id " . "AND orders.customer_id=customers.id " . "AND blockpos.block_id=blocks.id " . "AND blockpos.board_id=boards.id ) " . "WHERE posintz.id='{$id}'";
$rec = sql::fetchOne($sql);
$params = json_decode(multibyte::Unescape(sqltable_model::getComment($rec["bcid"])), true);
//получим текщий комент из блока
$rec[eltest] = $params[eltest];
$rec[etpib] = $params[etpib];
$rec[etpoints] = $params[etpoints];
$rec[etcompl] = $params[etcompl];
$rec[thickness] = (double) $rec[thickness];
$rec[type] = $rec[layers] > 2 ? 'mpp' : 'dpp';
$rec[template] = "r{$rec[type]}.xls";
preg_match('/(?P<nummask>[+0-9]*)(?P<mask>.*)/i', $rec[mask], $matches);
$rec[mask] = $matches[mask];
$rec[nummask] = empty($matches[nummask]) ? 2 : $matches[nummask];
$rec[frez_factor] = $rec[frez_factor] > 0 ? $rec[frez_factor] : 1.0;
$orderstring = fileserver::removeOSsimbols($rec[letter] . " tz{$rec[tz_id]} posintz{$id}");
$rec[filename] = "t:\\\\Расчет стоимости плат\\\\{$rec[customer]}\\\\{$rec[blockname]}\\\\{$orderstring}.xls";
return $rec;
}
public function showmplink($rec)
{
$filename = "z:\\Заказчики\\{$rec[customer]}\\{$rec[blockname]}\\Мастерплаты\\МП-{$rec[date]}-{$rec[mp_id]}.xls";
$filename = fileserver::createdironserver($filename);
$excel = file_get_contents($this->getDir() . "/mp.xls");
if (fileserver::savefile($filename, $excel)) {
$mp["_date_"] = date("d.m.Y");
$mp["_number_"] = sprintf("%08d\n", $rec[mp_id]);
if (fileserver::savefile($filename . ".txt", $mp)) {
Output::assign('mplink', fileserver::sharefilelink($filename));
Output::assign('mpid', $rec[mp_id]);
$out = $this->fetch('mplink.tpl');
} else {
$out = "Не удалось создать файл txt";
}
} else {
$out = "Не удалось создать файл xls" . print_r($rec, true);
}
return $out;
}
<?php
require_once 'class/global.config.php';
require_once 'class/database.inc.php';
require_once 'class/class.fileserver.php';
$fileserver = new fileserver();
$fileserver->check_fileUpload();
?>
<head>
<script type="text/javascript" src="js/jquery.min.js"></script>
</head>
<form name="myform" action="tmp.fileserver.php" method="post" enctype="multipart/form-data" >
<input id="fileUplaod" type="file" size="45" name="fileUpload" class="input" ></input>
<input id="something" type="text" name="something" value="Yup" ></input>
<input type="submit" ></input>
</form>
<?php
echo $fileserver->display_files('1', 'tmp');
?>
<textarea style="width:100%;height: 80%" >
<?php
print_r($_FILES);
echo "\n\n";
print_r($_REQUEST);
echo "\n\n";
print_r($_POST);
if (is_array($_FILES["fileUpload"])) {
echo "YES\n";
$fileserver->upload_file('1', 'tmp', '1', $_FILES["fileUpload"]);
}
?>
