static function install()
{
$db = Database::instance();
$db->query("CREATE TABLE IF NOT EXISTS {products} (\r\n `id` int(9) NOT NULL auto_increment,\r\n `name` TEXT NOT NULL,\r\n `cost` DECIMAL(10,2) default 0,\r\n `description` varchar(1024),\r\n `postage_band_id` int(9) default 1,\r\n PRIMARY KEY (`id`))\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$db->query("CREATE TABLE IF NOT EXISTS {product_overrides} (\r\n `id` int(9) NOT NULL auto_increment,\r\n `item_id` int(9) NOT NULL,\r\n `none` BOOLEAN default false,\r\n PRIMARY KEY (`id`))\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$db->query("CREATE TABLE IF NOT EXISTS {item_products} (\r\n `id` int(9) NOT NULL auto_increment,\r\n `product_override_id` int(9) NOT NULL,\r\n `product_id` int(9) NOT NULL,\r\n `include` BOOLEAN default false,\r\n `cost` DECIMAL(10,2) default -1,\r\n PRIMARY KEY (`id`))\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$db->query("CREATE TABLE IF NOT EXISTS {postage_bands} (\r\n `id` int(9) NOT NULL auto_increment,\r\n `name` TEXT NOT NULL,\r\n `flat_rate` DECIMAL(10,2) default 0,\r\n `per_item` DECIMAL(10,2) default 0,\r\n PRIMARY KEY (`id`))\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
//2011-08-20 added customerid
$db->query("CREATE TABLE IF NOT EXISTS {orders} (\r\n `id` int(9) NOT NULL auto_increment,\r\n `customerid` int(9) NOT NULL,\r\n\t\t `status` int(9) DEFAULT 0,\r\n `name` varchar(512),\r\n `email` varchar(256),\r\n `cost` DECIMAL(10,2) default 0,\r\n `method` int(9) DEFAULT 0,\r\n `text` TEXT NOT NULL,\r\n PRIMARY KEY (`id`))\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
//2011-08-20 added table
$db->query("CREATE TABLE IF NOT EXISTS {customers} (\r\n `id` int(9) NOT NULL AUTO_INCREMENT,\r\n `title` varchar(32) DEFAULT NULL,\r\n `name` varchar(256) NOT NULL,\r\n `initials` varchar(64) DEFAULT NULL,\r\n `insertion` varchar(16) DEFAULT NULL,\r\n `street` varchar(128) DEFAULT NULL,\r\n `housenumber` varchar(32) DEFAULT NULL,\r\n `postalcode` varchar(16) DEFAULT NULL,\r\n `town` varchar(128) DEFAULT NULL,\r\n `email` varchar(128) NOT NULL,\r\n `phone` varchar(16) DEFAULT NULL,\r\n `childname` varchar(64) DEFAULT NULL,\r\n `childgroup` varchar(32) DEFAULT NULL,\r\n `deliverypref` tinyint(2) DEFAULT NULL,\r\n PRIMARY KEY (`id`))\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
//2011-05-01 added table
$db->query("CREATE TABLE IF NOT EXISTS {order_logs} (\r\n `id` int(9) NOT NULL,\r\n `status` int(9) NOT NULL,\r\n `event` int(9) NOT NULL,\r\n `timestamp` int(9) NOT NULL)\r\n ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$db->query("CREATE TABLE IF NOT EXISTS `ipn_messages` (\r\n `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n `date` int(11) NOT NULL,\r\n `key` varchar(20) NOT NULL,\r\n `txn_id` varchar(20) NOT NULL,\r\n `status` varchar(20) NOT NULL,\r\n `success` bool default false,\r\n `text` text,\r\n PRIMARY KEY (`id`)\r\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
/* name, fixed cost, per item cost */
/* postage_band::create("Geen verzendkosten",0,0);
postage_band::create("Standaard verzendkosten",2,0);
postage_band::create("Verzending via e-mail (gratis)",0,0);
*/
/* name, cost, descr, postageband id */
/* product::create("13x18",3.5,"Afdruk 13x18 cm glanzend",2);
product::create("2x 13x18",5,"ACTIE: Dubbele afdruk 13x18 cm glanzend",2);
product::create("Origineel",7.5,"Originele fotobestand in hoge resolutie",3);
product::create("8 Pasfoto's+9x13",4,"Vel met 8 pasfoto's + afdruk 9x13",2);
product::create("16 Pasfoto's",4,"Vel met 16 pasfoto's glanzend",2);
product::create("10x15",2.5,"Afdruk 10x15 cm glanzend",2);
product::create("20x30",6,"Afdruk 20x30 cm glanzend",2);
product::create("30x45",10,"Afdruk 30x45 cm glanzend",2);
product::create("13x18 (korting)",1.75,"Afdruk 13x18 cm glanzend",2);
product::create("20x30 (korting)",3,"Afdruk 20x30 cm glanzend",2);
product::create("Origineel (korting)",2.5,"Originele fotobestand in hoge resolutie",3);
*/
/* basket config settings */
basket::setWebsite("kidsfotos.nl");
basket::setWebshop("KidsFotos");
basket::setEmailAddress("KidsFotos.nl <*****@*****.**>");
basket::set_side_bar_only("1");
basket::setAllowPickup("1");
basket::setPickupLocation("De Blauwe Walvis");
basket::setOrderPrefix("2012-");
basket::setOrderBankAccount("59.24.98.220");
basket::setOrderAccountOwner("J. ten Kate, Utrecht");
/* basket template settings */
basket::setPaymentDetails("\r\n<p>U kunt betalen via overmaking op de bankrekening van %webshop.</p>\r\n<p>Instructies vindt u in de bevestingsmail van de bestelling.</p>\r\n<br />\r\n<h3>Algemene voorwaarden</h3>\r\n<p>U kunt de Algemene voorwaarden via deze <a href=#/downloads/Algemene_voorwaarden_2011.pdf# target=#_blank#>link</a> bekijken.</p>");
basket::setOrderCompletePage("<p>Hartelijk dank voor uw bestelling. Uw bestelnummer is </b>%order_number</b>.</p>\r\n<br />\r\n<p>%webshop heeft een bevestigingsmail verzonden met de gegevens van uw bestelling en de betalingsinformatie.\r\n<p>Wij verwerken de bestelling zodra de betaling is ontvangen.\r\n<br />\r\n<p>Voor vragen of opmerkingen over uw bestelling kunt u contact opnemen via bestelling@%website</p>");
basket::setOrderCompleteEmailSubject("Uw bestelling %order_number bij %webshop");
basket::setOrderCompleteEmail("Beste %name,\r\n\r\nHartelijk dank voor uw bestelling. De bestelgegevens en betalingsinformatie vindt u hieronder. \r\n\r\n%order_details");
basket::setOrderPaidEmailSubject("Update van uw bestelling %order_number bij %webshop: betaling ontvangen");
basket::setOrderPaidEmail("Beste %name,\r\n\r\n%webshop heeft uw betaling van %total_cost ontvangen en zal bestelling %order_number verwerken. \r\nU ontvangt een e-mail zodra de bestelling naar u wordt verzonden of klaarligt op het kinderdagverblijf. \r\n\r\nVoor vragen of opmerkingen over uw bestelling kunt u contact opnemen via bestelling@%website.");
basket::setOrderLatePaymentEmailSubject("Uw bestelling %order_number bij %webshop: wacht op betaling");
basket::setOrderLatePaymentEmail("Beste %name,\r\n\r\nEnige tijd geleden heeft u bij %webshop bestelling %order_number geplaatst. Onderaan vindt u hiervan de details.\r\nUit onze administratie blijkt dat het bedrag van %total_cost nog niet is voldaan. Wij maken u erop attent dat wij pas na ontvangst van de betaling de bestelling verwerken.\r\n\r\nMocht deze herinnering uw betaling hebben gekruist, dan kunt u deze als niet verzonden beschouwen.\r\n\r\nVoor vragen of opmerkingen over uw bestelling kunt u contact opnemen via bestelling@%website.");
basket::setOrderDeliveredEmailSubject("Update van uw bestelling %order_number bij %webshop: bestelling verstuurd");
basket::setOrderDeliveredEmail("Beste %name,\r\n\r\n%webshop heeft uw bestelling %order_number %delivery_method. \r\nNogmaals dank voor uw bestelling en veel plezier met de foto's!\r\n\r\nVoor vragen of opmerkingen over uw bestelling kunt u contact opnemen via bestelling@%website.");
basket::setOrderEmailClosing("Met vriendelijke groet,\r\n%webshop.nl - Fotograaf Jeroen ten Kate");
module::set_version("basket", 5);
}
static function extractTemplateForm($form)
{
$payment_details = $form->configure->payment_details->value;
$order_complete_page = $form->configure->order_complete_page->value;
$order_complete_email_subject = $form->configure->order_complete_email_subject->value;
$order_complete_email = $form->configure->order_complete_email->value;
$order_paid_email_subject = $form->configure->order_paid_email_subject->value;
$order_paid_email = $form->configure->order_paid_email->value;
$order_paid_delivered_email_subject = $form->configure->order_paid_delivered_email_subject->value;
$order_paid_delivered_email = $form->configure->order_paid_delivered_email->value;
$order_late_payment_email_subject = $form->configure->order_late_payment_email_subject->value;
$order_late_payment_email = $form->configure->order_late_payment_email->value;
$order_delivered_email_subject = $form->configure->order_delivered_email_subject->value;
$order_delivered_email = $form->configure->order_delivered_email->value;
$order_delivered_notpaid_email_subject = $form->configure->order_delivered_notpaid_email_subject->value;
$order_delivered_notpaid_email = $form->configure->order_delivered_notpaid_email->value;
$order_cancelled_email_subject = $form->configure->order_cancelled_email_subject->value;
$order_cancelled_email = $form->configure->order_cancelled_email->value;
$order_email_closing = $form->configure->order_email_closing->value;
basket::setPaymentDetails($payment_details);
basket::setOrderCompletePage($order_complete_page);
basket::setOrderCompleteEmailSubject($order_complete_email_subject);
basket::setOrderCompleteEmail($order_complete_email);
basket::setOrderPaidEmailSubject($order_paid_email_subject);
basket::setOrderPaidEmail($order_paid_email);
basket::setOrderPaidDeliveredEmailSubject($order_paid_delivered_email_subject);
basket::setOrderPaidDeliveredEmail($order_paid_delivered_email);
basket::setOrderLatePaymentEmailSubject($order_late_payment_email_subject);
basket::setOrderLatePaymentEmail($order_late_payment_email);
basket::setOrderDeliveredEmailSubject($order_delivered_email_subject);
basket::setOrderDeliveredEmail($order_delivered_email);
basket::setOrderDeliveredNotPaidEmailSubject($order_delivered_notpaid_email_subject);
basket::setOrderDeliveredNotPaidEmail($order_delivered_notpaid_email);
basket::setOrderCancelledEmailSubject($order_cancelled_email_subject);
basket::setOrderCancelledEmail($order_cancelled_email);
basket::setOrderEmailClosing($order_email_closing);
}
