Better vertical alignment of date picker icon.

[fa-stable.git] / includes / data_checks.inc

diff --git a/includes/data_checks.inc b/includes/data_checks.inc
index 7243e43fe937be460c3650d47028ade5939d7a33..8449b5dd63bce2ea47ddf8062aee0a031ea87a9c 100644 (file)
--- a/includes/data_checks.inc
+++ b/includes/data_checks.inc
@@ -495,6 +495,22 @@ function check_is_closed($type, $type_no, $msg=null)
        }
 }
 
+function check_db_has_template_orders($msg)
+{
+       $sql  = "SELECT sorder.order_no 
+               FROM ".TB_PREF."sales_orders as sorder,"
+                       .TB_PREF."sales_order_details as line
+               WHERE sorder.order_no = line.order_no AND sorder.type = 1
+               GROUP BY line.order_no";
+
+    if (!check_empty_result($sql))
+    {
+       display_error($msg, true);
+       end_page();
+       exit;
+    }
+}
+
 function check_deferred_income_act($msg)
 {
        global $path_to_root;