function print_json($msgarray)
{
foreach ($msgarray as $key => $msg) {
$output = new stdClass();
$output->{$key} = $msg;
echo tojson($output);
}
}
public function delete_tr()
{
global $db;
$tr_data = $this->tr;
switch ($tr_data->transstate_no) {
//after get tr data, check the transstate_no is = 1, is mean 未收貨,
//with can delete it directly, and update the stock after delete
case 1:
//未收貨
//save the data to db and delete the record
$serialize_tr = '';
$serialize_tr = $this->get_serialize_tr();
if (!empty($serialize_tr)) {
$insert_obj = new stdClass();
$insert_obj->receipttype = 'tr';
$insert_obj->receiptno = $tr_data->transfer_no;
$insert_obj->staffno = $_SESSION['staff_no'];
$insert_obj->date = time();
$insert_obj->staffid = $_SESSION['staff_id'];
$insert_obj->data = $serialize_tr;
$delete_log_no = $db->insert_record('delete_log', $insert_obj);
if ($delete_log_no) {
$this->do_delete_tr($tr_data, $delete_log_no);
//print out deleted po msg
$msgarray = array();
$msgarray["msg"] = "TR {$tr_data->transfer_no} has been delete";
$msgarray["ok"] = 1;
echo tojson($msgarray);
}
}
break;
case 2:
//已收貨
print_error('[x][tr003]TR cannot delete, TR num : ' . $tr_data->transfer_no . ', TR state num : ' . $tr_data->transstate_no);
break;
default:
print_error($string_arr['tr004']);
break;
}
}
function funagregarContenidoZona($id_zona, $tipo, $nombre)
{
global $ini_array;
//$ini_array = parse_ini_file("/var/include/confi.ini", true);
mensaje_log("FUNCION AGREGAR CONTENIDO ZONA (ZONA)");
$usu = $ini_array['ftpzona']['usu'];
$pass = $ini_array['ftpzona']['pass'];
$servidor = $ini_array['ftp']['servidor'];
$mod = -2;
$query = mysql_query("SELECT * FROM zona WHERE id_zona = '{$id_zona}'") or die(mysql_error());
$row = mysql_fetch_array($query);
if ($row != NULL) {
try {
$id = $row['id_zona'];
$variable = $nombre;
$query = mysql_query("UPDATE contenido_zona SET {$tipo} = '{$variable}' WHERE id_zona = '{$id}'") or die(mysql_error());
if ($tipo == "texto") {
$mod = "1";
} else {
$mod = "ftp://" . $usu . ":" . $pass . "@" . $servidor . "/" . $id_zona . "/" . $tipo . "/" . $variable;
}
} catch (Exception $e) {
$mod = -1;
}
}
return tojson(utf8_encode($mod));
}
if (!empty($serialize_po)) {
$insert_obj = new stdClass();
$insert_obj->receipttype = 'po';
$insert_obj->receiptno = $po_data->po_no;
$insert_obj->staffno = $_SESSION['staff_no'];
$insert_obj->date = time();
$insert_obj->staffid = $_SESSION['staff_id'];
$insert_obj->data = $po->get_serialize_po();
$delete_log_no = $db->insert_record('delete_log', $insert_obj);
if ($delete_log_no) {
delete_po($po_data);
//print out deleted po msg
$msgarray = array();
$msgarray["msg"] = "PO {$po_data->po_no} has been delete";
$msgarray["ok"] = 1;
echo tojson($msgarray);
}
}
break;
default:
print_error('[x][po003]PO cannot delete, PO num : ' . $po_data->po_no . ', PO state num : ' . $po_data->postate_no);
break;
}
break;
case 'viewdeleedpo':
break;
default:
//echo 'here is default po';
print_error('[x][po004]Default no action');
break;
}
function jsonattr($a)
{
return str_replace('"', '"', tojson($a));
}
function funGetOpcPregunta($id_preg)
{
$u = "-1";
$query2 = mysql_query("SELECT o.descripcion \r\n\r\n\tFROM opciones o, preguntas p \r\n\r\n\tWHERE p.id_pregunta = {$id_preg}\tand\r\n \r\n p.id_opciones=o.id_opcion") or die(mysql_error());
$row = mysql_fetch_assoc($query2);
if ($row != null) {
$u = utf8_encode($row['descripcion']);
}
return tojson($u);
}
function curpathinfo()
{
return $_SERVER['PHP_SELF'];
// if(array_key_exists("PATH_INFO", $_SERVER)) {
// return substr($_SERVER["PATH_INFO"], 1);
// } else
// return "";
}
//print_r($_SERVER);
$_GET[""] = "mohit";
$_POST[""] = "mohit";
$_SESSION[""] = "mohit";
$_FILES[""] = "mohit";
$addinfo = array("ip" => $_SERVER['REMOTE_ADDR']);
$pydata = array("get" => $_GET, "post" => $_POST, "session" => $_SESSION, "url" => curpathinfo(), "file" => $_FILES, "addinfo" => $addinfo);
$cmd = "cd " . $root . ";" . "python " . $pyfile . " \"" . replall(tojson($pydata), array('\\' => '\\\\', "\t" => "\\t", "\n" => "\\n", '"' => "\\\"")) . "\" 2>&1";
//echo $cmd."<br>";
$pyoutp = shell_exec($cmd);
$pyoutp1 = json_decode($pyoutp, true);
if ($pyoutp1 == null) {
echo str_replace("\n", "<br>", $pyoutp);
} else {
$_SESSION = $pyoutp1["_SESSION"];
if ($pyoutp1["_header"] != "") {
header($pyoutp1["_header"]);
} else {
echo $pyoutp1["printout"];
}
foreach ($pyoutp1["toresize"] as $name => $valp) {
resizeimg($name, $valp[0], $valp[1], $valp[2]);
}
function curpathinfo()
{
return $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
// if(array_key_exists("PATH_INFO", $_SERVER)) {
// return substr($_SERVER["PATH_INFO"], 1);
// } else
// return "";
}
//print_r($_SERVER);
$_GET[""] = "mohit";
$_POST[""] = "mohit";
$_SESSION[""] = "mohit";
$_FILES[""] = "mohit";
$addinfo = array("ip" => $_SERVER['REMOTE_ADDR']);
$pydata = array("get" => $_GET, "post" => $_POST, "session" => $_SESSION, "url" => curpathinfo(), "file" => $_FILES, "addinfo" => $addinfo);
$cmd = "cd " . $root . ";" . "python " . $pyfile . " \"" . str_replace('"', '\\"', tojson($pydata)) . "\" 2>&1";
$t3 = microtime(true);
$pyoutp = shell_exec($cmd);
$t4 = microtime(true);
$pyoutp1 = json_decode($pyoutp, true);
if ($pyoutp1 == null) {
echo str_replace("\n", "<br>", $pyoutp);
} else {
$_SESSION = $pyoutp1["_SESSION"];
if ($pyoutp1["_header"] != "") {
header($pyoutp1["_header"]);
} else {
echo $pyoutp1["printout"];
}
foreach ($pyoutp1["toresize"] as $name => $valp) {
resizeimg($name, $valp[0], $valp[1], $valp[2]);
function funexisteSala($id)
{
mensaje_log("FUNCION EXISTE SALA (SALA)");
$u = 0;
$query = mysql_query("SELECT id_sala FROM sala WHERE id_sala='{$id}'") or die(mysql_error());
$row = mysql_fetch_array($query);
if ($row != NULL) {
$u = 1;
mensaje_log("LA SALA DE ID =" . $id . " EXISTE", 1);
} else {
mensaje_log("LA SALA DE ID =" . $id . " NO EXISTE", 1);
}
return tojson($u);
}
private function getltoptions()
{
return sprintf('<script type="text/javascript">window.ltoptions = %s;</script>', tojson($this->ltoptions));
}
require "../conn/db_include.php";
require "locallib.php";
//must set timezone on the top
$timezone = "Asia/Hong_Kong";
if (function_exists('date_default_timezone_set')) {
date_default_timezone_set($timezone);
}
//must set timezone on the top
set_time_limit(300);
global $db;
$action = array();
$output = new stdClass();
if (!($action = optional_param("action", 0))) {
$msg = 'No action';
echo tojson($_SESSION);
//print_error($msg);
}
switch ($action) {
case 'add_transfer_from_po':
//check use can use this function
if (!check_office_staff($_SESSION['staff_no'])) {
print_error('You have no permission');
}
$pono_raw = optional_param("pono", 0);
$dnno_raw = optional_param("dnno", 0);
if (!$pono_raw) {
print_error('No PO No.');
}
$pono_temp = get_numofpo($pono_raw);
$pono = $pono_temp[1];
function getUnread($userid)
{
$sql = "SELECT u.userid, m.Name, COUNT( u.Content ) AS unread, m.ImgSrc FROM message AS u LEFT OUTER JOIN ( SELECT UserId , Name , ImgSrc FROM member ) AS m ON m.UserId = u.UserId WHERE Status = '0' AND u.UserId = '" . $userid . "' GROUP BY UserId ";
return tojson(mysql_query($sql));
}
function fungetAllDataObraSala($id)
{
global $ini_array;
//$ini_array = parse_ini_file("/var/include/confi.ini", true);
mensaje_log("FUNCION GET ALL DATA OBRA SALA (OBRA)");
$usu = $ini_array['ftpobra']['usu'];
$pass = $ini_array['ftpobra']['pass'];
$servidor = $ini_array['ftp']['servidor'];
$u = "-1";
$json = array(array());
$indice = 0;
$query = mysql_query("SELECT * FROM obra,contenido_obra WHERE obra.id_obra=contenido_obra.id_obra and obra.id_sala='{$id}'") or die(mysql_error());
while ($row = mysql_fetch_assoc($query)) {
if ($u == "-1") {
$u = "";
}
if ($row['imagen'] != 'null') {
$variable = "ftp://" . $usu . ":" . $pass . "@" . $servidor . "/" . $row['id_obra'] . "/imagen/" . $row['imagen'];
} else {
$variable = $row['imagen'];
}
$u = $u . $row['id_obra'] . "=>" . $row['nombre_obra'] . "=>" . $row['autor'] . "=>" . $row['descripcion_obra'] . "=>" . $variable . "=>";
$json[$indice++] = array('id_obra' => $row['id_obra'], 'nombre_obra' => utf8_encode($row['nombre_obra']), 'autor' => utf8_encode($row['autor']), 'descripcion' => utf8_encode($row['descripcion_obra']), 'imagen' => utf8_encode($variable));
}
mensaje_log(tojson($json, 2));
return tojson($json, 2);
}
public function json($result)
{
$js = tojson($result);
//if (litepublisher::$debug) tfiler::log("response:\n".$js, 'json.txt');
return "<?php\n header('Connection: close');\n header('Content-Length: " . strlen($js) . "');\n header('Content-Type: text/javascript; charset=utf-8');\n header('Date: " . date('r') . "');\n Header( 'Cache-Control: no-cache, must-revalidate');\n Header( 'Pragma: no-cache');\n ?>" . $js;
//header('Content-Type: application/json');
}
