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 extractForm($form) { $email = $form->configure->email->value; $isPaypal = $form->configure->paypal->value; $paypal_account = $form->configure->paypal_account->value; $currency = $form->configure->currency->selected; basket::setEmailAddress($email); basket::setPaypal($isPaypal); basket::setPaypalAccount($paypal_account); basket::setCurrency($currency); }
static function extractForm($form) { $webshop = $form->configure->webshop->value; $website = $form->configure->website->value; $email = $form->configure->email->value; $is_side_bar = $form->configure->side_bar->value; $isPaypal = $form->configure->paypal->value; $paypal_account = $form->configure->paypal_account->value; $currency = $form->configure->currency->selected; $allow_pickup = $form->configure->allow_pickup->value; $pickup_location = $form->configure->pickup_location->value; $order_prefix = $form->configure->order_prefix->value; $order_bankaccount = $form->configure->order_bankaccount->value; $order_accountowner = $form->configure->order_accountowner->value; basket::setWebshop($webshop); basket::setWebsite($website); basket::setEmailAddress($email); basket::set_side_bar_only($is_side_bar); basket::setPaypal($isPaypal); basket::setPaypalAccount($paypal_account); basket::setCurrency($currency); basket::setAllowPickup($allow_pickup); basket::setPickupLocation($pickup_location); basket::setOrderPrefix($order_prefix); basket::setOrderBankAccount($order_bankaccount); basket::setOrderAccountOwner($order_accountowner); }
static function extractForm($form) { $email = $form->configure->email->value; $is_side_bar = $form->configure->side_bar->value; $isPaypal = $form->configure->paypal->value; $paypal_account = $form->configure->paypal_account->value; $currency = $form->configure->currency->selected; $allow_pickup = $form->configure->allow_pickup->value; $order_prefix = $form->configure->order_prefix->value; basket::setEmailAddress($email); basket::set_side_bar_only($is_side_bar); basket::setPaypal($isPaypal); basket::setPaypalAccount($paypal_account); basket::setCurrency($currency); basket::setAllowPickup($allow_pickup); basket::setOrderPrefix($order_prefix); }