Author: 永夜
-
Post Views: 35 sql statement: (SELECT SUM(O_G.GOODS_AMOUNT) as AMOUNT_SUM,SUM(o_g.goods_cost*o_g.goods_number) as cost_sum,sum(o_g.goods_number) as number_sum from ERP_ORDER_GOODS AS O_G left outer join erp_order as o on o_g.order_id = o.order_id left outer join erp_goods as g on g.gid = o_g.goods_id left outer join erp_brand as b on b.brand_id = g.brand_id where (o.add_time between “1389715200” and “1389772885”) and (o.order_status=1 or o.order_status=2)) union all (SELECT…
-
Post Views: 10 When executing the git add command in git bash, the following error message will appear: Execute the following command, the screenshot is as follows: Among them, –global, is only valid in the global configuration of this user!
-
Post Views: 10 HTML structure: <td><span id=”is_mar431″><input class=”is_mar” value=”0″ id=”is_mar431_0″ checked=”checked” type=”radio” name=”is_mar431″ /> <label for=”is_mar431_0″>no</label> <input class=”is_mar” value=”1″ id=”is_mar431_1″ type=”radio” name=”is_mar431″ /> <label for=”is_mar431_1″> is </label></span></td> JS structure (front): // Whether it is damaged, select Yes, enter the text box of the damage information $(“span[id^=is_mar]:radio”).change( function() { var this_name = $(this).attr(“name”); var input_id =mar_note_+this_name.substring(6); if…
-
Post Views: 8 The current demand is to judge whether the number of changes in the exchanged goods is all 0. If all are 0, a prompt box needs to be popped up and submitted! javascript: // Iterate the number of changes in the product, if all are 0, it will not be submitted var sub = 0; $(“.goods_number”).each(function…
-
Post Views: 12 In the process of importing excel files, this kind of problem occurs because the memory allocated to the php program is insufficient, so it is necessary to set the one in php.ini: Memory_limit = 512M, after setting it to 512M, restart the server, you can run normally!
-
Post Views: 11 array_key_exists($row[‘B’], $abrand) Modified to: array_key_exists((int)$row[‘B’], $abrand)
-
Post Views: 7 Now you need to extend the DatePicker, in: https://github.com/trentrichardson/jQuery-Timepicker-AddonThere are plugins that support this extension; The effect is as follows: Now the default is the English interface, the extended function needs to be set to Chinese, and the language setting file needs to be inserted: The result is as follows:
-
Post Views: 11 Delete the nbproject folder, and then recreate the project, there will be no such prompt!
-
Post Views: 9 cdbcommand cannot execute sql statement: sqlstate[HY000]: General Error: 1366 Incorrect Integer Value:Classificationfor columnBUY_CAT_IDat row 1. The SQL statement execute was: insert into `ERP_customer` (`realname`, `tel`, `address`, `spec_con`, `join_time`, `buy_cat_id`) values (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5). When importing EXCEL, if it is a null value in EXCEL, I set it to “”, it will still be converted…
-
Post Views: 35 Recently, in order to directly click the print button on the web page, I began to print the corresponding documents, analyzed several web controls, and finally decided to use the free version of JatoolSprinter. Among them, there is a problem with reyon under IE10. Obviously, there is only one page, but it has been judged that there…