2 function db_has_customers()
4 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."debtors_master");
7 function check_db_has_customers($msg)
10 if (!db_has_customers())
12 display_error($msg, true);
18 function db_has_currencies()
20 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."currencies");
23 function check_db_has_currencies($msg)
26 if (!db_has_currencies())
28 display_error($msg, true);
34 function db_has_sales_types()
36 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."sales_types");
39 function check_db_has_sales_types($msg)
42 if (!db_has_sales_types())
44 display_error($msg, true);
50 function db_has_item_tax_types()
52 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."item_tax_types");
55 function check_db_has_item_tax_types($msg)
58 if (!db_has_item_tax_types())
60 display_error($msg, true);
66 function db_has_tax_types()
68 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."tax_types");
71 function check_db_has_tax_types($msg)
74 if (!db_has_tax_types())
76 display_error($msg, true);
82 function db_has_tax_groups()
84 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."tax_groups");
87 function check_db_has_tax_groups($msg)
90 if (!db_has_tax_groups())
92 display_error($msg, true);
98 function db_has_movement_types()
100 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."movement_types");
103 function check_db_has_movement_types($msg)
105 global $path_to_root;
106 if (!db_has_movement_types())
108 display_error($msg, true);
114 function db_customer_has_branches($customer_id)
116 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE debtor_no='$customer_id'");
119 function db_has_customer_branches()
121 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch");
124 function check_db_has_customer_branches($msg)
126 global $path_to_root;
127 if (!db_has_customer_branches())
129 display_error($msg, true);
135 function db_has_sales_people()
137 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."salesman");
140 function check_db_has_sales_people($msg)
142 global $path_to_root;
143 if (!db_has_sales_people())
145 display_error($msg, true);
151 function db_has_sales_areas()
153 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."areas");
156 function check_db_has_sales_areas($msg)
158 global $path_to_root;
159 if (!db_has_sales_areas())
161 display_error($msg, true);
167 function db_has_shippers()
169 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."shippers");
172 function check_db_has_shippers($msg)
174 global $path_to_root;
175 if (!db_has_shippers())
177 display_error($msg, true);
183 function db_has_open_workorders()
185 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."workorders WHERE closed=0");
188 function db_has_workorders()
190 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."workorders");
193 function check_db_has_workorders($msg)
195 global $path_to_root;
196 if (!db_has_workorders())
198 display_error($msg, true);
204 function db_has_open_dimensions()
206 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."dimensions WHERE closed=0");
209 function db_has_dimensions()
211 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."dimensions");
214 function check_db_has_dimensions($msg)
216 global $path_to_root;
217 if (!db_has_dimensions())
219 display_error($msg, true);
226 function db_has_suppliers()
228 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."suppliers");
231 function check_db_has_suppliers($msg)
233 global $path_to_root;
234 if (!db_has_suppliers())
236 display_error($msg, true);
242 function db_has_stock_items()
244 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master");
247 function check_db_has_stock_items($msg)
249 global $path_to_root;
250 if (!db_has_stock_items())
252 display_error($msg, true);
258 function db_has_bom_stock_items()
260 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag='M' OR mb_flag='K')");
263 function check_db_has_bom_stock_items($msg)
265 global $path_to_root;
266 if (!db_has_bom_stock_items())
268 display_error($msg, true);
274 function db_has_manufacturable_items()
276 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag='M')");
279 function check_db_has_manufacturable_items($msg)
281 global $path_to_root;
282 if (!db_has_manufacturable_items())
284 display_error($msg, true);
290 function db_has_purchasable_items()
292 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag!='M' AND mb_flag!='K')");
295 function check_db_has_purchasable_items($msg)
297 global $path_to_root;
298 if (!db_has_purchasable_items())
300 display_error($msg, true);
306 function db_has_costable_items()
308 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag!='D' AND mb_flag!='K')");
311 function check_db_has_costable_items($msg)
313 global $path_to_root;
314 if (!db_has_costable_items())
316 display_error($msg, true);
322 function db_has_stock_categories()
324 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_category");
327 function check_db_has_stock_categories($msg)
329 global $path_to_root;
330 if (!db_has_stock_categories())
332 display_error($msg, true);
338 function db_has_workcentres()
340 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."workcentres");
343 function check_db_has_workcentres($msg)
345 global $path_to_root;
346 if (!db_has_workcentres())
348 display_error($msg, true);
354 function db_has_locations()
356 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."locations");
359 function check_db_has_locations($msg)
361 global $path_to_root;
362 if (!db_has_locations())
364 display_error($msg, true);
370 function db_has_bank_accounts()
372 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."bank_accounts");
375 function check_db_has_bank_accounts($msg)
377 global $path_to_root;
378 if (!db_has_bank_accounts())
380 display_error($msg, true);
386 function db_has_gl_accounts()
388 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."chart_master");
391 function db_has_gl_account_groups()
393 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."chart_types");
396 function check_db_has_gl_account_groups($msg)
398 global $path_to_root;
399 if (!db_has_gl_account_groups())
401 display_error($msg, true);
407 function db_has_quick_entries()
409 return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."quick_entries");
412 function check_empty_result($sql)
414 $result = db_query($sql, "could not do check empty query");
416 $myrow = db_fetch_row($result);
417 return $myrow[0] > 0;
420 // Integer input check
421 // Return 1 if number has proper form and is within <min, max> range
423 function check_int($postname, $min=null, $max=null) {
424 if(!isset($_POST[$postname]))
426 $num = input_num($postname);
429 if (isset($min) && ($num<$min))
431 if (isset($max) && ($num>$max))
436 // Numeric input check.
437 // Return 1 if number has proper form and is within <min, max> range
439 function check_num($postname, $min=null, $max=null) {
440 if(!isset($_POST[$postname]))
442 $num = input_num($postname);
445 if (isset($min) && ($num<$min))
447 if (isset($max) && ($num>$max))