4.1
-- NetCat 4.1 Extra [0] component file, generated 2010-10-04 12:26:19
INSERT INTO `Class` SET `Class_Name` = 'Магазин: Заказ', `Class_Group` = 'Интернет-магазин', `DaysToHold` = '0', `AllowTags` = '0', `FormPrefix` = '$f_AdminCommon\r\n\r\n<br>\r\n<form method=get>\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` = '', `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', `CacheForUser` = '0';
CREATE TABLE Message%INSERT_ID% (`Message_ID` int(11) NOT NULL auto_increment, `User_ID` int(11) NOT NULL, `Subdivision_ID` int(11) NOT NULL, `Sub_Class_ID` int(11) NOT NULL, `Priority` int(11) NOT NULL default '0', `Keyword` char(255) NOT NULL, `Checked` tinyint(4) NOT NULL default '1', `TimeToDelete` date default NULL, `TimeToUncheck` date default NULL, `IP` char(15) default NULL, `UserAgent` char(255) default NULL, `Parent_Message_ID` int(11) NOT NULL default '0', `Created` datetime NOT NULL, `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `LastUser_ID` int(11) NOT NULL, `LastIP` char(15) default NULL, `LastUserAgent` char(255) default NULL, `Address` char(255) NULL, `Phone` char(255) NULL, `OrderCurrency` int NULL, `PaymentMethod` int NULL, `PaymentCost` double NULL, `Comments` text NULL, `PaymentInfo` text NULL, `DeliveryMethod` int NULL, `DeliveryCost` double NULL, `ContactName` char(255) NOT NULL, `Email` char(255) NULL, `Status` int NULL, PRIMARY KEY (`Message_ID`), UNIQUE KEY `Sub_Class_ID` (`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`) ) TYPE=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%, '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%, '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%, '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%, '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%, '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%, 'DeliveryCost', 'Стоимость доставки', 7, '', 0, 11, 0, '', 2);
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%, 'Status', 'Статус заказа', 4, 'ShopOrderStatus', 0, 12, 0, '', 2);