/**
* 保存 字体
* @param array $font 字体列表
* @param string $savePath 保存字体路径
* @param string $saveFontListFile 保存字体列表路径
*/
function SaveFont($font, $savePath, $saveFontListFile)
{
$path = $font['path'];
$save = GetName($path);
SaveData($savePath . $save, GetData($path));
SaveFontList($saveFontListFile, $save . '=' . $font['name']);
}
function AddCoinSumStats($messagesSum)
{
$stats = ReadSource(STATS_FILE_NAME);
$DB = GetData();
$currencies = [];
foreach ($DB as $user) {
foreach ($user["currencies"] as $currencyName => $currencyAmount) {
$currencies[$currencyName] += $currencyAmount;
}
}
$stats[] = ["ts" => date("Y-m-d G:i"), "messages" => $messagesSum, "currencies" => $currencies];
SetSource(STATS_FILE_NAME, $stats);
}
}
// Checking if action is invalid
if (preg_match("/[^a-z]/", $ACTION) or strlen($ACTION) != 3) {
respond('BADACTION', '');
}
// CONNECT TO THE DATABASE
$mysqli = new mysqli('cge', 'cgeclient', 'www', 'cge');
// CHECK CONNECTION
if (mysqli_connect_errno()) {
respond("Connect failed: " . mysqli_connect_error() . "\n", '');
}
// Authorize Usage of Database
AuthUser($mysqli, $USERNAME, $SESSIONID);
if ($ACTION == 'dat') {
// GET DATA FROM DATABASE
$DATA = GetData($mysqli);
// CHECK IF ANY DATA WAS FOUND
if (count($DATA) > 0) {
respond('ACCEPTED', $DATA);
} else {
respond('NODATA', '');
}
} elseif ($ACTION == 'del') {
} elseif ($ACTION == 'upd') {
} else {
respond('UNKNOWNACTION', '');
}
//$stmt = $mysqli->prepare("SELECT i.id iid, i.name name,
// m.country country, m.region region, m.city city, m.zip zip, m.date sdate, m.origin origin, m.pathogenicity pat,
// r.id rid, r.run_id run_id, r.service service, r.date rdate,
// a.id aid, a.n50 n50,
$row = array();
$row["grid_record"] = array();
$row["grid_record"]["data"] = array();
for ($col = 1; $data && ($all || $recno <= $PageSize) && $col <= 1; $col++) {
$record = array();
$recno++;
$records++;
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["Code"]));
// Code -
$value = "";
$value = ProcessLargeText(GetData($data, "Code", ""), "field=Code" . $keylink, "", MODE_PRINT);
$record["Code_value"] = $value;
// Module Type -
$value = "";
$value = ProcessLargeText(GetData($data, "Module Type", ""), "field=Module+Type" . $keylink, "", MODE_PRINT);
$record["Module_Type_value"] = $value;
if ($col < $colsonpage) {
$record["endrecord_block"] = true;
}
$record["grid_recordheader"] = true;
$record["grid_vrecord"] = true;
if ($eventObj->exists("BeforeMoveNextPrint")) {
$eventObj->BeforeMoveNextPrint($data, $row, $record);
}
$row["grid_record"]["data"][] = $record;
if ($eventObj->exists("ListFetchArray")) {
$data = $eventObj->ListFetchArray($rs);
} else {
$data = db_fetch_array($rs);
}
//Units -
$value = "";
$value = ProcessLargeText(GetData($data, "Units", ""), "", "", MODE_VIEW);
if ($mainTableOwnerID == "Units") {
$ownerIdValue = $value;
}
$xt->assign("Units_value", $value);
if (!$pageObject->isAppearOnTabs("Units")) {
$xt->assign("Units_fieldblock", true);
} else {
$xt->assign("Units_tabfieldblock", true);
}
////////////////////////////////////////////
//PerUnit Price - Number
$value = "";
$value = ProcessLargeText(GetData($data, "PerUnit Price", "Number"), "", "", MODE_VIEW);
if ($mainTableOwnerID == "PerUnit Price") {
$ownerIdValue = $value;
}
$xt->assign("PerUnit_Price_value", $value);
if (!$pageObject->isAppearOnTabs("PerUnit Price")) {
$xt->assign("PerUnit_Price_fieldblock", true);
} else {
$xt->assign("PerUnit_Price_tabfieldblock", true);
}
/*$jsKeysObj = 'window.recKeysObj = {';
$jsKeysObj .= "'".jsreplace("Units")."': '".(jsreplace(@$data["Units"]))."', ";
$jsKeysObj = substr($jsKeysObj, 0, strlen($jsKeysObj)-2);
$jsKeysObj .= '};';
$pageObject->AddJsCode($jsKeysObj);
*/
//IsSync - Checkbox
$value = "";
$value = GetData($data, "IsSync", "Checkbox");
if ($mainTableOwnerID == "IsSync") {
$ownerIdValue = $value;
}
$xt->assign("IsSync_value", $value);
if (!$pageObject->isAppearOnTabs("IsSync")) {
$xt->assign("IsSync_fieldblock", true);
} else {
$xt->assign("IsSync_tabfieldblock", true);
}
////////////////////////////////////////////
//Currunt Readings -
$value = "";
$value = ProcessLargeText(GetData($data, "Currunt Readings", ""), "", "", MODE_VIEW);
if ($mainTableOwnerID == "Currunt Readings") {
$ownerIdValue = $value;
}
$xt->assign("Currunt_Readings_value", $value);
if (!$pageObject->isAppearOnTabs("Currunt Readings")) {
$xt->assign("Currunt_Readings_fieldblock", true);
} else {
$xt->assign("Currunt_Readings_tabfieldblock", true);
}
/*$jsKeysObj = 'window.recKeysObj = {';
$jsKeysObj .= "'".jsreplace("Record ID")."': '".(jsreplace(@$data["Record ID"]))."', ";
$jsKeysObj = substr($jsKeysObj, 0, strlen($jsKeysObj)-2);
$jsKeysObj .= '};';
$pageObject->AddJsCode($jsKeysObj);
*/
function WriteTableData()
{
global $rs, $nPageSize, $strTableName, $conn, $eventObj;
if ($eventObj->exists("ListFetchArray")) {
$row = $eventObj->ListFetchArray($rs);
} else {
$row = db_fetch_array($rs);
}
// if(!$row)
// return;
// write header
echo "<tr>";
if ($_REQUEST["type"] == "excel") {
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "ID")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Module_ID")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Anomaly_Description")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Anomaly_Type")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Date_Time")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Action_Taken")) . '</td>';
} else {
echo "<td>" . GetFieldLabel("dbo_Anomalies", "ID") . "</td>";
echo "<td>" . GetFieldLabel("dbo_Anomalies", "Module_ID") . "</td>";
echo "<td>" . GetFieldLabel("dbo_Anomalies", "Anomaly_Description") . "</td>";
echo "<td>" . GetFieldLabel("dbo_Anomalies", "Anomaly_Type") . "</td>";
echo "<td>" . GetFieldLabel("dbo_Anomalies", "Date_Time") . "</td>";
echo "<td>" . GetFieldLabel("dbo_Anomalies", "Action_Taken") . "</td>";
}
echo "</tr>";
$totals["ID"] = 0;
$totalsFields[] = array('fName' => "ID", 'totalsType' => '', 'viewFormat' => "");
$totals["Module ID"] = 0;
$totalsFields[] = array('fName' => "Module ID", 'totalsType' => '', 'viewFormat' => "");
$totals["Anomaly Description"] = 0;
$totalsFields[] = array('fName' => "Anomaly Description", 'totalsType' => '', 'viewFormat' => "");
$totals["Anomaly Type"] = 0;
$totalsFields[] = array('fName' => "Anomaly Type", 'totalsType' => '', 'viewFormat' => "");
$totals["Date Time"] = 0;
$totalsFields[] = array('fName' => "Date Time", 'totalsType' => '', 'viewFormat' => "Short Date");
$totals["Action Taken"] = 0;
$totalsFields[] = array('fName' => "Action Taken", 'totalsType' => '', 'viewFormat' => "");
$totals = array();
// write data rows
$iNumberOfRows = 0;
while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
countTotals($totals, $totalsFields, $row);
$values = array();
$format = "";
$values["ID"] = GetData($row, "ID", $format);
$values["Module ID"] = "";
if (strlen($row["Module ID"])) {
$values["Module ID"] = DisplayLookupWizard("Module ID", $row["Module ID"], $row, "", MODE_EXPORT);
}
$format = "";
$values["Anomaly Description"] = GetData($row, "Anomaly Description", $format);
$values["Anomaly Type"] = "";
if (strlen($row["Anomaly Type"])) {
$values["Anomaly Type"] = DisplayLookupWizard("Anomaly Type", $row["Anomaly Type"], $row, "", MODE_EXPORT);
}
$format = "Short Date";
$values["Date Time"] = GetData($row, "Date Time", $format);
$values["Action Taken"] = "";
if (strlen($row["Action Taken"])) {
$values["Action Taken"] = DisplayLookupWizard("Action Taken", $row["Action Taken"], $row, "", MODE_EXPORT);
}
$eventRes = true;
if ($eventObj->exists('BeforeOut')) {
$eventRes = $eventObj->BeforeOut($row, $values);
}
if ($eventRes) {
$iNumberOfRows++;
echo "<tr>";
echo '<td>';
$format = "";
echo htmlspecialchars($values["ID"]);
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Module ID"]);
} else {
echo htmlspecialchars($values["Module ID"]);
}
echo '</td>';
if ($_REQUEST["type"] == "excel") {
echo '<td x:str>';
} else {
echo '<td>';
}
$format = "";
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Anomaly Description"]);
} else {
echo htmlspecialchars($values["Anomaly Description"]);
}
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Anomaly Type"]);
} else {
echo htmlspecialchars($values["Anomaly Type"]);
}
echo '</td>';
echo '<td>';
$format = "Short Date";
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Date Time"]);
} else {
echo htmlspecialchars($values["Date Time"]);
}
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Action Taken"]);
} else {
echo htmlspecialchars($values["Action Taken"]);
}
echo '</td>';
echo "</tr>";
}
if ($eventObj->exists("ListFetchArray")) {
$row = $eventObj->ListFetchArray($rs);
} else {
$row = db_fetch_array($rs);
}
}
}
//Anomaly Type -
$value = "";
$value = DisplayLookupWizard("Anomaly Type", $data["Anomaly Type"], $data, $keylink, MODE_VIEW);
if ($mainTableOwnerID == "Anomaly Type") {
$ownerIdValue = $value;
}
$xt->assign("Anomaly_Type_value", $value);
if (!$pageObject->isAppearOnTabs("Anomaly Type")) {
$xt->assign("Anomaly_Type_fieldblock", true);
} else {
$xt->assign("Anomaly_Type_tabfieldblock", true);
}
////////////////////////////////////////////
//Date Time - Short Date
$value = "";
$value = ProcessLargeText(GetData($data, "Date Time", "Short Date"), "", "", MODE_VIEW);
if ($mainTableOwnerID == "Date Time") {
$ownerIdValue = $value;
}
$xt->assign("Date_Time_value", $value);
if (!$pageObject->isAppearOnTabs("Date Time")) {
$xt->assign("Date_Time_fieldblock", true);
} else {
$xt->assign("Date_Time_tabfieldblock", true);
}
////////////////////////////////////////////
//Action Taken -
$value = "";
$value = DisplayLookupWizard("Action Taken", $data["Action Taken"], $data, $keylink, MODE_VIEW);
if ($mainTableOwnerID == "Action Taken") {
$ownerIdValue = $value;
$record = array();
$recno++;
$records++;
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["UserID"]));
// UserID -
$value = "";
$value = ProcessLargeText(GetData($data, "UserID", ""), "field=UserID" . $keylink, "", MODE_PRINT);
$record["UserID_value"] = $value;
// Password -
$value = "";
$value = ProcessLargeText(GetData($data, "Password", ""), "field=Password" . $keylink, "", MODE_PRINT);
$record["Password_value"] = $value;
// User Name -
$value = "";
$value = ProcessLargeText(GetData($data, "User Name", ""), "field=User+Name" . $keylink, "", MODE_PRINT);
$record["User_Name_value"] = $value;
// Role -
$value = "";
$value = DisplayLookupWizard("Role", $data["Role"], $data, $keylink, MODE_PRINT);
$record["Role_value"] = $value;
if ($col < $colsonpage) {
$record["endrecord_block"] = true;
}
$record["grid_recordheader"] = true;
$record["grid_vrecord"] = true;
if ($eventObj->exists("BeforeMoveNextPrint")) {
$eventObj->BeforeMoveNextPrint($data, $row, $record);
}
$row["grid_record"]["data"][] = $record;
if ($eventObj->exists("ListFetchArray")) {
}
if ($rowcount > $display_count + 2) {
$xt->assign("display_first", true);
$xt->assign("display_count", $display_count);
} else {
$display_count = $rowcount;
}
$rowinfo = array();
while (($data = db_fetch_array($rs)) && $recordsCounter < $display_count) {
$recordsCounter++;
$row = array();
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"]));
// ID -
$value = "";
$value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink, "", MODE_PRINT);
$row["ID_value"] = $value;
// Customer ID -
$value = "";
$value = DisplayLookupWizard("Customer ID", $data["Customer ID"], $data, $keylink, MODE_PRINT);
$row["Customer_ID_value"] = $value;
// Module ID -
$value = "";
$value = DisplayLookupWizard("Module ID", $data["Module ID"], $data, $keylink, MODE_PRINT);
$row["Module_ID_value"] = $value;
$rowinfo[] = $row;
}
$xt->assign_loopsection("details_row", $rowinfo);
} else {
}
$xt->display("Customer_Module_Assignment_detailspreview.htm");
function DisplayMasterTableInfo_LU_Anomaly_Type($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "dbo.LU_Anomaly Type";
//$strSQL = "SELECT Code, [Tamper Type] FROM dbo.[LU_Anomaly Type]";
$sqlHead = "SELECT Code, [Tamper Type]";
$sqlFrom = "FROM dbo.[LU_Anomaly Type]";
$sqlWhere = "";
$sqlTail = "";
$where = "";
global $page_styles, $page_layouts, $page_layout_names, $container_styles;
$layout = new TLayout("masterprint", "BoldOrange", "MobileOrange");
$layout->blocks["bare"] = array();
$layout->containers["0"] = array();
$layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1);
$layout->skins["0"] = "empty";
$layout->blocks["bare"][] = "0";
$layout->containers["mastergrid"] = array();
$layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1);
$layout->skins["mastergrid"] = "grid";
$layout->blocks["bare"][] = "mastergrid";
$page_layouts["LU_Anomaly_Type_masterprint"] = $layout;
if ($detailtable == "dbo.Anomalies") {
$where .= GetFullFieldName("Code") . "=" . make_db_value("Code", $keys[1 - 1]);
}
if (!$where) {
$strTableName = $oldTableName;
return;
}
$str = SecuritySQL("Export");
if (strlen($str)) {
$where .= " and " . $str;
}
$strWhere = whereAdd($sqlWhere, $where);
if (strlen($strWhere)) {
$strWhere = " where " . $strWhere . " ";
}
$strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail;
// $strSQL=AddWhere($strSQL,$where);
LogInfo($strSQL);
$rs = db_query($strSQL, $conn);
$data = db_fetch_array($rs);
if (!$data) {
$strTableName = $oldTableName;
return;
}
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["Code"]));
// Code -
$value = "";
$value = ProcessLargeText(GetData($data, "Code", ""), "field=Code" . $keylink, "", MODE_PRINT);
$xt->assign("Code_mastervalue", $value);
// Tamper Type -
$value = "";
$value = ProcessLargeText(GetData($data, "Tamper Type", ""), "field=Tamper+Type" . $keylink, "", MODE_PRINT);
$xt->assign("Tamper_Type_mastervalue", $value);
$xt->display("LU_Anomaly_Type_masterprint.htm");
$strTableName = $oldTableName;
}
* Company Properties aJax actions
* ******************************
*/
include '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
case 'set_data':
$name = $_REQUEST['name'];
$address = $_REQUEST['address'];
$payer = $_REQUEST['payer'];
SetData($name, $address, $payer);
break;
case 'get_data':
$data = GetData();
break;
default:
$error = "Action is Null";
}
$data['error'] = $error;
echo json_encode($data);
/* ******************************
* Company Properties Functions
* ******************************
*/
function SetData($name, $address, $payer)
{
mysql_query("UPDATE `company_properties`\r\n\t\t\t\t SET `name`\t = '{$name}',\r\n\t\t\t\t `address` = '{$address}',\r\n\t\t\t\t `payer` = {$payer}\r\n\t\t\t\t WHERE `id` = 1\r\n\t\t\t\t");
}
function GetData()
<?php
// Данный код создан и распространяется по лицензии GPL v3
// Изначальный автор данного кода - Грибов Павел
// http://грибовы.рф
include_once "config.php";
// загружаем настройки и функции для работы с 1С
function GetData($idc, $txt)
{
if (is_object($idc)) {
try {
$par = array('kode' => $txt);
//var_dump($par);
$ret1c = $idc->GetListTMCGroup($par);
} catch (SoapFault $e) {
echo "АЩИБКА!!! </br>";
var_dump($e);
}
} else {
echo 'Не удалося подключиться к 1С<br>';
var_dump($idc);
}
return $ret1c;
}
$idc = Connect1C("http://10.80.16.34/upp_rss/ws/ws1.1cws?wsdl");
$ret1c = GetData($idc, "00000000064");
//var_dump($ret1c);
$aa = $ret1c->return;
echo $aa;
$row = array();
$row["grid_record"] = array();
$row["grid_record"]["data"] = array();
for ($col = 1; $data && ($all || $recno <= $PageSize) && $col <= 1; $col++) {
$record = array();
$recno++;
$records++;
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["Code"]));
// Code -
$value = "";
$value = ProcessLargeText(GetData($data, "Code", ""), "field=Code" . $keylink, "", MODE_PRINT);
$record["Code_value"] = $value;
// Status -
$value = "";
$value = ProcessLargeText(GetData($data, "Status", ""), "field=Status" . $keylink, "", MODE_PRINT);
$record["Status_value"] = $value;
if ($col < $colsonpage) {
$record["endrecord_block"] = true;
}
$record["grid_recordheader"] = true;
$record["grid_vrecord"] = true;
if ($eventObj->exists("BeforeMoveNextPrint")) {
$eventObj->BeforeMoveNextPrint($data, $row, $record);
}
$row["grid_record"]["data"][] = $record;
if ($eventObj->exists("ListFetchArray")) {
$data = $eventObj->ListFetchArray($rs);
} else {
$data = db_fetch_array($rs);
}
/**
* 名称: 编辑用户
*/
public function editAction()
{
if (isset($_POST) && !empty($_POST)) {
$data['id'] = $_POST['id'];
$data['username'] = htmlspecialchars_decode(trim($_POST['username']));
$data['truename'] = htmlspecialchars_decode(trim($_POST['truename']));
$data['birthday'] = trim($_POST['birthday']);
$data['sex'] = $_POST['sex'];
$data['mobile'] = trim($_POST['mobile']);
$data['address'] = htmlspecialchars_decode(trim($_POST['address']));
$data['qq'] = trim($_POST['qq']);
$data['status'] = $_POST['status'];
$result = PostData($this->UserUp_Url, $data);
if ('0000' == $result['retCode']) {
header("Location: /user/index");
}
}
$userinfo = GetData($this->UserInfo_Url . '?id=' . $_GET['id']);
$this->getView()->assign("title", $this->title);
$this->getView()->assign("userinfo", $userinfo);
}
//Code -
$value = "";
$value = ProcessLargeText(GetData($data, "Code", ""), "", "", MODE_VIEW);
if ($mainTableOwnerID == "Code") {
$ownerIdValue = $value;
}
$xt->assign("Code_value", $value);
if (!$pageObject->isAppearOnTabs("Code")) {
$xt->assign("Code_fieldblock", true);
} else {
$xt->assign("Code_tabfieldblock", true);
}
////////////////////////////////////////////
//Module Type -
$value = "";
$value = ProcessLargeText(GetData($data, "Module Type", ""), "", "", MODE_VIEW);
if ($mainTableOwnerID == "Module Type") {
$ownerIdValue = $value;
}
$xt->assign("Module_Type_value", $value);
if (!$pageObject->isAppearOnTabs("Module Type")) {
$xt->assign("Module_Type_fieldblock", true);
} else {
$xt->assign("Module_Type_tabfieldblock", true);
}
/*$jsKeysObj = 'window.recKeysObj = {';
$jsKeysObj .= "'".jsreplace("Code")."': '".(jsreplace(@$data["Code"]))."', ";
$jsKeysObj = substr($jsKeysObj, 0, strlen($jsKeysObj)-2);
$jsKeysObj .= '};';
$pageObject->AddJsCode($jsKeysObj);
*/
function DisplayMasterTableInfo_Customers($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "dbo.Customers";
//$strSQL = "SELECT ID, Name, [Father Name], Address, Contact, Location, [Customer Type] FROM dbo.Customers";
$sqlHead = "SELECT ID, Name, [Father Name], Address, Contact, Location, [Customer Type]";
$sqlFrom = "FROM dbo.Customers";
$sqlWhere = "";
$sqlTail = "";
$where = "";
$mKeys = array();
$showKeys = "";
global $page_styles, $page_layouts, $page_layout_names, $container_styles;
$layout = new TLayout("masterlist", "BoldOrange", "MobileOrange");
$layout->blocks["bare"] = array();
$layout->containers["0"] = array();
$layout->containers["0"][] = array("name" => "masterlistheader", "block" => "", "substyle" => 1);
$layout->skins["0"] = "empty";
$layout->blocks["bare"][] = "0";
$layout->containers["mastergrid"] = array();
$layout->containers["mastergrid"][] = array("name" => "masterlistfields", "block" => "", "substyle" => 1);
$layout->skins["mastergrid"] = "grid";
$layout->blocks["bare"][] = "mastergrid";
$page_layouts["Customers_masterlist"] = $layout;
if ($detailtable == "dbo.Customer Module Assignment") {
$where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]);
$showKeys .= " " . GetFieldLabel("dbo_Customers", "ID") . ": " . $keys[1 - 1];
$xt->assign('showKeys', $showKeys);
}
if (!$where) {
$strTableName = $oldTableName;
return;
}
$str = SecuritySQL("Search");
if (strlen($str)) {
$where .= " and " . $str;
}
$strWhere = whereAdd($sqlWhere, $where);
if (strlen($strWhere)) {
$strWhere = " where " . $strWhere . " ";
}
$strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail;
// $strSQL=AddWhere($strSQL,$where);
LogInfo($strSQL);
$rs = db_query($strSQL, $conn);
$data = db_fetch_array($rs);
if (!$data) {
$strTableName = $oldTableName;
return;
}
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"]));
// ID -
$value = "";
$value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink);
$xt->assign("ID_mastervalue", $value);
// Name -
$value = "";
$value = ProcessLargeText(GetData($data, "Name", ""), "field=Name" . $keylink);
$xt->assign("Name_mastervalue", $value);
// Father Name -
$value = "";
$value = ProcessLargeText(GetData($data, "Father Name", ""), "field=Father+Name" . $keylink);
$xt->assign("Father_Name_mastervalue", $value);
// Address -
$value = "";
$value = ProcessLargeText(GetData($data, "Address", ""), "field=Address" . $keylink);
$xt->assign("Address_mastervalue", $value);
// Contact -
$value = "";
$value = ProcessLargeText(GetData($data, "Contact", ""), "field=Contact" . $keylink);
$xt->assign("Contact_mastervalue", $value);
// Location -
$value = "";
$value = DisplayLookupWizard("Location", $data["Location"], $data, $keylink, MODE_LIST);
$xt->assign("Location_mastervalue", $value);
// Customer Type -
$value = "";
$value = DisplayLookupWizard("Customer Type", $data["Customer Type"], $data, $keylink, MODE_LIST);
$xt->assign("Customer_Type_mastervalue", $value);
$xt->display("Customers_masterlist.htm");
$strTableName = $oldTableName;
}
$row["PF_Yellow_value"] = $value;
// Peak Power -
$value = "";
$value = ProcessLargeText(GetData($data, "Peak Power", ""), "field=Peak+Power" . $keylink, "", MODE_PRINT);
$row["Peak_Power_value"] = $value;
// Date Time - Short Date
$value = "";
$value = ProcessLargeText(GetData($data, "Date Time", "Short Date"), "field=Date+Time" . $keylink, "", MODE_PRINT);
$row["Date_Time_value"] = $value;
// IsSync - Checkbox
$value = "";
$value = GetData($data, "IsSync", "Checkbox");
$row["IsSync_value"] = $value;
// Currunt Readings -
$value = "";
$value = ProcessLargeText(GetData($data, "Currunt Readings", ""), "field=Currunt+Readings" . $keylink, "", MODE_PRINT);
$row["Currunt_Readings_value"] = $value;
$rowinfo[] = $row;
}
$xt->assign_loopsection("details_row", $rowinfo);
} else {
}
$xt->display("Readings_detailspreview.htm");
if ($mode != "inline") {
echo "counterSeparator" . postvalue("counter");
$layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview');
if ($layout) {
$rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
echo "counterSeparator" . "styles/" . $layout->style . "/style" . $rtl . "counterSeparator" . "pagestyles/" . $layout->name . $rtl . "counterSeparator" . $layout->style . " page-" . $layout->name;
}
}
$response['message'] = $api_response_code[$response['code']]['Message'];
sendresponse($response);
} else {
if ($_POST['securitycode'] != 'foo' || $_POST['passkey'] != 'bar') {
$response['code'] = 4;
$response['status'] = $api_response_code[$response['code']]['HTTP Response'];
$response['message'] = $api_response_code[$response['code']]['Message'];
sendresponse($response);
}
}
}
/* we passed - send the data back */
$response['code'] = 1;
$response['status'] = $api_response_code[$response['code']]['HTTP Response'];
$response['message'] = $api_response_code[$response['code']]['Message'];
$response['data'] = GetData();
sendresponse($response);
function sendresponse($response)
{
header('HTTP/1.1 ' . $response['status'] . ' ' . $response['message']);
header('Content-Type: application/json; charset=utf-8');
echo json_encode($response);
exit;
}
function GetData()
{
$product_list = array(array('name' => "Callaway Driver", 'category' => "Golf", 'price' => 200.0, 'description' => "Fantastic driver. Used for hitting long!"), array('name' => "Lucky Jeans", 'category' => "Pants", 'price' => 100.0, 'description' => "Nice comfortable jeans."), array('name' => "Nord Fire 3", 'category' => "Musical Instruments", 'price' => 2500.0, 'description' => "Nords new B3 Organ simulator! Reach new heights!"), array('name' => "Zone Monitor Speakers", 'category' => "Electronics", 'price' => 500.0, 'description' => "Great quality sounding speakers. Turn them up for your next party!"));
return $product_list;
}
?>
include_once "../../../../inc/config.php";
// подгружаем настройки из БД, получаем заполненый класс $cfg
include_once "../../../../inc/functions.php";
// загружаем функции
include_once "../../../../inc/login.php";
// логинимся
$nome_group = _GET("nome_group");
include_once "config.php";
// загружаем настройки и функции для работы с 1С
function GetData($idc, $txt)
{
if (is_object($idc)) {
try {
$par = array('kode' => $txt);
//var_dump($par);
$ret1c = $idc->GetListTMC($par);
} catch (SoapFault $e) {
echo "АЩИБКА!!! </br>";
var_dump($e);
}
} else {
echo 'Не удалося подключиться к 1С<br>';
var_dump($idc);
}
return $ret1c;
}
$idc = Connect1C("http://10.80.16.34/upp_rss/ws/ws1.1cws?wsdl");
$ret1c = GetData($idc, $nome_group);
//var_dump($ret1c);
$aa = $ret1c->return;
echo "{$aa}";
$row["ID_value"] = $value;
// Name -
$value = "";
$value = ProcessLargeText(GetData($data, "Name", ""), "field=Name" . $keylink, "", MODE_PRINT);
$row["Name_value"] = $value;
// Father Name -
$value = "";
$value = ProcessLargeText(GetData($data, "Father Name", ""), "field=Father+Name" . $keylink, "", MODE_PRINT);
$row["Father_Name_value"] = $value;
// Address -
$value = "";
$value = ProcessLargeText(GetData($data, "Address", ""), "field=Address" . $keylink, "", MODE_PRINT);
$row["Address_value"] = $value;
// Contact -
$value = "";
$value = ProcessLargeText(GetData($data, "Contact", ""), "field=Contact" . $keylink, "", MODE_PRINT);
$row["Contact_value"] = $value;
// Location -
$value = "";
$value = DisplayLookupWizard("Location", $data["Location"], $data, $keylink, MODE_PRINT);
$row["Location_value"] = $value;
// Customer Type -
$value = "";
$value = DisplayLookupWizard("Customer Type", $data["Customer Type"], $data, $keylink, MODE_PRINT);
$row["Customer_Type_value"] = $value;
$rowinfo[] = $row;
}
$xt->assign_loopsection("details_row", $rowinfo);
} else {
}
$xt->display("Customers_detailspreview.htm");
//xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xhttp.send();
}
//]]>
</script>
</head>
<body>
</body>
</html>
<?php
include_once 'databaseHelper.php';
$products = GetData("bicycles");
//echo "<pre>";
//print_r();
//echo "</pre>";
$i = 0;
foreach ($products as $singleProduct) {
if ($singleProduct != null) {
echo "<pre>";
//print_r($singleProduct);
echo "</pre>";
?>
<div id="<?php
echo "prod_container" . $i;
?>
" style="border-top: 1px solid;border-bottom: 1px solid;background-color:#FF557F;">
<div>
$controls["controls"]['preloadData'] = $preload;
}
$pageObject->fillControlsMap($controls);
//fill field tool tips
$pageObject->fillFieldToolTips($fName);
// fill special settings for timepicker
if (GetEditFormat($fName) == 'Time') {
$pageObject->fillTimePickSettings($fName, @$defvalues[$fName]);
}
if (($detailKeys && in_array($fName, $detailKeys) || $fName == postvalue("category")) && array_key_exists($fName, $defvalues)) {
if ((GetEditFormat($fName) == EDIT_FORMAT_LOOKUP_WIZARD || GetEditFormat($fName) == EDIT_FORMAT_RADIO) && GetpLookupType($fName) == LT_LOOKUPTABLE) {
$value = DisplayLookupWizard($fName, $defvalues[$fName], $defvalues, "", MODE_VIEW);
} elseif (NeedEncode($fName)) {
$value = ProcessLargeText(GetData($defvalues, $fName, ViewFormat($fName)), "field=" . rawurlencode(htmlspecialchars($fName)), "", MODE_VIEW);
} else {
$value = GetData($defvalues, $fName, ViewFormat($fName));
}
$xt->assign($gfName . "_editcontrol", $value);
}
}
//fill tab groups name and sections name to controls
$pageObject->fillCntrlTabGroups();
/////////////////////////////////////////////////////////////
if ($pageObject->isShowDetailTables && ($inlineadd == ADD_SIMPLE || $inlineadd == ADD_POPUP) && !isMobile()) {
if (count($dpParams['ids'])) {
$xt->assign("detail_tables", true);
include 'classes/listpage.php';
include 'classes/listpage_embed.php';
include 'classes/listpage_dpinline.php';
include "classes/searchclause.php";
}
<?php
header("Access-Control-Allow-Origin: http://localhost:4000");
function GetData($Url)
{
$CurlHandle = curl_init();
curl_setopt($CurlHandle, CURLOPT_URL, $Url);
curl_setopt($CurlHandle, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($CurlHandle, CURLOPT_CONNECTTIMEOUT, 10);
$Data = curl_exec($CurlHandle);
curl_close($CurlHandle);
return $Data;
}
if (isset($_POST['links']) && isset($_POST['project'])) {
$Links = $_POST['links'];
$ZipName = $_POST['project'] . '.zip';
$Archive = new ZipArchive();
if ($Archive->open($ZipName, ZipArchive::CREATE) === true) {
foreach ($Links as $Link) {
$Archive->addFromString(basename($Link), GetData($Link));
}
$Archive->close();
echo $ZipName;
} else {
echo 'error';
}
}
//fill field tool tips
$pageObject->fillFieldToolTips($fName);
// fill special settings for timepicker
if (GetEditFormat($fName) == 'Time') {
$pageObject->fillTimePickSettings($fName, $data[$fName]);
}
if (ViewFormat($fName) == FORMAT_MAP) {
$pageObject->googleMapCfg['isUseGoogleMap'] = true;
}
if ($detailKeys && in_array($fName, $detailKeys) && array_key_exists($fName, $data)) {
if ((GetEditFormat($fName) == EDIT_FORMAT_LOOKUP_WIZARD || GetEditFormat($fName) == EDIT_FORMAT_RADIO) && GetpLookupType($fName) == LT_LOOKUPTABLE) {
$value = DisplayLookupWizard($fName, $data[$fName], $data, "", MODE_VIEW);
} elseif (NeedEncode($fName)) {
$value = ProcessLargeText(GetData($data, $fName, ViewFormat($fName)), "field=" . rawurlencode(htmlspecialchars($fName)), "", MODE_VIEW);
} else {
$value = GetData($data, $fName, ViewFormat($fName));
}
$xt->assign($gfName . "_editcontrol", $value);
}
}
//fill tab groups name and sections name to controls
$pageObject->fillCntrlTabGroups();
$pageObject->jsSettings['tableSettings'][$strTableName]["keys"] = $keys;
$pageObject->jsSettings['tableSettings'][$strTableName]["prevKeys"] = $prev;
$pageObject->jsSettings['tableSettings'][$strTableName]["nextKeys"] = $next;
if ($pageObject->lockingObj) {
$pageObject->jsSettings['tableSettings'][$strTableName]["sKeys"] = $skeys;
$pageObject->jsSettings['tableSettings'][$strTableName]["enableCtrls"] = $enableCtrlsForEditing;
$pageObject->jsSettings['tableSettings'][$strTableName]["confirmTime"] = $pageObject->lockingObj->ConfirmTime;
}
/////////////////////////////////////////////////////////////
$row = array();
$row["grid_record"] = array();
$row["grid_record"]["data"] = array();
for ($col = 1; $data && ($all || $recno <= $PageSize) && $col <= 1; $col++) {
$record = array();
$recno++;
$records++;
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["Code"]));
// Code -
$value = "";
$value = ProcessLargeText(GetData($data, "Code", ""), "field=Code" . $keylink, "", MODE_PRINT);
$record["Code_value"] = $value;
// Action -
$value = "";
$value = ProcessLargeText(GetData($data, "Action", ""), "field=Action" . $keylink, "", MODE_PRINT);
$record["Action_value"] = $value;
if ($col < $colsonpage) {
$record["endrecord_block"] = true;
}
$record["grid_recordheader"] = true;
$record["grid_vrecord"] = true;
if ($eventObj->exists("BeforeMoveNextPrint")) {
$eventObj->BeforeMoveNextPrint($data, $row, $record);
}
$row["grid_record"]["data"][] = $record;
if ($eventObj->exists("ListFetchArray")) {
$data = $eventObj->ListFetchArray($rs);
} else {
$data = db_fetch_array($rs);
}
function WriteTableData()
{
global $rs, $nPageSize, $strTableName, $conn, $eventObj;
if ($eventObj->exists("ListFetchArray")) {
$row = $eventObj->ListFetchArray($rs);
} else {
$row = db_fetch_array($rs);
}
// if(!$row)
// return;
// write header
echo "<tr>";
if ($_REQUEST["type"] == "excel") {
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_User_Roles", "Code")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_User_Roles", "Role")) . '</td>';
} else {
echo "<td>" . GetFieldLabel("dbo_User_Roles", "Code") . "</td>";
echo "<td>" . GetFieldLabel("dbo_User_Roles", "Role") . "</td>";
}
echo "</tr>";
$totals["Code"] = 0;
$totalsFields[] = array('fName' => "Code", 'totalsType' => '', 'viewFormat' => "");
$totals["Role"] = 0;
$totalsFields[] = array('fName' => "Role", 'totalsType' => '', 'viewFormat' => "");
$totals = array();
// write data rows
$iNumberOfRows = 0;
while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
countTotals($totals, $totalsFields, $row);
$values = array();
$format = "";
$values["Code"] = GetData($row, "Code", $format);
$format = "";
$values["Role"] = GetData($row, "Role", $format);
$eventRes = true;
if ($eventObj->exists('BeforeOut')) {
$eventRes = $eventObj->BeforeOut($row, $values);
}
if ($eventRes) {
$iNumberOfRows++;
echo "<tr>";
echo '<td>';
$format = "";
echo htmlspecialchars($values["Code"]);
echo '</td>';
if ($_REQUEST["type"] == "excel") {
echo '<td x:str>';
} else {
echo '<td>';
}
$format = "";
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Role"]);
} else {
echo htmlspecialchars($values["Role"]);
}
echo '</td>';
echo "</tr>";
}
if ($eventObj->exists("ListFetchArray")) {
$row = $eventObj->ListFetchArray($rs);
} else {
$row = db_fetch_array($rs);
}
}
}
$row = array();
$row["grid_record"] = array();
$row["grid_record"]["data"] = array();
for ($col = 1; $data && ($all || $recno <= $PageSize) && $col <= 1; $col++) {
$record = array();
$recno++;
$records++;
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["Code"]));
// Code -
$value = "";
$value = ProcessLargeText(GetData($data, "Code", ""), "field=Code" . $keylink, "", MODE_PRINT);
$record["Code_value"] = $value;
// Tamper Type -
$value = "";
$value = ProcessLargeText(GetData($data, "Tamper Type", ""), "field=Tamper+Type" . $keylink, "", MODE_PRINT);
$record["Tamper_Type_value"] = $value;
if ($col < $colsonpage) {
$record["endrecord_block"] = true;
}
$record["grid_recordheader"] = true;
$record["grid_vrecord"] = true;
if ($eventObj->exists("BeforeMoveNextPrint")) {
$eventObj->BeforeMoveNextPrint($data, $row, $record);
}
$row["grid_record"]["data"][] = $record;
if ($eventObj->exists("ListFetchArray")) {
$data = $eventObj->ListFetchArray($rs);
} else {
$data = db_fetch_array($rs);
}
function DisplayMasterTableInfo_Module($params)
{
$detailtable = $params["detailtable"];
$keys = $params["keys"];
global $conn, $strTableName;
$xt = new Xtempl();
$oldTableName = $strTableName;
$strTableName = "dbo.Module";
//$strSQL = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date] FROM dbo.[Module]";
$sqlHead = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date]";
$sqlFrom = "FROM dbo.[Module]";
$sqlWhere = "";
$sqlTail = "";
$where = "";
global $page_styles, $page_layouts, $page_layout_names, $container_styles;
$layout = new TLayout("masterprint", "BoldOrange", "MobileOrange");
$layout->blocks["bare"] = array();
$layout->containers["0"] = array();
$layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1);
$layout->skins["0"] = "empty";
$layout->blocks["bare"][] = "0";
$layout->containers["mastergrid"] = array();
$layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1);
$layout->skins["mastergrid"] = "grid";
$layout->blocks["bare"][] = "mastergrid";
$page_layouts["Module_masterprint"] = $layout;
if ($detailtable == "dbo.Anomalies") {
$where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]);
}
if ($detailtable == "dbo.Customer Module Assignment") {
$where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]);
}
if ($detailtable == "dbo.Readings") {
$where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]);
}
if (!$where) {
$strTableName = $oldTableName;
return;
}
$str = SecuritySQL("Export");
if (strlen($str)) {
$where .= " and " . $str;
}
$strWhere = whereAdd($sqlWhere, $where);
if (strlen($strWhere)) {
$strWhere = " where " . $strWhere . " ";
}
$strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail;
// $strSQL=AddWhere($strSQL,$where);
LogInfo($strSQL);
$rs = db_query($strSQL, $conn);
$data = db_fetch_array($rs);
if (!$data) {
$strTableName = $oldTableName;
return;
}
$keylink = "";
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"]));
// ID -
$value = "";
$value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink, "", MODE_PRINT);
$xt->assign("ID_mastervalue", $value);
// Module Type -
$value = "";
$value = DisplayLookupWizard("Module Type", $data["Module Type"], $data, $keylink, MODE_PRINT);
$xt->assign("Module_Type_mastervalue", $value);
// Module Status -
$value = "";
$value = DisplayLookupWizard("Module Status", $data["Module Status"], $data, $keylink, MODE_PRINT);
$xt->assign("Module_Status_mastervalue", $value);
// Module Condition -
$value = "";
$value = DisplayLookupWizard("Module Condition", $data["Module Condition"], $data, $keylink, MODE_PRINT);
$xt->assign("Module_Condition_mastervalue", $value);
// Serial Num -
$value = "";
$value = ProcessLargeText(GetData($data, "Serial Num", ""), "field=Serial+Num" . $keylink, "", MODE_PRINT);
$xt->assign("Serial_Num_mastervalue", $value);
// Entry Date - Short Date
$value = "";
$value = ProcessLargeText(GetData($data, "Entry Date", "Short Date"), "field=Entry+Date" . $keylink, "", MODE_PRINT);
$xt->assign("Entry_Date_mastervalue", $value);
$xt->display("Module_masterprint.htm");
$strTableName = $oldTableName;
}
$record["Previous_Readings_value"] = $value;
// Currunt Readings -
$value = "";
$value = ProcessLargeText(GetData($data, "Currunt Readings", ""), "field=Currunt+Readings" . $keylink, "", MODE_PRINT);
$record["Currunt_Readings_value"] = $value;
// Unit Consumed -
$value = "";
$value = ProcessLargeText(GetData($data, "Unit Consumed", ""), "field=Unit+Consumed" . $keylink, "", MODE_PRINT);
$record["Unit_Consumed_value"] = $value;
// Bill Amount -
$value = "";
$value = ProcessLargeText(GetData($data, "Bill Amount", ""), "field=Bill+Amount" . $keylink, "", MODE_PRINT);
$record["Bill_Amount_value"] = $value;
// Due Date -
$value = "";
$value = ProcessLargeText(GetData($data, "Due Date", ""), "field=Due+Date" . $keylink, "", MODE_PRINT);
$record["Due_Date_value"] = $value;
if ($col < $colsonpage) {
$record["endrecord_block"] = true;
}
$record["grid_recordheader"] = true;
$record["grid_vrecord"] = true;
if ($eventObj->exists("BeforeMoveNextPrint")) {
$eventObj->BeforeMoveNextPrint($data, $row, $record);
}
$row["grid_record"]["data"][] = $record;
if ($eventObj->exists("ListFetchArray")) {
$data = $eventObj->ListFetchArray($rs);
} else {
$data = db_fetch_array($rs);
}
