4.7
-- NetCat 4.7 Extra [0] component file, generated 2012-03-14 11:38:21
INSERT INTO `Class` SET `Class_Name` = 'Магазин: Заказ', `Class_Group` = 'Интернет-магазин', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '$f_AdminCommon\n\n<br>\n<form action=\'".($admin_mode ? "".$HTTP_ROOT_PATH."index.php?" : "".$SUB_FOLDER.$current_sub[\'Hidden_URL\'].$current_cc[\'EnglishName\'].".html" )."\' method=\'get\'>\n<input type=\'hidden\' name=\'admin_mode\' value=\'".$admin_mode."\' />\n".( $inside_admin ? "<input type=\'hidden\' name=\'inside_admin\' value=\'1\' />" : "")."\n<input type=hidden name=catalogue value=$catalogue>\n<input type=hidden name=sub value=$sub>\n<input type=hidden name=cc value=$cc>\n\n".NETCAT_MODULE_NETSHOP_ORDER_STATUS." \n<select name=order_status onchange=\'this.form.submit();\'>\n<option value=0>".NETCAT_MODULE_NETSHOP_ORDER_NEW.\n\n  listQuery("SELECT ShopOrderStatus_ID, ShopOrderStatus_Name FROM Classificator_ShopOrderStatus",\n            "<option value=\\$data[ShopOrderStatus_ID]\\".\n            (\\$data[\'ShopOrderStatus_ID\']==\\$_GET[\'order_status\'] ?\n             \' selected\':\'\').\\">\\$data[ShopOrderStatus_Name]")."\n</select>\n<input type=submit value=\' OK \'>\n<hr size=1 noshade>', `FormSuffix` = '', `RecordTemplate` = '";\n\n$shop->LoadOrder($f_RowID);\n\n$result .= "<br><table border=0 width=100% cellspacing=0 cellpadding=0><tr valign=top><td>\n <b>$f_ContactName</b><br>$f_Phone".\n ($f_Phone && $f_Email ? ", " : "").\n ($f_Email ? "<a href=\'mailto:$f_Email\'>$f_Email</a>":"" );\n\nif ($f_Address) { $result .= "<br>$f_Address"; }\n\n$result .= "<br><a href=\'".$SUB_FOLDER.$HTTP_ROOT_PATH."modules/netshop/export/commerceml.php?order_id=$f_RowID\'>Экспорт в CommerceML</a></td>\n  <td width=350>$f_AdminButtons</td></tr></table>\n  <table border=1 width=100%>";\n\nforeach ($shop->CartContents as $row_order)\n{\n   $item_id = ($row_order["ItemID"] ? "[$row_order[ItemID]]" : "[$row_order[Message_ID]]");\n\n   $result .= "\n<tr>\n <td width=60%>$item_id $row_order[Name]</td>\n <td>$row_order[ItemPriceF] * $row_order[Qty] $row_order[Units] = $row_order[TotalPriceF]</td>\n</tr>";\n}\n\n$result .= "</table>\n<br>\n\n', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '";\n\nif(!is_object($shop)) {\n    $shop = new NetShop();\n}\n\n$ret = \'\';\n\nif (!$shop->CartCount()) {\n    $ret .= NETCAT_MODULE_NETSHOP_ERROR_CART_EMPTY;\n} else {\n    if ($GLOBALS[\'warnText\']) {\n        $ret .= "<p class=netshop_error>$warnText</p><br />";\n    }\n    \n    $ret .= "<form name=\'adminForm\' id=\'adminForm\' method=\'post\' action=\'".$SUB_FOLDER.$HTTP_ROOT_PATH."add.php\'>\n                <div id=\'nc_moderate_form\'>\n                    <div class=\'nc_clear\'></div>\n                    <input name=\'admin_mode\' type=\'hidden\' value=\'$admin_mode\' />\n                    ".$nc_core->token->get_input()." \n                    <input name=\'catalogue\' type=\'hidden\' value=\'$catalogue\' />\n                    <input name=\'cc\' type=\'hidden\' value=\'$cc\' />\n                    <input name=\'sub\' type=\'hidden\' value=\'$sub\' />\n                    <input name=\'posting\' type=\'hidden\' value=\'1\' />\n                    <input name=\'curPos\' type=\'hidden\' value=\'$curPos\' />\n                    <input name=\'f_Parent_Message_ID\' type=\'hidden\' value=\'$f_Parent_Message_ID\' />\n                </div>";\n    $ret .= nc_string_field("ContactName", "maxlength=\'255\' size=\'50\'", $classID, 1)."<br /><br />";\n    $ret .= nc_string_field("Phone", "maxlength=\'255\' size=\'50\'", $classID, 1)."<br /><br />";\n    $ret .= nc_string_field("Address", "maxlength=\'255\' size=\'50\'", $classID, 1)."<br /><br />";\n    $ret .= nc_string_field("Email", "maxlength=\'255\' size=\'50\'", $classID, 1)."<br /><br />";\n    $ret .= nc_text_field("Comments", "", $classID, 1)."<br /><br />";\n    $ret .= "<input type=\'hidden\' name=\'f_PaymentMethod\' value=\'1011\' />";\n\n    $SQL = "SELECT `Message_ID` as ID,\n                   `Name` as delivery,\n                   `Description`\n            FROM `Message{$shop->delivery_methods_table}`\n                WHERE Checked = 1";\n\n    $delivery = $db->get_results($SQL);\n    \n    if ($delivery) {\n        $ret .= "Способ доставки:";\n        if(1 == count($delivery)) {\n            $ret .= "<span>\n                        {$delivery[0]->delivery} ".($delivery[0]->Description ? "({$delivery[0]->Description})" : "")."\n                        <input type=\'hidden\' name=\'f_DeliveryMethod\' value=\'{$delivery[0]->ID}\' />\n                     </span><br /><br />";\n        } else {\n            $ret .= "<div>";\n            foreach($delivery as $method) {\n                $ret .= "<div><input type=\'radio\' \n                                name=\'f_DeliveryMethod\'\n                                value=\'{$method->ID}\'\n                                id=\'ir{$method->ID}\' />\n                        <label for=\'ir{$method->ID}\'>{$method->delivery} ".($method->Description ? "({$method->Description})" : "")."</label></div>";\n            }\n            $ret .= "</div><br />";\n        }\n    }\n    \n    $ret .= "<div class=\'order_buttons\'>\n             <input id=\'pay\' type=\'submit\' value=\\"".NETCAT_MODULE_NETSHOP_CART_CHECKOUT."\\"></div>";\n    $ret .= "</form></div>";\n}\necho "\n$ret', `EditTemplate` = '". \n\n/* WEIRD HACK. (Corrupts script flow, yet works) */\n\neval("include(\'{$MODULE_FOLDER}netshop/interface/order_edit.php\');")\n\n." ', `AddActionTemplate` = '";\n$shop->SaveOrder($msgID);\n\nwhile(ob_end_clean());\n\nif($isNaked) {\n  echo \'OK\';\n} else {\n  $EN = nc_Core::get_object()->sub_class->get_by_id($cc_settings[\'myorder_sub_id\'], \'EnglishName\');\n  $HU = nc_Core::get_object()->sub_class->get_by_id($cc_settings[\'myorder_sub_id\'], \'Hidden_URL\');\n  header("Location: {$HU}{$EN}_$msgID.html");\n}\n\nexit;\n$result .= "', `EditActionTemplate` = '". NETCAT_MODERATION_MSG_OBJCHANGED."\n<br><br>\n<a href=$goBackLink>".NETCAT_MODERATION_BACKTOSECTION."</a>";\n\ninclude("{$MODULE_FOLDER}netshop/interface/order_save.php");\n\n"', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'global $shop;\n if (!is_object($shop)) $shop = new Netshop();\n if ($order_status)\n{\n  $order_status = (int)$order_status;\n  $query_where = "a.Status = \'$order_status\'";\n}\nelse\n{\n  $query_where = "a.Status IS NULL"; // new orders\n}', `AddCond` = 'if(!$f_ContactName) {\n	$posting = 0;\n	$warnText = NETCAT_MODERATION_INFO_REQFIELDS;\n}\n\nif (!$shop->CartCount()) {\n  $posting = 0;\n}\n', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '0', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '".NETCAT_MODERATION_MSG_OBJSDELETED. "<br><br>\r\n<a href=$goBackLink>".NETCAT_MODERATION_BACKTOSECTION."</a>";\r\n\r\nif (is_numeric($message)) { $ids = $message; }\r\nelse\r\n{\r\n   $ids = array();\r\n   foreach ((array)$q as $row) { $ids[] = $row[0]; }\r\n   $ids = join(", ", $ids);\r\n}\r\n\r\nif (strlen($ids))\r\n{\r\n   q("DELETE FROM Netshop_OrderGoods WHERE Order_ID IN ($ids)");\r\n   q("DELETE FROM Netshop_OrderDiscounts WHERE Order_ID IN ($ids)");\r\n}\r\n\r\necho "', `CustomSettingsTemplate` = '$settings_array = array(\r\n	\'myorder_sub_id\' => array(\r\n		\'type\' => \'int\',\r\n		\'subtype\' => \'\',\r\n		\'caption\' => \'Номер компонента "Заказы для личного кабинета" в разделе\',\r\n		\'min\' => \'\',\r\n		\'max\' => \'\'));', `ClassDescription` = '', `DeleteTemplate` = '', `ClassTemplate` = '0', `Type` = 'useful', `CacheForUser` = '0';
INSERT INTO `Class` SET `Class_Name` = 'Магазин: Заказы для личного кабинета', `Class_Group` = 'Шаблоны компонентов', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '";\n\n$result .= "<div style=\'padding: 5px;\'><form method=\'post\'>Статус заказа: <select name=\'order_status\'>";\n$result .= "<option selected value=\'0\'>все</option>";\n$result .= "<option value=\'new\'>новый</option>";\nforeach ($status as $row) {\n    $result .= "<option value=\'{$row->ID}\' ".($row->ID == $s_status ? \'selected\' : \'\').">$row->Name</option>";\n}\n$result .= "</select> <input type=\'submit\' value=\'Показать\'></form></div>";\n\n$result .= "\n<div>', `FormSuffix` = '</div>', `RecordTemplate` = '<style>\n.order_header div { display: inline-block; }\n.order_body { padding: 5px; }\n.order_body .left {text-align: left; width: 65%; display: inline-block;}\n.order_body .right {text-align: right; width: 30%; display: inline-block;}\n</style>\n";\n$shop->LoadOrder($f_RowID);\n\n$result .= "\n<form action=\'$SUB_FOLDER/netcat/message.php\' method=\'post\'>\n<div style=\'padding: 5px; background-color: #".($f_RowNum % 2 ? \'FFF\' : \'EEE\').";\'>\n<div class=\'order_header\'>\n  <div style=\'width: 70%;\'>\n    <h3 style=\'margin-top: 5px;\'><a href=\'$fullLink\'>Заказ №$f_RowID</a> от $f_Created_day ".$months[(int)$f_Created_month]." $f_Created_year года</h3> \n  </div>\n  <div style=\'width: 25%; text-align: right;\'>\n      <span>Статус заказа: </span><b>".($f_Status ? $order_status[$f_Status] : "Новый")."</b>\n  </div>\n</div>\n</form>\n$f_AdminButtons\n";\n$result .= "<div class=\'order_body\'><div class=\'left\'>";\n$result_tmp = array();\nforeach ($shop->CartContents as $position) {\n    $result_tmp[] = $position[\'URL\'] ? "<a href=\'".$position[\'URL\']."\'>".$position[\'Name\']."</a>" : $position[\'Name\'] . ($position[\'Qty\'] > 1 ? " ({$position[\'Qty\']})" : "");\n}\n$result .= join(\', \', $result_tmp);\n$result .= "</div><div class=\'right\'><b>".$shop->FormatCurrency($shop->CartSum())."</b></div>";\n$result .= "</div>";\n$result .= "<br /></div>', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '<style>\n    .error { color: red; }\n    .order_head .order_body { padding: 5px; }\n    .order_body .left {text-align: left; width: 65%; display: inline-block;}\n    .order_body .right {text-align: right; width: 30%; display: inline-block;}\n    .order_head .num {font-weight: normal; font-size: 150%;}\n    #qiwiPhoneD { padding-left: 1px; margin-left: 25px; display:none; padding:5px;}\n</style>\n";\n$shop->LoadOrder($message);\n\n$res .= "\n$f_AdminButtons\n\n<div style=\'padding:5px;\'>\n  <div class=\'order_head\'>\n    <div class=\'num\'>Заказ №$f_RowID</div>\n    <div>от $f_Created_day ".$months[(int) $f_Created_month]." $f_Created_year года</div>\n  </div>\n  <br />\n  <div class=\'order_body\'>\n    <div style=\'background-color: #CCC; padding: 5px;\'>\n      <div class=\'left\'><b>Продукт/услуга</b></div>\n      <div class=\'right\'><b>Стоимость</b></div>\n    </div>\n";\n$res .= "<div style=\'padding: 5px;\'>";\nforeach ($shop->CartContents as $position) {\n\n    $res .= "<div class=\'left\'>";\n    $res .= $position[\'URL\'] ? "<a href=\'".$position[\'URL\']."\'>".$position[\'Name\']."</a>" : $position[\'Name\'];\n    $res .= "</div><div class=\'right\'>";\n    $res .= $position[\'Qty\']." * <b>".$shop->FormatCurrency($position[\'Price\'] * $position[\'Qty\'])."</b>";\n    $res .= "</div>";\n}\n$res .= "</div>";\nif ($shop->CartDiscounts) {\n    $discounts = null;\n    foreach ($shop->CartDiscounts as $val) {\n        $discounts .= "<div class=\'left\'>{$val[\'Name\']}</div><div class=\'right\'><b>-".$shop->FormatCurrency($val[\'Sum\'])."</b></div>";\n    }\n    $res .= "<div style=\'background-color: #EEE; padding: 5px;\'>$discounts</div>";\n}\n\n$res .= "<div style=\'padding: 5px;\'><div class=\'left\'>Общая стоимость заказа: <b></div><div class=\'right\'>".$shop->FormatCurrency($shop->CartSum())."</b></div></div><br/>";\n$res .= "<div style=\'padding: 5px;\'>";\nif ($f_Address) {\n    $res .= "<div>Адрес:  $f_Address </div><br />";\n}\n\n$SQL = "SELECT `Name` as Delivery\n            FROM `Message{$shop->delivery_methods_table}`\n                WHERE Message_ID = {$shop->Order[\'DeliveryMethod\']}";\n\n$methods = $db->get_row($SQL);\n\nif ($methods->Delivery) {\n    $res .= "<div>Вариант доставки:  {$methods->Delivery}</div>";\n}\n\n$end = \'\';\n$qiwi_js = "\nif(\'\' == $(\'#qiwiPhone\').val()) {\n    $(\'#qiwiPhoneS\').addClass(\'error\');\n    return false;\n} else {\n    $(\'#qiwiPhoneS\').removeClass(\'error\');\n}";\n$qiwi_check_num_js = \'\';\n\n$isChange = \'\';\nif (1011 != $f_PaymentMethod) {\n    $isChange = "AND `isChange` = 1";\n}\n\n$SQL = "SELECT `Message_ID`,\n               `Name`,\n               `Interface`,\n               `isChange`\n            FROM Message{$shop->payment_methods_table}\n                WHERE `Checked` = 1";\n$methods = $db->get_results($SQL);\n$phase = 0;\nif($methods) {\n    $phase = 1;\n    foreach ($methods as $method) {\n        if(!$method->isChange && ($method->Message_ID == $f_PaymentMethod)) {\n            $phase = 0;\n        }\n    }\n}\n\nif ($phase) {\n    $case_js = \'\';\n    $adm_message = array();\n    $res .= \'<br />\';\n    foreach ($methods as $method) {\n        if ($pay_error = $shop->check_payment_errors($method->Interface)) {\n            $adm_message[] =  "<b>".$method->Name."</b>"." ($pay_error)";\n            continue;\n        }\n        $pay_method .= "<div><input type=\'radio\' ".($method->Message_ID == $f_PaymentMethod ? " checked " : "")."\n                            name=\'f_PaymentMethod\'\n                            value=\'$method->Message_ID\'\n                            id=\'$method->Interface\' />\n                    <label for=\'$id\'>{$method->Name}</label>";\n        if ($method->Interface) {\n            $qiwi_check_num_js = \'\';\n            if (\'qiwi\' == $method->Interface) {\n                $qiwi_id = $method->Message_ID;\n                $pay_method .= "<div id=\'qiwiPhoneD\'>\n                                         <span id=\'qiwiPhoneS\'>Введите номер своего кошелька в системе QIWI (*):</span><br />\n                                         <input type=\'text\' id=\'qiwiPhone\' value=\'\' name=\'qiwiPhone\' />\n                                     </div>";\n                $qiwi_check_num_js = $qiwi_js;\n            }\n            echo $shop->Payment($method->Interface, \'create_bill\', true);\n            $hash = md5($method->Message_ID.$message.$nc_core->get_settings(\'SecretKey\', \'system\'));\n            $case_js .= "case \'{$method->Message_ID}\':\n                                         $qiwi_check_num_js\n                                         $.post(\'\', \'pm={$method->Message_ID}&order_id=$message&hash=$hash\', function(response){\n                                             $(\'#f{$method->Interface}\').submit();\n                                         });\n                                         break; \\n";\n        }\n        $pay_method .= "</div>";\n    }\n    $end = "</div>";\n} else {\n    $SQL = "SELECT `Message_ID`,\n                           `Name`,\n                           `Interface`\n                        FROM `Message{$shop->payment_methods_table}`\n                            WHERE Message_ID = $f_PaymentMethod";\n\n    $method = $db->get_row($SQL);\n    $pay_method .= $method->Name;\n\n    if ($method->Interface && \'cash\' != $method->Interface) {\n        if (\'qiwi\' == $method->Interface) {\n            $qiwi_id = $method->Message_ID;\n            $pay_method .= "<div>\n                                 <span id=\'qiwiPhoneS\'>Введите номер своего кошелька в системе QIWI (*):</span>\n                                 <input type=\'text\' id=\'qiwiPhone\' value=\'\' name=\'qiwiPhone\' />\n                             </div>";\n            $qiwi_check_num_js = $qiwi_js;\n        }\n        echo $shop->Payment($method->Interface, \'create_bill\', true);\n        $hash = md5($method->Message_ID.$message.$nc_core->get_settings(\'SecretKey\', \'system\'));\n        $no_radio_js = $qiwi_check_num_js." $(\'#f{$method->Interface}\').submit();";\n    }\n}\n\n$res .= $pay_method ? "<br /><div>Способ оплаты: ".$pay_method.$end."</div>" : \'\';\n\necho "\n<script>\n    $(document).ready(function(){\n        $(\'#pay\').click(function(){\n             $(\'#to\').val($(\'#qiwiPhone\').val());\n             ".($no_radio_js ? $no_radio_js : "\n             switch ($(\':radio[name=f_PaymentMethod]\').filter(\':checked\').val()) {\n                 $case_js\n             }")."\n        });\n        ".(!$qiwi_id ? "" : "\n        $(\':radio[name=f_PaymentMethod]\').click(function(){\n            if(this.value == $qiwi_id) {\n                $(\'#qiwiPhoneD\').show();\n            } else {\n                $(\'#qiwiPhoneD\').hide();\n            }\n        });")."\n    });\n</script>";\n\n$res .= "</div>";\necho " $res\n<br />\n<div>\n".(\'cash\' != $method->Interface && $pay_method ? "<input id=\'pay\' type=\'button\' value=\'Оплатить\'>" : "")."\n</div>\n</div>\n</div>\n</div>\n\n".(is_object($perm) && $perm->isSupervisor() && $adm_message[0] ? "\n<br />\n<div style=\'font-size: 70%; padding: 10px; background-color: #EEE\'>\nАдминистратору:<br />Платежные системы ".join(", ", $adm_message)." будут доступны после ввода корректных настроек\n</div>\n" : "")."', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '".eval("if (!\\$shop) \\$shop=new Netshop(); return \\$shop->PrintOrderForm();")."', `EditTemplate` = '". \n\n/* WEIRD HACK. (Corrupts script flow, yet works) */\n\neval("include(\'{$MODULE_FOLDER}netshop/interface/order_edit.php\');")\n\n." ', `AddActionTemplate` = '";\n$shop->SaveOrder($msgID);\nprint "Заказ оформлен (#$msgID).";\n$result .= "\n', `EditActionTemplate` = '', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'if($_POST[\'pm\']) {\n    $pm = intval($_POST[\'pm\']);\n    $order = intval($_POST[\'order_id\']);\n    $post_hash = $_POST[\'hash\'];\n    $hash = md5($pm . $order . $nc_core->get_settings(\'SecretKey\', \'system\'));\n    if($hash == $post_hash) {\n        $SQL = "UPDATE Message{$cc_env["Class_ID"]} SET PaymentMethod = $pm WHERE Message_ID = $order";\n        $db->query($SQL);\n    }\n    exit;\n}\n\n$ignore_sub = 1;\n$ignore_cc = 1;\n\n$months = array(1 => \'января\', \'февраля\', \'марта\', \'апреля\', \'мая\', \'июня\', \'июля\', \'августа\', \'сентября\', \'октября\', \'ноября\', \'декабря\');\n\nif (!is_object($shop)) {\n    $shop = new Netshop();\n}\n\n$s_status = $_POST[\'order_status\'];\nif ($s_status == \'new\') {\n    $query_where .= " a.Status IS NULL";\n} elseif ($s_status = intval($s_status)) {\n    $query_where .= " a.Status = $s_status";\n}\n\nif (is_object($perm) && $perm->isSupervisor()) {\n    $ingore_user = 1;\n} else {\n    $query_where = " a.User_ID = {$current_user[\'User_ID\']} ";\n}\n\n$SQL = "SELECT ShopOrderStatus_ID as ID, \n               ShopOrderStatus_Name as Name\n            FROM Classificator_ShopOrderStatus";\n$status = $db->get_results($SQL);\n\nforeach($status as $row) {\n    $order_status[$row->ID] = ucfirst($row->Name);\n}\n\n// на случай, если в разделе права выставлены неверно\nif (!$current_user[\'User_ID\']) {\n    $query_where = " 0 "; \n}', `AddCond` = '', `EditCond` = '', `SubscribeCond` = '', `DeleteCond` = '', `NL2BR` = '1', `UseCaptcha` = '0', `CheckActionTemplate` = '', `DeleteActionTemplate` = '', `CustomSettingsTemplate` = '', `ClassDescription` = '', `DeleteTemplate` = '', `ClassTemplate` = '%INSERT_ID%', `Type` = 'useful', `CacheForUser` = '0';
CREATE TABLE `Message%INSERT_ID%` (  `Message_ID` int(11) NOT NULL auto_increment,  `User_ID` int(11) NOT NULL default '0',  `Subdivision_ID` int(11) NOT NULL default '0',  `Sub_Class_ID` int(11) NOT NULL default '0',  `Priority` int(11) NOT NULL default '0',  `Checked` tinyint(4) NOT NULL default '1',  `IP` varchar(15) default NULL,  `UserAgent` varchar(255) default NULL,  `Parent_Message_ID` int(11) NOT NULL default '0',  `Created` datetime NOT NULL default '0000-00-00 00:00:00',  `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `LastUser_ID` int(11) NOT NULL default '0',  `LastIP` varchar(15) default NULL,  `LastUserAgent` varchar(255) default NULL,  `Keyword` varchar(255) NOT NULL default '',  `ncTitle` varchar(255) default NULL,  `ncKeywords` varchar(255) default NULL,  `ncDescription` text,  `Address` varchar(255) default NULL,  `Phone` varchar(255) default NULL,  `OrderCurrency` int(11) default NULL,  `PaymentMethod` int(11) default NULL,  `PaymentCost` double default NULL,  `Comments` text,  `PaymentInfo` text,  `DeliveryMethod` int(11) default NULL,  `DeliveryCost` double default NULL,  `ContactName` varchar(255) NOT NULL default '',  `Email` varchar(255) default NULL,  `Status` int(11) default NULL,  PRIMARY KEY  (`Message_ID`),  UNIQUE KEY `Sub_Class_ID_2` (`Sub_Class_ID`,`Message_ID`,`Keyword`),  KEY `User_ID` (`User_ID`),  KEY `LastUser_ID` (`LastUser_ID`),  KEY `Subdivision_ID` (`Subdivision_ID`),  KEY `Parent_Message_ID` (`Parent_Message_ID`)) ENGINE=MyISAM;
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Address', 'Адрес доставки', 1, '', 0, 4, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Phone', 'Контактный телефон', 1, '', 0, 3, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'ContactName', 'Фамилия, имя', 1, '', 1, 2, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Email', 'Email', 1, '', 0, 5, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PaymentMethod', 'Способ оплаты', 2, '', 0, 8, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'DeliveryMethod', 'Способ доставки', 2, '', 0, 10, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Comments', 'Примечания', 3, '', 0, 6, 0, '', 1);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PaymentInfo', 'Информация об оплате', 3, '', 0, 9, 0, '', 2);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'OrderCurrency', 'Валюта заказа', 4, 'ShopCurrency', 0, 1, 0, '', 2);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'Status', 'Статус заказа', 4, 'ShopOrderStatus', 0, 12, 0, '', 2);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'PaymentCost', 'Наценка (способ оплаты)', 7, '', 0, 7, 0, '', 2);
INSERT INTO Field (`Class_ID`, `Field_Name`, `Description`, `TypeOfData_ID`, `Format`, `NotNull`, `Priority`, `DoSearch`, `DefaultState`, `TypeOfEdit_ID`) VALUES (%INSERT_ID%, 'DeliveryCost', 'Стоимость доставки', 7, '', 0, 11, 0, '', 2);