function show_site($id_user)
{
$ref_show = $_SESSION['ref_sell_number'];
connect_db();
// Show SOLD ITEMS by USER in the session
$sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Barcode_has_Buyer ON Barcode.id_Barcode=Barcode_has_Buyer.Barcode_id_Barcode Where stock_out=1 AND Barcode_has_Buyer.user_2='{$id_user}' AND ref_sell_number='{$ref_show}' ORDER BY date_sold DESC";
//show transaction started as zero means a fresh transaction that dad
//if($ref_show==0)
// $sql_select="SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Barcode_has_Buyer ON Barcode.id_Barcode=Barcode_has_Buyer.Barcode_id_Barcode Where stock_out=1 AND Barcode_has_Buyer.user_2='$id_user' AND ref_sell_number='$ref_show' ORDER BY date_sold DESC";
$result = query_select($sql_select);
while ($rek = mysql_fetch_array($result)) {
echo "<tr><td>";
echo $rek["Barcode"];
echo "</td><td>";
echo $rek["stock_in"];
echo "</td><td>";
echo $rek["stock_out"];
//echo "sdfsdf";
echo "</td><td>";
echo $rek["Item_id_item"];
echo "</td><td>";
echo $rek["date"];
echo "</td><td>";
echo $rek["name"];
echo "</td><td>";
echo $rek["brand"];
echo "</td><td>";
echo $rek["pn"];
echo "</td><td>";
echo $rek["ref_sell_number"];
echo "</td><td>";
echo "Sold";
echo "</td></tr>";
}
}
function get_token_category($token)
{
$sql = "SELECT * FROM token_dynamic where idtoken='{$token}'";
$result = query_select($sql);
$rek = mysql_fetch_array($result);
return $rek['category_spare'];
}
function get_name_item_cat($id_c)
{
$sql1 = "SELECT * FROM item Where Item_has_Cat_id_item_cat='{$id_c}'";
$result = query_select($sql1);
$rek = mysql_fetch_array($result);
return $rek['name'];
}
function get_weight_fully_reused($site_id)
{
$sql = "SELECT SUM(weight) as suma, site_id, Barcode.date,login,Ready,town,cat FROM barcode INNER JOIN test ON Barcode.id_Barcode=test.Barcode_id_Barcode\r\nINNER JOIN user_2 ON user_2.id_user=test.user_2_id_user \r\nINNER JOIN Item on Barcode.Item_id_item=Item.id_item\r\nINNER JOIN item_has_cat ON Item.Item_has_Cat_id_item_cat=item_has_cat.id_item_cat\r\nINNER JOIN site ON site.site_id=barcode.Site_site_id\r\nINNER JOIN Origin On Origin.Origin_id=site.Origin_origin_id\r\nWHERE (Barcode LIKE '%DBS/%/1' OR Barcode LIKE '%DBS/%/2' OR Barcode LIKE '%UNQ/%') AND Site.site_id={$site_id}";
$result = query_select($sql);
$rek = mysql_fetch_array($result);
return $rek['suma'];
}
function get_name_item($id_c)
{
$sql1 = "SELECT * FROM sub_cat Where kind=2 AND id_c='{$id_c}'";
$result = query_select($sql1);
$rek = mysql_fetch_array($result);
return $rek['Name_sub'];
}
function show_site()
{
connect_db();
$sql_select = "SELECT * FROM Buyer WHERE postcode NOT Like 'Blank' ORDER BY id_Buyer DESC";
$result = query_select($sql_select);
while ($rek = mysql_fetch_array($result)) {
//echo "<table>";
echo "<tr><td>";
echo $rek["postcode"];
echo "</td><td>";
echo $rek["company_name"];
echo "</td><td>";
echo $rek["name"];
// echo "sdfsdf";
echo "</td><td>";
echo $rek["surname"];
echo "</td><td>";
echo $rek["address"];
echo "</td><td>";
echo $rek["town"];
echo "</td><td>";
//$postal_code = strtoupper (str_replace(' ', '', $postal_code));
echo $email = $rek['email'];
echo "</td><td>";
echo $phone = $rek['phone'];
echo "</td><td>";
if (empty($rek['ttl_nr'])) {
echo "-";
} else {
echo $rek['ttl_nr'];
}
echo "</td><td>";
echo "</td></tr>";
}
}
function manifest_dbi_get_item_type_name($id_type_name)
{
$sql = "select * from item_type WHERE iditem_type='{$id_type_name}'";
$result = query_select($sql);
$rek = mysql_fetch_array($result, MYSQL_BOTH);
$item_type_name = $rek['name_item_type'];
return $item_type_name;
}
function get_site_has_cat_weight($site_id, $sub_cat)
{
global $site_date_collection;
$sql = "SELECT * FROM site_has_cat WHERE Site_site_id='{$site_id}'";
$result = query_select($sql);
//$date="SELECT * FROM site WHERE site_id"
while ($rek = mysql_fetch_array($result, MYSQL_BOTH)) {
$sum_weight += $rek['Quantity'] * get_weight($rek['Sub_cat_id_c']);
//this takes quantity stored in site_has_cat and recalculates it it takes new weight through new module of calculation
//including standard weight and non standard
}
return $sum_weight;
}
function check_weee_waste_sold($barcode)
{
connect_db();
//echo "<td>dd</td>";
global $FLAG_SAC;
$sql = "SELECT DISTINCT Barcode_waste,category,weight,site,invoice_waste_idinvoice_waste,buyer_id,date_sold FROM waste_barcode" . " INNER JOIN transaction_waste ON waste_barcode.idwaste_barcode=transaction_waste.waste_barcode_idwaste_barcode" . " WHERE Barcode_waste='{$barcode}' ";
$result = query_select($sql);
//echo $sql;
//echo $result;
echo mysql_num_rows($result);
if (mysql_num_rows($result) == TRUE) {
$FLAG_SAC = 1;
echo "<tr'><td><b>Item disposed for further treatment</b> </td></tr>";
} else {
return 0;
}
while ($rek = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($rek as $row) {
echo '<td>';
echo $row;
echo '</td>';
}
$button_invoice = "<td><a href='invoice_print_waste1.php?ref_sell=" . get_ref_sell($rek['invoice_waste_idinvoice_waste']) . "&show=3' target='_blank'><button>Invoice</button></a><td>";
echo $button_invoice;
echo "<tr><td>To: ";
echo get_buyer_id($rek['buyer_id']);
echo "</td></tr>";
// echo $rek[0];
// echo $rek[1];
// echo $rek[2];
// echo $rek[3];
//echo "Func";
}
}
$get_ATNA = "SELECT * FROM ATNA";
$res_ATNA = query_select2($get_ATNA, $connessione);
$ATNA_host = $res_ATNA[0][1];
$ATNA_port = $res_ATNA[0][2];
$ATNA_active = $res_ATNA[0][3];
echo "<h3>ATNA parameters</h3>";
if ($ATNA_active == "A") {
echo "ATNA: <select name=\"repository_atna_status\">\n <option value=\"A\" selected=\"selected\">ON</option>\n <option value=\"O\">OFF</option>\n </select><br></br>";
} else {
echo "ATNA: <select name=\"repository_atna_status\">\n <option value=\"A\" >ON</option>\n <option value=\"O\" selected=\"selected\">OFF</option>\n </select><br></br>";
}
echo "Repository ATNA Host: <INPUT type=\"text\" name=\"repository_atna_host\" value=\"{$ATNA_host}\" size=\"20\" maxlength=\"30\"><br></br>";
echo "Repository ATNA Port: <INPUT type=\"text\" name=\"repository_atna_port\" value=\"{$ATNA_port}\" size=\"4\" maxlength=\"10\"><br></br>";
#################### REGISTRY ####################
$get_REG = "SELECT HOST,PORT,PATH,HTTP FROM REGISTRY_A WHERE ACTIVE = 'A'";
$res_REG = query_select($get_REG);
$REG_host = $res_REG[0][0];
$REG_port = $res_REG[0][1];
$REG_path = $res_REG[0][2];
$REG_http = $res_REG[0][3];
echo "<h3>Registry parameters</h3>";
echo "Registry Host: <INPUT type=\"text\" name=\"registry_host\" value=\"{$REG_host}\" size=\"20\" maxlength=\"30\"><br></br>";
echo "Registry Port: <INPUT type=\"text\" name=\"registry_port\" value=\"{$REG_port}\" size=\"4\" maxlength=\"10\"><br></br>";
echo "Registry Path: <INPUT type=\"text\" name=\"registry_path\" value=\"{$REG_path}\" size=\"50\" maxlength=\"100\"><br></br>";
if ($REG_http == "NORMAL") {
echo "Registry HTTP: <select name=\"registry_http\">\n <option value=\"NORMAL\" selected=\"selected\">NORMAL</option>\n <option value=\"TLS\">TLS</option>\n </select><br></br>";
} else {
echo "Registry HTTP: <select name=\"registry_http\">\n <option value=\"NORMAL\">NORMAL</option>\n <option value=\"TLS\" selected=\"selected\">TLS</option>\n </select><br></br>";
}
#################### JAVA_PATH ###################
/*
function show_site($user_st)
{
connect_db();
$sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item WHERE stock_in=1 AND user_2='{$user_st}' ORDER BY Barcode.date DESC";
//if(isset($_SESSION['site_id_s'])AND $SESSION['site_id_s']>0)
//{
$site_id_site = $_SESSION['site_id_s'];
$sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item WHERE stock_in=1 AND user_2='{$user_st}' AND Site_site_id='{$site_id_site}' ORDER BY Barcode.date DESC";
//}
$result = query_select($sql_select);
while ($rek = mysql_fetch_array($result)) {
$bar_id_test = $rek['id_Barcode'];
$sql_test = "SELECT * FROM test WHERE Barcode_id_Barcode='{$bar_id_test}'";
$result_test = mysql_query($sql_test);
$rek_test = mysql_fetch_array($result_test);
echo "<tr><td>";
echo $rek["Barcode"];
echo "</td><td>";
echo $rek["stock_in"];
echo "</td><td>";
echo $rek["stock_out"];
//echo "sdfsdf";
echo "</td><td>";
echo $rek["Item_id_item"];
echo "</td><td>";
echo $rek["date"];
echo "</td><td>";
echo $rek["name"];
echo "</td><td>";
echo $rek["brand"];
echo "</td><td>";
echo $rek["pn"];
echo "</td><td>";
echo $rek["user_2"];
echo "#";
echo "</td><td>";
echo $rek["Site_site_id"];
echo "</td><td>";
echo "Stocked-in";
if (mysql_num_rows($result_test) > 0) {
echo "</td><td>";
echo "Tested";
} else {
echo "</td><td>";
$url = "add_barcode.php?test_stock=1&V_BARCODE=";
$url .= swap_hash($rek['Barcode']);
echo "<a href=" . $url . "> Test it </a>";
}
echo "</td></tr>";
}
}
<td align="center">Headline<td>
</tr>
<tr>
<td><input size="80" name="headline"
value="<?php
print $s['headline'];
?>
"></td>
</tr>
<tr>
<td align="center">Page</td>
</tr>
<tr>
<td align="center"><?php
print query_select('page', "select p.code, p.description \n from pages p, writer_permissions wp, stories s\n where p.code = wp.page\n and wp.writer = s.writer\n and s.id =" . $HTTP_GET_VARS['story'], $s['page']);
?>
</td>
</tr>
<tr>
<td align="center">Story text (can contain HTML tags)</td>
</tr>
<tr>
<td><textarea cols="80" rows="7" name="story_text"
wrap="virtual"><?php
print $s['story_text'];
?>
</textarea>
</td>
</tr>
</tr>
</table>
</form>
</fieldset>
<fieldset style="margin-top: 40px;">
<legend>Delete Forum</legend>
<form method="post" action="validation.php">
<table>
<tr>
<td>Forum</td>
<td>
<select name="forum_id" size="1" class="text">
<?php
$query = query_select("forums");
$query .= query_select_order("section_id,position", "ASC");
$forums_list = get_array_from_db($query);
foreach ($forums_list as $item) {
echo "<option value=\"{$item['forum_id']}\"> {$item['forum_name']} </option>";
}
?>
</select>
</td>
</tr>
<tr>
<td colspan="2">
<input type="hidden" name="action" value="delete_forum">
<input type="submit" name="submit" value="Delete" class="button">
</td>
</tr>
require_once "shared/cookies.php";
require_once "shared/functions.php";
require_once "shared/header.php";
require_once "shared/bbcodeParser.php";
?>
<?php
connect_to_database();
select_database();
if (isset($_GET['post']) && $_GET['post'] != "") {
if (get_num_rows("posts", "post_id", $_GET['post']) == 0) {
redirect_to("not_found.php");
} else {
$post_id = $_GET['post'];
$query = query_select("posts");
$query .= query_select_where("post_id", $post_id);
$post = get_array_from_db($query);
$post = $post[0];
}
}
if (!logged_in() || $_SESSION['acess_rank'] == "member" && $post['posted_by'] != $_SESSION['user_id']) {
redirect_to("no_permission.php");
}
?>
<div class="centerBox">
<div class="title">
Edit Post
<hr />
function show_site($id_user)
{
$ref_show = $_SESSION['ref_sell_number'];
connect_db();
// Show SOLD ITEMS by USER in the session
$sql_select = "SELECT * FROM waste_barcode INNER JOIN transaction_waste ON waste_barcode.idwaste_barcode=transaction_waste.waste_barcode_idwaste_barcode WHERE ref_sell_number='{$ref_show}' ";
//show transaction started as zero means a fresh transaction that dad
//if($ref_show==0)
// $sql_select="SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Barcode_has_Buyer ON Barcode.id_Barcode=Barcode_has_Buyer.Barcode_id_Barcode Where stock_out=1 AND Barcode_has_Buyer.user_2='$id_user' AND ref_sell_number='$ref_show' ORDER BY date_sold DESC";
$result = query_select($sql_select) or die(mysql_error());
while ($rek = mysql_fetch_array($result)) {
echo "<tr><td>";
echo $rek["Barcode_waste"];
echo "</td><td>";
echo $rek["stock_in"];
echo "</td><td>";
echo $rek["weight"];
//echo "sdfsdf";
echo "</td><td>";
echo $rek["category"];
echo "</td><td>";
echo $rek["date_sold"];
echo "</td><td>";
echo $rek["type_item"];
echo "</td><td>";
echo $rek["brand"];
echo "</td><td>";
echo $rek["pn"];
echo "</td><td>";
echo $rek["ref_sell_number"];
echo "</td><td>";
echo "</td><td>";
echo $id_weee_ext = $rek["type_item_cnv"];
//we pick up also a weee extension name for waste barcode
$check_weee_extension = "SELECT * FROM weee_extension WHERE idweee_extension={$id_weee_ext}";
$result_weee = mysql_query($check_weee_extension);
$rek_weee = mysql_fetch_array($result_weee);
echo "</td><td>";
echo "</td><td>";
echo $rek_weee["name_ext"];
echo "</td><td>";
echo "Sold";
echo "</td></tr>";
}
}
function deactivate_trace($idtrace, $id_c)
{
echo "ID_TRACE " . $idtrace;
$sql = "UPDATE trace SET active=0 WHERE sub_cat_id_c='{$id_c}' AND idtrace='{$idtrace}' AND active=1";
$result = query_select($sql);
if ($result) {
echo "Deactivated";
} else {
echo "Failed to deatcivate";
}
}
function show_site($user_st)
{
connect_db();
//slight change this is originally for barcode stocked in by whome
//$sql_select="SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Test ON Barcode.id_Barcode=Test.Barcode_id_Barcode WHERE stock_in=1 AND user_2='$user_st' ORDER BY Barcode.date DESC";
//this a new one with test
$sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item INNER JOIN Test ON Barcode.id_Barcode=Test.Barcode_id_Barcode WHERE stock_in=1 AND User_2_id_user='******' ORDER BY Barcode.date DESC";
$result = query_select($sql_select);
while ($rek = mysql_fetch_array($result)) {
//echo "<table>";
/**
* echo "<tr><td>";
* echo $rek["post_code"];
* echo "</td><td>";
* echo $rek["company_name"];
* echo "</td><td>";
* echo $rek["name"];
* //echo "sdfsdf";
* echo "</td><td>";
* echo $rek["surname"];
* echo "</td><td>";
* echo $rek["street"];
*
*
* echo "</td><td>";
* echo $rek["town"];
*
* echo "</td><td>";
*
* //$postal_code = strtoupper (str_replace(' ', '', $postal_code));
*
* echo $email=$rek['email'];
* echo "</td><td>";
*
* echo $phone=$rek['phone'];
* echo "</td></tr>";
*/
echo "<tr><td>";
echo $rek["Barcode"];
echo "</td><td>";
echo $rek["stock_in"];
echo "</td><td>";
echo $rek["stock_out"];
//echo "sdfsdf";
echo "</td><td>";
echo $rek["Item_id_item"];
echo "</td><td>";
echo $rek["date"];
echo "</td><td>";
echo $rek["name"];
echo "</td><td>";
echo $rek["brand"];
echo "</td><td>";
echo $rek["pn"];
echo "</td><td>";
echo $rek["user_2"];
echo "#";
echo "</td><td>";
echo $rek["User_2_id_user"];
echo "#";
echo "</td><td>";
echo $rek["Site_site_id"];
echo "</td><td>";
echo "Tested";
echo "</td></tr>";
}
}
if ($Value[$SQI][0] == "\$XDSDocumentEntryUniqueId") {
$SQLSelectDOCID = "SELECT doc.id FROM ExtrinsicObject doc, ExternalIdentifier uniqId WHERE uniqId.registryobject = doc.id AND uniqId.identificationScheme = 'urn:uuid:2e82c1f6-a085-4c72-9da3-8640a32e42ab' AND uniqId.value = " . trim($Value[$SQI][1]);
$DocUUID_arr = query_select($SQLSelectDOCID);
$DocUUID = $DocUUID_arr[0][0];
}
if (strpos(strtoupper($Value[$SQI][0]), "ASSOCIATIONTYPES")) {
$SQAssociation = $Value[$SQI][1];
$pre_ass = "urn:oasis:names:tc:ebxml-regrep:AssociationType:";
if (strpos($SQAssociation, $pre_ass)) {
$SQAssociation = str_replace($pre_ass, '', $SQAssociation);
}
}
}
// SQL Part1
$SQLStoredQuery[0] = "SELECT DISTINCT a.id FROM Association a, ExtrinsicObject doc WHERE doc.id = '" . trim($DocUUID) . "' AND a.associationType IN " . trim($SQAssociation) . " AND (a.sourceObject = doc.id OR a.targetObject = doc.id)";
$AssUUID_arr = query_select($SQLStoredQuery[0]);
// SQL Part2
$AssUUIDs = "'" . trim($AssUUID_arr[0][0]) . "'";
for ($contaAss = 1; $contaAss < count($AssUUID_arr); $contaAss++) {
$AssUUIDs .= ",'" . trim($AssUUID_arr[$contaAss][0]) . "'";
}
$SQLStoredQuery[1] = "SELECT DISTINCT doc.id FROM ExtrinsicObject doc, Association a WHERE a.id IN (" . $AssUUIDs . ") AND (doc.id = a.sourceObject OR doc.id = a.targetObject)";
break;
}
$contaQuery = count($SQLStoredQuery);
fwrite($fp_Slot_val, $AdhocQuery_case . "\n\r");
for ($SQcount = 0; $SQcount < $contaQuery; $SQcount++) {
fwrite($fp_Slot_val, $SQLStoredQuery[$SQcount] . "\n\r");
}
fclose($fp_Slot_val);
writeTimeFile($idfile . "--StoredQuery: Ho creato le query");
<?php
require_once "shared/admin_settings_nav.php";
?>
<div class="settings_content">
<div class="title">
List of Admins
<hr />
</div>
<table>
<?php
connect_to_database();
select_database();
$query = query_select("users");
$query .= query_select_where("acess_rank", "administrator");
$admins = get_array_from_db($query);
$counter = 1;
foreach ($admins as $admin) {
if ($counter == 1) {
echo "<tr>";
}
echo "<td>";
if ($admin['image_name'] == null) {
$picture = "default.jpg";
} else {
$picture = $admin['image_name'];
}
echo "<a href=\"profile.php?user={$admin['user_id']}\">";
echo "<img src=images/users/{$picture} width=\"160\" height=\"200\">";
function stock_fun()
{
global $date_in;
global $date_out;
$sql_select_site_dis = "SELECT SUM(weight) as wei,item_has_cat.cat as cat_idd, SUM(cat) as quan FROM item_has_cat INNER JOIN Item ON Item.Item_has_cat_id_item_cat=item_has_cat.id_item_cat" . " INNER JOIN barcode ON barcode.Item_id_item=item.id_item WHERE barcode.date BETWEEN '{$date_in}' AND '{$date_out}' GROUP by cat_idd";
$result_site_dis = query_select($sql_select_site_dis);
//TESTED
$sql_select_site_dis_test = "SELECT SUM(weight) as wei,item_has_cat.cat as cat_idd, SUM(cat) as quan FROM item_has_cat " . "INNER JOIN Item ON Item.Item_has_cat_id_item_cat=item_has_cat.id_item_cat INNER JOIN Barcode ON barcode.Item_id_item=item.id_item INNER JOIN Test ON Test.Barcode_id_Barcode=barcode.id_Barcode WHERE barcode.date BETWEEN '{$date_in}' AND '{$date_out}' GROUP by cat_idd";
$result_site_dis_test = query_select($sql_select_site_dis_test);
//shows tested all
echo "<p><b>Tested</b></p>";
echo "<table><tr><td>Total</td><td></td></tr>";
while ($rek_site_dis_test = mysql_fetch_array($result_site_dis_test)) {
echo '<tr><td>';
// echo $rek_site_dis['sum_weight'];
//echo $rek_site_dis['Name_sub'];
echo '</td><td>';
echo round($rek_site_dis_test['wei'], 1);
$total_sum_test += $rek_site_dis_test['wei'];
//echo $rek_site_dis['Site_site_id'];
echo '</td><td>';
echo $rek_site_dis_test['cat_idd'];
echo '</td><td>';
//echo $rek_site_dis['cat_name'];
echo '</td><td>';
//echo $rek_site_dis['quan'];
echo '</td><td>';
echo '</td><td>';
echo '</td><td>';
echo '</td><td>';
echo '</td></tr>';
}
echo "<table>";
//disposed
$sql_select_site_dis_test = "SELECT SUM(weight) as wei,item_has_cat.cat as cat_idd, SUM(cat) as quan FROM item_has_cat " . "INNER JOIN Item ON Item.Item_has_cat_id_item_cat=item_has_cat.id_item_cat INNER JOIN Barcode ON barcode.Item_id_item=item.id_item INNER JOIN Test ON Test.Barcode_id_Barcode=barcode.id_Barcode Where Ready=0 AND barcode.date BETWEEN '{$date_in}' AND '{$date_out}' GROUP by cat_idd";
$result_site_dis_test = query_select($sql_select_site_dis_test);
//shows tested all
echo "<p><b>Disposed - Not passing test</b></p>";
echo "<table width='200px'><tr><td>Total</td><td></td></tr>";
while ($rek_site_dis_test = mysql_fetch_array($result_site_dis_test)) {
echo '<tr><td>';
echo '</td><td>';
echo round($rek_site_dis_test['wei'], 1);
$total_sum_test_disp += $rek_site_dis_test['wei'];
echo '</td><td>';
echo $rek_site_dis_test['cat_idd'];
echo '</td><td>';
echo '</td><td>';
echo '</td><td>';
echo '</td><td>';
echo '</td><td>';
echo '</td><td>';
echo '</td></tr>';
}
echo "<table>";
//disposed
echo '<tr><td colspan="1"></td><td><b>TOTAL WEIGHT Tested:</b> ' . round($total_sum_test, 1) . '<td><td colspan="5">' . $total . '</td></tr></br></table>';
//TESTED
echo '</BR></BR><table border="1"><tr><td></td><td>Totals for category [kgs]</td><td>Category</td></tr>';
while ($rek_site_dis = mysql_fetch_array($result_site_dis)) {
echo '<tr><td>';
// echo $rek_site_dis['sum_weight'];
//echo $rek_site_dis['Name_sub'];
echo '</td><td>';
echo round($rek_site_dis['wei'], 1);
$total_sum += $rek_site_dis['wei'];
//echo $rek_site_dis['Site_site_id'];
echo '</td><td>';
echo $rek_site_dis['cat_idd'];
echo '</td><td>';
echo $rek_site_dis['cat_name'];
//echo '</td><td>';
//echo $rek_site_dis['quan'];
echo '</td></tr>';
}
global $sda;
echo '<tr><td colspan="1"></td><td><b>TOTAL WEIGHT STOCKED:</b> ' . round($total_sum, 1) . '<td><td colspan="5">' . $total . '</td></tr>';
echo '<tr><td colspan="1"></td><td><b>SDA WASTE:</b> ' . ($sda = $sda - $total_sum . '<td></tr>');
//echo '<tr><td colspan="1"></td><td><b>By this year:</b> '.$total_sum.'<td></tr>';
echo '</table>';
}
}
}
}
##### STATUS
$repository_status = $res_config[0][6];
#### MESSAGGI
$service = "repository.php";
$logentry = "\"http://{$rep_host}:{$rep_port}" . "{$www_REP_path}\"";
### PER LA CHIAMATA AL JAR FILE
$path_to_VALIDATION_jar = "./XSD_VALIDATION_JAR/";
$path_to_XSD_file = "./schemas/rs.xsd";
//------------------- LOCAL FILE SYSTEM PATHS ---------------------//
//------------------- TO REGISTRY CONNECTION INFOS -------------------//
#### LEGGO LE INFORMAZIONI DA DB: NODO ATTIVO
$select_registry = "SELECT HOST,PORT,PATH,HTTP FROM REGISTRY_A WHERE ACTIVE = 'A' AND SERVICE = 'SUBMISSION'";
$ris = query_select($select_registry);
#### OTTENGO LE INFORMAZIONI DEL NODO REGISTRY
$reg_host = $ris[0][0];
$reg_port = $ris[0][1];
$reg_path = $ris[0][2];
$reg_http = $ris[0][3];
###### A CHI SPEDIRE I MESSAGGI ATNA
$get_ATNA_node = "SELECT * FROM ATNA";
$res_ATNA = query_select2($get_ATNA_node, $connessione);
$ATNA_host = $res_ATNA[0][1];
$ATNA_port = $res_ATNA[0][2];
$ATNA_active = $res_ATNA[0][3];
##### LOGS ATNA
$atna_path = "./atna_logs/";
$namespacerim_path = "urn:oasis:names:tc:ebxml-regrep:rim:xsd:2.1";
//-------------------------- TO REGISTRY CONNECTION INFOS --------------------------//
}
echo "> {$item['forum_name']} </option>";
}
?>
</select>
</td>
</tr>
</form>
<form method="post" action="validation.php">
<tr>
<td>Change Section</td>
<td>
<select name="new_section" class="text">
<?php
$query = query_select("sections");
$query .= query_select_order("position", "ASC");
$sections = get_array_from_db($query);
foreach ($sections as $section) {
echo "<option value=\"{$section['section_id']}\" ";
if ($section['section_id'] == $forum['section_id']) {
echo "selected";
}
echo "> {$section['section_name']} </option>";
}
?>
</select>
</td>
<td>
<input type="hidden" name="action" value="update_forum_section">
<input type="hidden" name="forum_id" value="<?php
function check_dismantle($type_strip)
{
//here we divide the string for dismantle table norm that is only first input phrase
//$type=array();
//$type_strip=get_word($type_strip);
//insted we use explode
//incopatible verion of php notice
$type_strip = explode(" ", $type_strip)[0];
//$type_strip;
//echo "</BR>DEBUG: [TYPE_STRIP,F[check_dismantle]] - ".$type_strip;
//here we connect and check which kind of dismantling is used LAPTOP STRIP TV STRIP
connect_db();
$sql = "SELECT * FROM dismantled WHERE type_dismantle='{$type_strip}'";
$result = query_select($sql);
$rek = mysql_fetch_array($result);
//echo "</BR>DEBUG: [DISMANTLE_ID] - ".$rek[0];
if ($rek) {
return $rek[0];
} else {
return 0;
}
//
}
?>
"></td>
</tr>
<tr>
<td>Page</td>
</tr>
<tr>
<td>
<?php
if (isset($_REQUEST['story'])) {
$query = "select p.code, p.description \n from pages p, writer_permissions wp, stories s\n where p.code = wp.page\n and wp.writer = s.writer\n and s.id =" . $_REQUEST['story'];
} else {
$query = "select p.code, p.description \n from pages p, writer_permissions wp\n where p.code = wp.page\n and wp.writer = '{$_SESSION['auth_user']}'";
}
echo query_select('page', $query, $story['page']);
?>
</td>
</tr>
<tr>
<td>Story text (can contain HTML tags)</td>
</tr>
<tr>
<td><textarea cols="80" rows="7" name="story_text"
wrap="virtual"><?php
echo $story['story_text'];
?>
</textarea>
</td>
</tr>
function import_manifest($manifest_reg, $manifest_counter_result, $site_result, $site_has_cat_result, $delivery_result)
{
global $GME;
echo "In import manifest";
connect_tablet();
//here we for the last time ask tavblet before connectin to root
//check manifest unq number
$GME .= new_line(" In import manifest ");
//
//extract manifest reg
$id_manifest = $manifest_reg[0];
$manifest_unq_num = $manifest_reg[1];
$manifest_date = $manifest_reg[2];
$manifest_driver = $manifest_reg[3];
$manifest_closed = $manifest_reg[4];
//write a standard origin conversion function that
//$manifest_siteid=$manifest_reg[5]; //converst tablet origin into dbs3 origin using post code as constanse
$manifest_start_dbs = $manifest_reg[6];
//do it each time
$manifest_end_dbs = $manifest_reg[7];
//site for site conversion
//asssuming only one site
$GME .= new_line(" Manifest array " . $manifest_reg[0] . " - " . $manifest_reg[1] . " - " . $manifest_reg[2] . " - " . $manifest_reg[3] . " - " . $manifest_reg[4] . " - " . $manifest_reg[5]);
$site = mysql_fetch_array($site_result);
$site_id = $site[0];
$site_origin_origin_id = $site[1];
//here a problem cince it may be with root system origin converted. Means that origins must be converted from tablet to root
$site_ref_number = $site[2];
$site_rep_auth = $site[3];
$site_dest_location = $site[4];
$site_batch_date = $site[5];
$site_batch_id = $site[6];
$site_closed = $site[7];
###
//get post code from tablet
$tablet_tmp_post_code = get_post_code($site_origin_origin_id);
//get origin from tablet
//checktabletpostcode
echo "NEW CONV Ori:" . ($new_converted_origin = root_system_origin_from_post($tablet_tmp_post_code));
$GME .= new_line("NEW Conv ori:" . $new_converted_origin);
$tablet_tmp_post_code = $new_converted_origin;
/*
$site_origin_tab=mysql_fetch_array($site_result);
//get post code from tablet
$tablet_tmp_post_code=get_post_code($site_origin_tab[1]); //get origin from tablet
//checktabletpostcode
echo "NEW CONV Ori:".$new_converted_origin= root_system_origin_post_code($tablet_tmp_post_code);
*/
//root_system_origin($origin_id); //check pos code root return origin id
//Manifest reg id is taken from manifest, than is inserted into root system with conversion
//we gona insert this to root system as AI. But we chcack manifest unq number
//extract site -stage 2
/*
$site_id=$site[0];
$site_origin_origin_id=$site[1];
$site_ref_number=$site[2];
$site_rep_auth=$site[3];
$site_dest_location=$site[4];
$site_batch_date=$site[5];
$site_batch_id=$site[6];
$site_closed=$site[7];
*/
//variables for module conversion
$stack_trace_manifest_reg_id;
$stack_trace_manifest_reg_unq_number;
$stack_trace_fresh_site_id;
connect_dbs3();
//here we connect to main root system
//check root system
$sql = "SELECT * FROM manifest_reg WHERE manifest_unq_num='{$manifest_unq_num}'";
$result = query_select($sql);
if ($num = mysql_num_rows($result) > 0) {
return "manifest already exist in the system";
}
/*
//Checking if origins id is adjusted to coonversion module
$conversion_post_code=get_post_code($site_origin_origin_id=$site[1]); //take tablet origin_id and compare to local
echo $sql="SELECT origin_id FROM origin WHERE post_code='$conversion_post_code'";
$result=query_select($sql) or die(mysql_error());
$rek=mysql_fetch_array($result);
$origin_in_root=$rek[0];
echo "NEW conversion id".$origin_in_root;
*/
connect_dbs3();
mysql_query("START TRANSACTION");
$flag = true;
//here we insert as it goes manifest reg, but we need to keeptrace of it to update
$manifest_siteid = 0;
//we use blank one
echo $query_manifest = "INSERT INTO manifest_reg(manifest_unq_num,date_manifest,driver_num,hash_serial,group1,closed,siteid,start_dbs,end_dbs) " . "VALUES ('{$manifest_unq_num}','{$manifest_date}','{$manifest_driver}','0','0','{$manifest_closed}','{$manifest_siteid}','{$manifest_start_dbs}','{$manifest_end_dbs}')";
$result = mysql_query($query_manifest) or trigger_error(mysql_error(), E_USER_ERROR);
if (!$result) {
$flag = false;
} else {
echo "Result manifest register done";
$GME .= new_line("Result manifest register done");
//if inserted correctly we take last insert id
$stack_trace_manifest_reg_id = mysql_insert_id();
$stack_trace_manifest_reg_unq_number = $manifest_unq_num;
}
//manifest counter extract
while ($manifest_counter = mysql_fetch_array($manifest_counter_result)) {
echo "executing mysql counter";
//here we will be unsing manifest stack trace for manifest_reg
echo $manifest_counter_id = $manifest_counter[0];
echo $manifest_counter_manifest_counter = $manifest_counter[1];
$manifest_counter_sub_cat = $manifest_counter[2];
$manifest_counter_manifest_sub_cat = $manifest_counter[3];
echo "reg:" . ($manifest_counter_manifest_reg_idmanifest_reg = $stack_trace_manifest_reg_id);
//$manifest_counter[4]; deprecated
$manifest_counter_finished = $manifest_counter[5];
echo $query_manifest_counter = "INSERT INTO manifest_counter(manifest_counter,sub_cat,manifest_sub_cat,manifest_reg_idmanifest_reg,finished) " . "VALUES ('{$manifest_counter_manifest_counter}','{$manifest_counter_sub_cat}','{$manifest_counter_manifest_sub_cat}','{$manifest_counter_manifest_reg_idmanifest_reg}','{$manifest_counter_finished}')";
$result = mysql_query($query_manifest_counter) or trigger_error(mysql_error(), E_USER_ERROR);
if (!$result) {
$flag = false;
} else {
echo "Result insert counter done";
//here we need a fresh site id not the old one from system. Its generated on level of adding site id
}
}
echo "Done manifest counters successfult";
//IF FIRST STAGE DONE GO THROUGH SECOND ONE
//SITE
//asssuming only one site
/*
$site=mysql_fetch_array($site_result);
$site_id=$site[0];
$site_origin_origin_id=$site[1]; //here a problem cince it may be with root system origin converted. Means that origins must be converted from tablet to root
$site_ref_number=$site[2];
$site_rep_auth=$site[3];
$site_dest_location=$site[4];
$site_batch_date=$site[5];
$site_batch_id=$site[6];
$site_closed=$site[7];
*/
$site_origin_origin_id = $tablet_tmp_post_code;
//add one site
echo $query_site = "INSERT INTO site(Origin_origin_id,site_ref_number,Rep_Auth,Dest_location,batch_date,batch_id,closed) " . "VALUES ('{$site_origin_origin_id}','{$site_ref_number}','{$site_rep_auth}','{$site_dest_location}','{$site_batch_date}','{$site_batch_id}','{$site_closed}')";
$result = mysql_query($query_site) or trigger_error(mysql_error(), E_USER_ERROR);
if (!$result) {
$flag = false;
} else {
echo "Done site";
echo $stack_trace_fresh_site_id = mysql_insert_id();
}
//SITE HAS CATEGORY INSERT
while ($site_has_cat = mysql_fetch_array($site_has_cat_result)) {
$i++;
$site_has_cat_id = $site_has_cat[0];
//$site_has_cat_site_site_id=$site_has_cat[1];
$site_has_cat_sub_cat_id = $site_has_cat[1];
$site_has_cat_quantity = $site_has_cat[3];
$site_has_cat_sum_weight = $site_has_cat[4];
$site_has_cat_site_site_id = $stack_trace_fresh_site_id;
//$site_has_cat_sum_weight=0;
//only adds few
echo "</BR>" . $i;
echo $query_site_has_cat = "INSERT INTO site_has_cat(Sub_cat_id_c,Site_site_id,Quantity,sum_weight) " . "VALUES ('{$site_has_cat_sub_cat_id}','{$site_has_cat_site_site_id}','{$site_has_cat_quantity}','{$site_has_cat_sum_weight}')";
$result = mysql_query($query_site_has_cat) or trigger_error(mysql_error(), E_USER_ERROR);
if (!$result) {
$flag = false;
} else {
echo "result site_has_cat Done";
}
}
//deliveries
while ($delivery = mysql_fetch_array($delivery_result)) {
$delivery_delivery_id = $delivery[0];
$delivery_trans_category = $delivery[1];
//$delivery_site_site_id=$delivery[2];
$delivery_date = $delivery[3];
$delivery_qtty_picked_up = $delivery[4];
$delivery_picker1 = $delivery[5];
$delivery_trans_ref_number = $delivery[6];
$delivery_closed = $delivery[7];
$delivery_qnum = $delivery[8];
$delivery_att_num = $delivery[9];
$delivery_site_site_id = $stack_trace_fresh_site_id;
echo $query_delivery = "INSERT INTO delivery(Trans_Category_Category_id,Site_site_id,date,QtyPickedUp,picker1,trans_ref_num,closed,QNum,att_num)" . "VALUES ('{$delivery_trans_category}','{$delivery_site_site_id}','{$delivery_date}','{$delivery_qtty_picked_up}','{$delivery_picker1}','{$delivery_trans_ref_number}'," . "'{$delivery_closed}','{$delivery_qnum}','{$delivery_att_num}')";
$result = mysql_query($query_delivery) or trigger_error(mysql_error(), E_USER_ERROR);
if (!$result) {
$flag = false;
} else {
echo "result succesfully done deliveries";
}
}
//here we update site id in both manifest_reg and manifest_counter
$update_manifest_reg = "UPDATE manifest_reg SET siteid='{$stack_trace_fresh_site_id}' WHERE idmanifest_reg='{$stack_trace_manifest_reg_id}'";
$result = query_select($update_manifest_reg);
if (!$result) {
$flag = false;
} else {
echo "result succesfully updated manifest reg siteid";
}
if ($flag) {
echo "Cimmited";
mysql_query("COMMIT");
} else {
echo "Rolled backed";
mysql_query("ROLLBACK");
}
//update manifest on table for cloas 1
if ($flag) {
connect_tablet();
//the last one is to reove from tablet. make it unvisible
$update_closed = "UPDATE manifest_reg SET closed=1 WHERE idmanifest_reg='{$id_manifest}'";
$rek = mysql_query($update_closed) or die(mysql_error());
}
}
// Here in this modul, that doesnt give ignition. Baybe the case sesion set and vaiables
echo "else if";
$ref = rand();
$ref_sell_number = $site_location . $batch_date . $ref;
//new number generated, initialisation of empty invoice and omitting adding a new sell ignition rather in session
// $insert="INSERT INTO Barcode_has_Buyer(Buyer_id_Buyer,Barcode_id_Barcode,date_sold,user_2,ref_sell_number) VALUES('$site_location','NULL','$batch_date','$id_user','$ref_sell_number')";
$site_specified = 1;
// $result = mysql_query($insert)
// or die(mysql_error());
$_SESSION['ref_sell_number'] = $ref_sell_number;
//this unique store in session
//invoice generation
$query_inv = "INSERT INTO Invoice_waste(main_pri,net_pri,vat_pri) VALUES(0,0,0)";
//This here must be switched to 2 separate gueries to get pre sesion values or take from posted
echo $batch_date . $site_location;
$result = query_select($query_inv);
echo "£AFTER QUERY";
$_SESSION['inv_id_generated'] = mysql_insert_id();
//end of invoice gen
$url = 'sell_item_waste1.php?' . 'site_specified=' . $site_specified . '&' . 'batch_date=' . $batch_date . '&' . 'site_location=' . $site_location . '&' . 'site_id=' . $na . '&' . 'ref_sell_new=' . $ref_sell_number;
$_SESSION['site_id_s_s'] = $site_location;
redirect($url, $TEST_T);
exit;
}
}
} else {
$_SESSION['site_id_s_s'];
echo "sama sesja";
}
//Here we assume we add qtty with empty barcode scenario
//
echo "submit" . $name_change;
if (!empty($_POST['atts'])) {
echo "SUB ";
echo $id_c = $_POST['sub_cat'];
echo $atts = $_POST['atts'];
//here we insert
$sql = "UPDATE sub_cat SET atts='{$atts}' WHERE id_c='{$id_c}'";
query_select($sql);
}
}
if (isset($_POST['item_types'])) {
echo "Item types ";
echo $id_c = $_POST['sub_cat'];
echo $itemtypes = $_POST['item_types'];
$sql = "UPDATE sub_cat SET item_type='{$itemtypes}' WHERE id_c='{$id_c}'";
query_select($sql);
}
// echo $name_change."</BR>";
}
//fixing bug if form set once. Seems to solve problem. Item only doesnt apper on the bottom
if (isset($_POST['Submit'])) {
redirect("categories_add.php", 0);
}
function redirect($gdzie, $czas)
{
echo "<head><meta http-equiv=\"Refresh\" content=\"{$czas}; URL={$gdzie}\" /></head>";
}
function dup_row($count)
{
if ($count = "0") {
return 0;
<?php
if ($_GET['invoice'] == 1) {
//echo "showsite";
$batch_date = $_GET["batch_date"];
$site_location = $_GET["site_specified"];
if ($_GET['ref_sell'] > 0 or isset($_GET['ref_sell'])) {
$r = 1;
//echo "Referance Transaction Number";
$ref_sell = $_GET['ref_sell'];
//echo 'asassdfsfdsfdsdfsdfsdfsdfsdfsdfsdfsfd';
// echo $ref_sell;
connect_db();
//$query="SELECT * From Origin INNER JOIN Site ON Origin.origin_id=Site.Origin_origin_id WHERE batch_date='$batch_date' AND Origin_origin_id='$site_location'";
$query = "SELECT * From Buyer, transaction_waste Where Buyer.id_Buyer=transaction_waste.buyer_id AND transaction_waste.ref_sell_number ='{$ref_sell}'";
echo $batch_date . $site_location;
$result = query_select($query) or die(mysql_error());
//$users=array();
//$names=array();
//$batch_date=array();
$i = 0;
/*
while($rek = mysql_fetch_array($result,1))
{
$i++;
$users[$i]=$rek["post_code"];
$names[$i]=$rek["town"];
$batch_date[$i]=$rek["batch_date"];
// echo $users[$i].$names[$i];
}
*/
if ($rek = mysql_fetch_array($result, 1)) {
session_start();
include 'header.php';
include 'header_mysql.php';
include 'menu_header.php';
$l_klient = $_SESSION['l_klient'];
//echo $l_klient;
$id_user = $_SESSION['id_user'];
$serwer = "localhost";
$login = "******";
$haslo = "krasnal";
$baza = "dbs3";
$tabela = "Sub_cat";
$site_id;
connect_db();
$query = "SELECT * From User_2";
$result = query_select($query);
$users = array();
$names = array();
$i = 0;
while ($rek = mysql_fetch_array($result, 1)) {
$i++;
$users[$i] = $rek["id_user"];
$names[$i] = $rek["name"];
// echo $users[$i].$names[$i];
}
//<input type="text "id="" name="user" value="" />
?>
<HTML>
<HEAD>
##### ASSOCIATION
if ($objectType_from_Association == "Association") {
writeSQLQueryService("Association");
//Devo risettare $objectType_from_Association a "" altrimenti rimane associata alla variabile Association
$objectType_from_Association = "";
$Association_id = $SQLResponse[$rr][0];
$dom_ebXML_Association = domxml_new_doc("1.0");
## ROOT
$dom_ebXML_Association_root = $dom_ebXML_Association->create_element("Association");
$dom_ebXML_Association_root = $dom_ebXML_Association->append_child($dom_ebXML_Association_root);
#### SETTO I NAMESPACES
$dom_ebXML_Association_root->set_namespace($ns_rim3_path, $ns_rim3);
$dom_ebXML_Association_root->add_namespace($ns_q3_path, $ns_q3);
####OTTENGO DAL DB GLI ATTRIBUTI DI Association
$queryForAssociationAttributes = "SELECT associationType,objectType,sourceObject,targetObject FROM Association WHERE Association.id = '{$Association_id}'";
$AssociationAttributes = query_select($queryForAssociationAttributes);
writeSQLQueryService($queryForAssociationAttributes);
$Association_associationType = $AssociationAttributes[0][0];
$Association_objectType = $AssociationAttributes[0][1];
$Association_sourceObject = $AssociationAttributes[0][2];
$Association_targetObject = $AssociationAttributes[0][3];
$dom_ebXML_Association_root->set_attribute("id", $Association_id);
$dom_ebXML_Association_root->set_attribute("associationType", $namespace_associationType . $Association_associationType);
$dom_ebXML_Association_root->set_attribute("objectType", $namespace_objectType . $Association_objectType);
$dom_ebXML_Association_root->set_attribute("sourceObject", $Association_sourceObject);
$dom_ebXML_Association_root->set_attribute("targetObject", $Association_targetObject);
#### PREPARO PER OBJECTREF
$Association_sourceObject_ARR_1[$Association_sourceObject] = $Association_sourceObject;
$Association_sourceObject_ARR_2[] = $Association_sourceObject;
$Association_targetObject_ARR_1[$Association_targetObject] = $Association_targetObject;
$Association_targetObject_ARR_2[] = $Association_targetObject;
