コード例 #1
0
ファイル: third_lvl_api.php プロジェクト: bruce28/vip
function get_weee_categories()
{
    connect_dbi();
    $weee_cat = array();
    $weee_cat_name = array();
    $blank = array();
    $sql = "SELECT * FROM category";
    $result = query_selecti($sql);
    //count how many categories are there. Mind some may be non active or visible. BYt bu unique it we calculate all
    $num_categories_availible = mysqli_num_rows($result);
    //echo $num_categories_availible;
    $i = 0;
    while ($rek = mysqli_fetch_array($result, MYSQLI_BOTH)) {
        $i++;
        //var_dump($rek);
        //echo $rek['id']; // GET CATEGORY UNIQU AI NUMBER
        $weee_cat_name[$i] = $rek['name_cat'];
        $weee_cat[$i] = $rek['id'];
        $blank[$i] = 0;
        //echo $weee_cat[$i];
    }
    //here we initialise an array
    /*
    for($i=0;$i=$num_categories_availible;$i++)
    {
        $weee_cat
    }
    */
    return array($weee_cat, $weee_cat_name, $blank);
    //zero to zero for calculation assignment. cant properly define cat indexes be default 0
}
コード例 #2
0
ファイル: site_new.php プロジェクト: bruce28/vip
function show_site()
{
    $db = connect_dbi();
    $sql_select = "SELECT * FROM Origin" . " INNER JOIN Source ON source.source_id=Origin.Source_source_id" . " ORDER BY origin_id DESC";
    $result = query_selecti($db, $sql_select);
    while ($rek = mysqli_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 $rek["Source_source_id"];
        echo "</td><td>";
        echo $rek["town_name"];
        echo "</td><td>";
        echo $email = $rek['email'];
        echo "</td><td>";
        echo $phone = $rek['phone'];
        echo "</td></tr>";
    }
    mysqli_free_result($result);
    mysqli_close($db);
}
コード例 #3
0
ファイル: add_stock.php プロジェクト: bruce28/vip
function check_cat($id)
{
    $db = connect_dbi();
    $sql = "SELECT * FROM category";
    $result = query_selecti($db, $sql);
    while ($rek = mysqli_fetch_array($result)) {
        echo "<option value='" . $rek['id'] . "'>" . $rek['name_cat'] . "</option>";
    }
    //  return $rek['town_name'];
}
コード例 #4
0
ファイル: sell_item_waste.php プロジェクト: bruce28/vip
function check_cat($id)
{
    $db = connect_dbi();
    $sql = "SELECT * FROM item_has_cat INNER JOIN item ON item.Item_has_cat_id_item_cat=item_has_cat.id_item_cat WHERE active=1 GROUP BY assign_nr ORDER By id_item_cat";
    $result = query_selecti($db, $sql);
    // echo $id;
    while ($rek = mysqli_fetch_array($result)) {
        $sub_cat = $rek['sub_cat'];
        if ($id == $rek['id_item_cat']) {
            echo "<option value='" . $rek['id_item_cat'] . "' selected >" . $rek['name'] . " - <b>" . get_sub_cat_name($sub_cat) . "</b></option>";
        } else {
            echo "<option value='" . $rek['id_item_cat'] . "'>" . $rek['name'] . " - <b>" . get_sub_cat_name($rek['sub_cat']) . "</b></option>";
        }
    }
    //  return $rek['town_name'];
}
コード例 #5
0
ファイル: add_process_stock.php プロジェクト: bruce28/vip
    $fp = fopen("{$DOCUMENT_ROOT}/../user.txt", LOCK_EX);
    if (!$fp) {
        echo "Could not open log file";
    }
    fwrite($fp, $tofile, strlen($tofile));
    flock($fp, LOCK_UN);
    fclose($fp);
}
function redirect($gdzie, $czas)
{
    echo "<head><meta http-equiv=\"Refresh\" content=\"{$czas}; URL={$gdzie}\" /></head>";
}
//This function checks if log button was sumbited
if (isset($_POST['log'])) {
    //connect Database by mysqli interface
    $db = connect_dbi();
    //return a row when admin login in User_2 table
    $sql_select_admin = mysqli_query($db, 'SELECT * FROM User_2 WHERE login = "******"');
    $result_select_admin = mysqli_fetch_array($sql_select_admin) or die(mysql_error());
    if ($sql_select_admin) {
        if (isset($_POST['password'])) {
            if ($_POST['password'] == $result_select_admin['pass']) {
                $name_p = $_POST['name_p'];
                //initialize name_p variable
                $WEIGHT_PASS = 1;
            } else {
                echo 'Wrong Data!';
                // $WR=1;  // These 4 variables send back to add stock if login is wrong
                $barcode = $bb = $_POST['barcode_p'];
                $item = $ii = $_POST['name_p'];
                $brand = $ib = $_POST['brand_p'];
コード例 #6
0
ファイル: atts_finish.php プロジェクト: bruce28/vip
<?php

session_start();
#include 'second_lvl_api.php';//include all needed functions
#include 'first_lvl_api.php';
#include 'session_device.php';
//include 'header_mysql_tablet.php';
include 'third_lvl_api.php';
require 'first_lvl_api.php';
//for manifest sticker manipulation
error_reporting(E_ALL);
ini_set('display_errors', 'off');
//reset_tokens_on_sub_cat();
connect_dbi();
$legged = 0;
if ($_SESSION['logged'] == 1) {
    $logged = $_SESSION['logged'];
    $user = $_SESSION['l_klient'];
}
?>


<html>
    <head>
        <title>GRR Collection System</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1,maximum-scale=1">
        <link rel="stylesheet" href="jquery.mobile/jquery.mobile-1.4.4.min.css"/>
        <script src="jquery-2.1.1.js"></script>
        <script src="jquery.mobile/jquery.mobile-1.4.4.min.js"></script>
    </head>
コード例 #7
0
ファイル: sell_item_waste1.php プロジェクト: bruce28/vip
function check_cat_ext($id)
{
    $db = connect_dbi();
    $sql = "SELECT * FROM weee_extension";
    $result = query_selecti($db, $sql);
    // echo $id;
    while ($rek = mysqli_fetch_array($result)) {
        //$sub_cat=$rek['sub_cat'];
        if ($id == $rek['idweee_extension']) {
            echo "<option value='" . $rek['idweee_extension'] . "' selected >" . $rek['name_ext'] . " - <b>" . $rek['weee_extension'] . "</b></option>";
        } else {
            echo "<option value='" . $rek['idweee_extension'] . "'>" . $rek['name_ext'] . " - <b>" . $rek['weee_extension'] . "</b></option>";
        }
    }
    //  return $rek['town_name'];
}
コード例 #8
0
ファイル: second_lvl_api.php プロジェクト: bruce28/vip
function reset_tokens_on_sub_cat()
{
    connect_dbi();
    $update = "UPDATE `sub_cat` SET `token_dynamic_idtoken`=1";
    query_selecti($update);
}