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; }
<td align="center"><?php echo $vo["goodid"]; ?> </td> <td><A href="<?php echo U('Home/Article/detail?id=' . $vo['goodid']); ?> " > <img src="<?php echo get_cover(get_cover_id($vo["goodid"]), 'path'); ?> " width="40" height="40"/><?php echo get_good_name($vo["goodid"]); ?> </A></td> <td align="center"> <span class="weight"><?php echo get_weight($vo["goodid"]); ?> </span>g</td> <td align="center"><?php echo get_good_price($vo["goodid"]); ?> </td> <td align="center"><?php echo $vo["num"]; ?> </td> </tr><?php } } } else {
}while($insert_count<=$manifest_size); */ while ($rek_mobile_subcat = mysql_fetch_array($result_mobile_subcat)) { echo $rek_mobile_subcat['id']; $sub_cat_id_c = $rek_mobile_subcat['Sub_cat_id_c']; $site_site_id_c = $rek_mobile_subcat['Site_site_id']; $quantity = $rek_mobile_subcat['Quantity']; $sum_weight = $rek_mobile_subcat['sum_weight']; $rek_mobile_subcat['id_c']; echo $categoryid = $rek_mobile_subcat['Category_id']; echo $weightid = $rek_mobile_subcat['Weight_id']; $name_sub = $rek_mobile_subcat['Name_sub']; $kind = $rek_mobile_subcat['kind']; $weight = array(); $weight = get_weight($weightid); if (!empty($weight)) { echo "<BR/>Weights taken from Mobile System"; } //echo $weight['id']; //echo $weight['weight']; $category = array(); $category = get_category($categoryid); if (!empty($category)) { echo "<BR/>Category taken from Mobile System"; } if (!empty($category) and !empty($weight)) { mysql_connect($host_in, 'root', 'krasnal'); mysql_select_db($dbs3_in); echo "<BR />Category transfer. Sub_cat"; echo "Problem with conversion module. Assigned to sub cat";
// vyberaem chto zharitq. a zharitq mozhno lishq syroe i rybu. dazhe nevazhno chto, prosto berem vse chto nachinaetsha raw ili fish s inventarja, i raw zamenjaem na fry, a fish na fry_fish: include_once 'modules/f_list_inventory.php'; $f .= '<b>выберите что приготовить:</b><br/>'; $f .= list_inventory($LOGIN, 'i.f.foo.raw_', 'use_stand&item=' . $item . '&part=2&sa=fry'); $f .= list_inventory($LOGIN, 'i.f.foo.fish_', 'use_stand&item=' . $item . '&part=2&sa=fry'); $f .= '«<a class="blue" href="game.php?sid=' . $sid . '&action=use_stand&item=' . $item . '">назад</a>'; exit_msg('кострище', $f); } else { $to = mysql_real_escape_string(strip_tags($_GET['to'])); if (substr($to, 0, 12) != 'i.f.foo.raw_' && substr($to, 0, 12) != 'i.f.foo.fish') { put_g_error('Жарить можно сырую рыбу и мясо. ты та что суешь?'); } // v ostalqnyh sluchajah zharim // berem ves veshi - include_once 'modules/f_get_weight.php'; $wgh = get_weight($to); // udaljaem syrqe include_once 'modules/f_delete_item.php'; delete_item($to); // smotrim che eto takoe bylo - include_once 'modules/f_real_name.php'; $to = real_name($to); // dalee, berem shans prigotovitq // on raven 100 - ves * 10 + navyk * 10. // esli ves > 30, on raven navyku prigotovlenija // esli navyk 0, shans 0 $chanse = 0; if ($wgh < 30) { $chanse = 100 - $wgh * 10 + $p['skills'][37] * 10; } else { $chanse = $p['skills'][37];
function detect_atts($atts_mixed, $categories_num) { $table_category_wth_atts = array(); echo "Deteckting atts"; $att_flag = array(); $att_flag_name_att = array(); $keep_weights_for_atts = array(); $siz_cat = sizeof($categories_num); //result of weee weights calculated if zero ignore att if set show att //extract tuple atts-mixed $att_name = $atts_mixed[0]; $att_cat = $atts_mixed[1]; // var_dump($categories_num); for ($i = 0; $i < $siz_cat; $i++) { //if($att_cat[$i]==0) // echo "</BR>"; // echo $att_cat[$i]; // echo '</BR>'; // $att_name[$i]; if ($categories_num[$i] > 0) { // echo $i." not empty: ".$categories_num[$i]; //if weee_category weight is not empty //search atts ident to find proper attscat for ($a = 0; $a <= sizeof($att_cat); $a++) { // echo $att_cat[$a]; // $categories_num[$i];// here should be category id obteined from reall one, but lack of time //so depending on the set of $i // echo $a+1; //this are the atts numbers if ($i == 3) { //future field for atts assigned to particular item type $sql_conotation = "SELECT id_c FROM sub_cat WHERE conotation='mobile_att'"; $result = query_selecti($sql_conotation); $rek = mysqli_fetch_array($result); if ($keep_weights_for_atts[3] = get_weight($rek[0])) { if (!empty($keep_weights_for_atts[3])) { $att_flag[3] = 1; $att_flag_name_att[3] = "Mobile"; } } else { } } else { if ($att_cat[$a] == $i) { if ($i == 1) { //omit if finds lda/ check calculations } else { // echo "found att: ".$att_cat[$a]; // echo " for ".$i; $att_flag[$i] = 1; $att_flag_name_att[$i] = $att_name[$a]; $keep_weights_for_atts[$i] = $categories_num[$i]; } //from 0 search in table not in db :) } else { if ($att_cat[$a] == "1-10") { // echo "found special att 1-10 only one for".$i; //here take calculated weee_categories and check //if any weight set $keep_weight = 0; for ($d = 0; $d <= 10; $d++) { if ($categories_num[$d] > 0) { $keep_weight += $categories_num[$d]; } if ($keep_weight > 0) { if ($keep_weights_for_atts[3]) { //that means if set moboile weight than subside $keep_weights_for_atts[9] = $keep_weight - $keep_weights_for_atts[3]; } else { $keep_weights_for_atts[9] = $keep_weight; } $att_flag[9] = 1; $att_flag_name_att[9] = "Weee"; } } } } } } } } // end of for return array($att_flag, $att_flag_name_att, $keep_weights_for_atts); // att flag were is active and also alongside the name of att for placeholder }
<td align="center"><?php echo $info["goodid"]; ?> </td> <td><A href="<?php echo U('Home:Article/detail?id=' . $vo['goodid']); ?> " > <img src="<?php echo get_cover(get_cover_id($info["goodid"]), 'path'); ?> " width="40" height="40"/><?php echo get_good_name($info["goodid"]); ?> </A></td> <td align="center"> <span class="weight"><?php echo get_weight($info["goodid"]); ?> </span>g</td> <td align="center"><?php echo get_good_price($info["goodid"]); ?> </td> <td align="center"><?php echo $info["num"]; ?> </td> </tr> </tbody></table> <BR/> <div style="color:red"> <p style="text-align:right;color:red;width:100%">小计:<?php
<link rel="stylesheet" href="form_cat.css " type="text/css"> <style> td { text-align:center;} </style> </HEAD> <BODY> <?php //connect_db(); echo "<table><th>weight n-1</th><th>weight n<th></th><tr><td>"; echo get_standard_weight($id_c); echo "</td><td>"; echo get_weight($id_c); echo "</td><td>"; if (check_trace($id_c) == 0) { } echo "</td></tr></table>"; ?> </BR></BR> <?php $date_started = date("Y-m-d"); echo "<form action='sub_cat_revise.php' method='POST'>"; echo "<input type='text' name='date_started' value='" . $date_started . "' placeholder='date_started'></BR>"; echo "<input type='text' name='weight' value='' placeholder='weight...'></BR>"; echo "<input type='text' name='cat' value='' placeholder='category..'></BR>"; echo "<input type='hidden' name='id_cat' value='" . $id_c . "' ></BR>"; echo "<input type='Submit' name='insert' value='Add token trace'>"; echo "</form>";
function insert_videos() { $videos = get_videos(); $i = 1; $search_query = ''; foreach ($videos as $video) { if ($i > 1) { $search_query .= ' or'; } $search_query .= " type='{$video}'"; $i++; } $query = "select * from items where remove !=1 and ({$search_query}) order by band asc"; $result = mysql_query($query); if ($result) { $videos = array(); while ($video = mysql_fetch_array($result)) { $image = get_record_image($video); //get the stored filename for the image $band = get_band($video); $title = get_title($video); $type = str_replace('\\', '', $video['type']); if (isset($title) && !empty($title)) { $title = strtoupper($band) . ' "' . $title . '"'; } else { $title = strtoupper($band); } $itemid = $video['itemid']; $sku = get_sku($video); $variant_sku = $sku . '-' . strtolower($type); $vendor = strip_tags($video['label']); $vendor = str_replace('\\', '', $vendor); $shopify_type = 'Video'; $description = clean_text($video['description']); $weight = get_weight($type); $price = str_replace('$', '', $video['price']); if ($price == 'FREE') { $price = 0; } $sellprice = $price; $tags = "{$band}, {$type}, {$vendor}"; $alt = null; if ($image) { $alt = $title; } $videos[] = array($variant_sku, $title, $description, $vendor, $shopify_type, $tags, 'true', "Format", $type, null, null, null, null, $variant_sku, $weight, null, 1, 'deny', 'manual', $price, null, 'true', 'true', null, $image, $alt); } return $videos; } }
function construct_table_draw_table($sql_load) { //here we get all parameters needed to set a size of manifests $PARAMETER = "true"; //just something get_size_of_manifest($sql_load); //yes here only once. Lets change it //ok no global db cause before connect local db glob connect_dbi(); //here this query should be prepered and keep as one global passed to functons. Reference add to db needs to read first counter //* $sql="SELECT * from sub_cat ORDER BY id_c DESC"; $sql = $sql_load; $NUM_DRAW = 0; echo '<table data-filter="true">'; $result = query_selecti($sql); $counter_grid = 0; echo "<tr>"; while ($rek = mysqli_fetch_array($result, MYSQL_BOTH)) { //here shall be checked counter_grid and a Size_of_manifest if any discrepancies than communicate. Serious error. This means that what is visible on manifest //is different of that what was logicly received from manifest size function that is the main one needes for calculation $counter_grid++; $NUM_DRAW++; //This variable is local to draw function and is used to get ordered row in table $rcvd_qtty = qtty_rcvd_manifest_counter_no_delay(extract_session_manifest_reg(), $rek['id_c']); $sub_cat_item_name = $rek['Name_sub']; //this is name of subcategory. $placeholder_sub_cat = $sub_cat_item_name; $placeholder_sub_cat .= "...QTTY..."; /* if(($counter_grid%2==0)) echo '<td>1'; else if($counter_grid%2==1) echo '<td>2'; * */ //was #manifest echo '<td>'; echo '<form action="" id="manifest' . $NUM_DRAW . '" method="POST" data-ajax="false" data-prefetch="false">'; //taken numeric value out //$rek['id_c']." ". echo $rek['Name_sub'] . " " . visible($rek['kind']) . " " . get_weight($rek['id_c']) . " kgs "; echo ' QTTY: ' . $rcvd_qtty . ' </p>'; echo '<input type="hidden" name="num_sub_cat_un" value="' . $rek['id_c'] . '">'; //this hidden variable is used to generate universal post sub_category number and send it echo '<input type="hidden" name="no-delay" value="' . $rcvd_qtty . '">'; //temoporary to send qtty without delay echo '<input type="submit" value="+" name="plus' . $NUM_DRAW . '" data-role="button" data-transition="flip" data-inline="true">'; echo '<input type="submit" value="-" name="minus' . $NUM_DRAW . '" data-role="button" data-inline="true">'; echo '<input type="text" name="qtty' . $NUM_DRAW . '" value="" placeholder="' . $placeholder_sub_cat . '" >'; echo '</td>'; if ($counter_grid % 3 == 0) { echo '<tr></tr>'; } echo '</form>'; } echo '</table>'; }