4.6
-- NetCat 4.6 Extra [0] component file, generated 2011-10-14 16:38:23
INSERT INTO `Class` SET `Class_Name` = 'Магазин: Заказ', `Class_Group` = 'Интернет-магазин', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '$f_AdminCommon\r\n\r\n<br>\r\n<form action=\'".($admin_mode ? "".$HTTP_ROOT_PATH."index.php?" : "".$SUB_FOLDER.$current_sub[\'Hidden_URL\'].$current_cc[\'EnglishName\'].".html" )."\' method=\'get\'>\r\n<input type=\'hidden\' name=\'admin_mode\' value=\'".$admin_mode."\' />\r\n".( $inside_admin ? "<input type=\'hidden\' name=\'inside_admin\' value=\'1\' />" : "")."\r\n<input type=hidden name=catalogue value=$catalogue>\r\n<input type=hidden name=sub value=$sub>\r\n<input type=hidden name=cc value=$cc>\r\n\r\n".NETCAT_MODULE_NETSHOP_ORDER_STATUS." \r\n<select name=order_status onchange=\'this.form.submit();\'>\r\n<option value=0>".NETCAT_MODULE_NETSHOP_ORDER_NEW.\r\n\r\n  listQuery("SELECT ShopOrderStatus_ID, ShopOrderStatus_Name FROM Classificator_ShopOrderStatus",\r\n            "<option value=\\$data[ShopOrderStatus_ID]\\".\r\n            (\\$data[\'ShopOrderStatus_ID\']==\\$_GET[\'order_status\'] ?\r\n             \' selected\':\'\').\\">\\$data[ShopOrderStatus_Name]")."\r\n</select>\r\n<input type=submit value=\' OK \'>\r\n<hr size=1 noshade>', `FormSuffix` = '', `RecordTemplate` = '";\r\n\r\n$shop->LoadOrder($f_RowID);\r\n\r\n$result .= "<br><table border=0 width=100% cellspacing=0 cellpadding=0><tr valign=top><td>\r\n <b>$f_ContactName</b><br>$f_Phone".\r\n ($f_Phone && $f_Email ? ", " : "").\r\n ($f_Email ? "<a href=\'mailto:$f_Email\'>$f_Email</a>":"" );\r\n\r\nif ($f_Address) { $result .= "<br>$f_Address"; }\r\n\r\n$result .= "<br><a href=\'".$SUB_FOLDER.$HTTP_ROOT_PATH."modules/netshop/export/commerceml.php?order_id=$f_RowID\'>Экспорт в CommerceML</a></td>\r\n  <td width=350>$f_AdminButtons</td></tr></table>\r\n  <table border=1 width=100%>";\r\n\r\nforeach ($shop->CartContents as $row_order)\r\n{\r\n   $item_id = ($row_order["ItemID"] ? "[$row_order[ItemID]]" : "[$row_order[Message_ID]]");\r\n\r\n   $result .= "\r\n<tr>\r\n <td width=60%>$item_id $row_order[Name]</td>\r\n <td>$row_order[ItemPriceF] * $row_order[Qty] $row_order[Units] = $row_order[TotalPriceF]</td>\r\n</tr>";\r\n}\r\n\r\n$result .= "</table>\r\n<br>\r\n\r\n', `RecordsPerPage` = '20', `SortBy` = '', `RecordTemplateFull` = '', `TitleTemplate` = '', `TitleList` = '', `UseAltTitle` = '0', `AddTemplate` = '".eval("if (!\\$shop) \\$shop=new Netshop(); return \\$shop->PrintOrderForm();")."', `EditTemplate` = '". \r\n\r\n/* WEIRD HACK. (Corrupts script flow, yet works) */\r\n\r\neval("include(\'{$MODULE_FOLDER}netshop/interface/order_edit.php\');")\r\n\r\n." \r\n', `AddActionTemplate` = '";\r\n$shop->SaveOrder($msgID);\r\nprint "Заказ оформлен (#$msgID).";\r\n$result .= "\r\n', `EditActionTemplate` = '". NETCAT_MODERATION_MSG_OBJCHANGED."\r\n<br><br>\r\n<a href=$goBackLink>".NETCAT_MODERATION_BACKTOSECTION."</a>";\r\n\r\ninclude("{$MODULE_FOLDER}netshop/interface/order_save.php");\r\n\r\n"', `SearchTemplate` = '', `FullSearchTemplate` = '', `SubscribeTemplate` = '', `System_Table_ID` = '0', `Settings` = 'global $shop;\r\n if (!is_object($shop)) $shop = new Netshop();\r\n if ($order_status)\r\n{\r\n  $order_status = (int)$order_status;\r\n  $query_where = "a.Status = \'$order_status\'";\r\n}\r\nelse\r\n{\r\n  $query_where = "a.Status IS NULL"; // new orders\r\n}', `AddCond` = 'if (!$shop->CartCount())\r\n{\r\n  $posting=0;\r\n}\r\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` = '', `ClassDescription` = '', `DeleteTemplate` = '', `ClassTemplate` = '0', `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',  `TimeToDelete` date DEFAULT NULL,  `TimeToUncheck` date DEFAULT NULL,  `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', 'E-mail', 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);