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;