public function onInstall() { eF_executeQuery("drop table if exists module_vlabs_shoppingcart"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_payment_method"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_user_payment"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_order_summary"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_package_summary"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_preassignment"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_store_inventory"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_order"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_log"); eF_executeQuery("drop table if exists module_vlabs_shoppingcart_dbadmin"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart` (\r\n `id` bigint(10) unsigned NOT NULL auto_increment,\r\n `course` bigint(10) unsigned NOT NULL default '0',\r\n `name` varchar(255) NOT NULL default '',\r\n `intro` mediumtext,\r\n `introformat` smallint(4) unsigned NOT NULL default '0',\r\n `timecreated` bigint(10) unsigned NOT NULL default '0',\r\n `timemodified` bigint(10) unsigned NOT NULL default '0',\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Default comment for shoppingcart, please edit me';"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_store_inventory` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `name` varchar(100) NOT NULL default '0',\r\n `description` varchar(100) default NULL,\r\n `price` double unsigned NOT NULL,\r\n `quantity` bigint(10) unsigned default NULL,\r\n `active` blob NOT NULL,\r\n `creationdate` datetime NOT NULL,\r\n `lastmodification` datetime NOT NULL,\r\n `unlimited` blob NOT NULL,\r\n `referenceid` varchar(100) default NULL,\r\n `type` enum('ITEM','PACKAGE','PACKAGE ITEM') NOT NULL default 'ITEM',\r\n `billable` blob NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=473 DEFAULT CHARSET=utf8 COMMENT='This table will contain all the items available in the shop';"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_payment_method` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `name` varchar(100) NOT NULL default '0',\r\n `description` varchar(100) NOT NULL default '',\r\n `merchantid` varchar(100) default NULL,\r\n `merchantkey` varchar(15) default NULL,\r\n `servertype` varchar(22) default NULL,\r\n `currency` varchar(3) default NULL,\r\n `type` enum('PAYMENT','NO PAYMENT') NOT NULL default 'NO PAYMENT',\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='This table will contain all the available payment methods';"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_user_payment` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `email` varchar(100) NOT NULL default '0',\r\n `payment` bigint(10) unsigned NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table will contain the type of paymemt for every user';"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_order` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `userid` mediumint(6) unsigned NOT NULL,\r\n `purchasedate` bigint(20) default NULL,\r\n `lastmodification` bigint(20) default NULL,\r\n `fulfillmentorderstate` varchar(100) NOT NULL default '',\r\n `financialorderstate` varchar(100) NOT NULL default '',\r\n `ordernumber` varchar(15) NOT NULL default '',\r\n `total` double(15,0) unsigned NOT NULL,\r\n `cancelled` binary(1) NOT NULL,\r\n `payment` binary(1) NOT NULL,\r\n `refund` double default NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2919 DEFAULT CHARSET=utf8 COMMENT='This table will contain the order information';"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_order_summary` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `orderid` mediumint(6) unsigned NOT NULL default '0',\r\n `itemid` mediumint(6) unsigned NOT NULL default '0',\r\n `quantity` bigint(10) unsigned NOT NULL default '0',\r\n `unitprice` double unsigned NOT NULL default '0',\r\n `cancelled` blob NOT NULL,\r\n PRIMARY KEY (`id`),\r\n KEY itemid (itemid),\r\n FOREIGN KEY itemid_fk_1(itemid)\r\n REFERENCES module_vlabs_shoppingcart_store_inventory(id) ON DELETE CASCADE,\r\n KEY orderid (orderid),\r\n FOREIGN KEY orderid_fk_1(orderid)\r\n REFERENCES module_vlabs_shoppingcart_order(id) ON DELETE CASCADE\r\n) ENGINE=InnoDB AUTO_INCREMENT=4167 DEFAULT CHARSET=utf8 COMMENT='This table will contain the order description';"); /* Referential constraints for module_vlabs_shoppingcart_order_summary */ eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_log` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `description` varchar(300) NOT NULL default '0',\r\n `date` datetime NOT NULL default '0000-00-00 00:00:00',\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table will contain the modification in the inventory';"); eF_executeQuery("CREATE TABLE `module_vlabs_shoppingcart_package_summary` (\r\n `id` mediumint(6) unsigned NOT NULL auto_increment,\r\n `packageid` mediumint(6) unsigned NOT NULL default '0',\r\n `itemid` mediumint(6) unsigned NOT NULL default '0',\r\n `quantity` bigint(10) unsigned NOT NULL default '0',\r\n `price` double unsigned NOT NULL default '0',\r\n PRIMARY KEY (`id`),\r\n KEY packageid (packageid),\r\n FOREIGN KEY packageid_fk_1(packageid)\r\n REFERENCES module_vlabs_shoppingcart_store_inventory(id) ON DELETE CASCADE,\r\n KEY itemid (itemid),\r\n FOREIGN KEY itemid_fk_2(itemid)\r\n REFERENCES module_vlabs_shoppingcart_store_inventory(id) ON DELETE CASCADE\r\n) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8 COMMENT='This table will contain the packages items';"); eF_ExecuteQuery("CREATE TABLE `module_vlabs_shoppingcart_preassignment` (\r\n `id` varchar(20) NOT NULL default '',\r\n `courseid` bigint(10) unsigned NOT NULL default '0',\r\n `itemid` mediumint(6) unsigned NOT NULL default '0',\r\n `quantity` bigint(10) unsigned NOT NULL default '0',\r\n `assignmentdate` datetime NOT NULL,\r\n `lastmodification` datetime NOT NULL,\r\n `active` blob NOT NULL,\r\n PRIMARY KEY (`id`),\r\n KEY itemid (itemid),\r\n FOREIGN KEY itemid_fk_3(itemid)\r\n REFERENCES module_vlabs_shoppingcart_store_inventory(id) ON DELETE CASCADE\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table will contain the assignments of items to courses';"); eF_ExecuteQuery("CREATE TABLE IF NOT EXISTS `module_vlabs_shoppingcart_dbadmin` (\r\n `id` int(11) NOT NULL,\r\n `module` varchar(15) NOT NULL,\r\n `description` varchar(30) NOT NULL,\r\n `moduleprefix` varchar(50) NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); /* jh problem with the ending apostrophy if (file_exists($dirname.'/'.$filename)){ $output = shell_exec('mysql -u root -ppassword -D efront <'.$dirname.'/'.$filename); //echo "mysqldump import output: " . $output; } */ $output = shell_exec('mysql -u ' . G_DBUSER . ' -p' . G_DBPASSWD . ' -D efront <' . G_ROOTPATH . 'www/modules/module_vlabs_shoppingcart_data.sql'); return true; }
} else { $result = array('success' => false, 'message' => "Error executing database operation"); } } else { $result = array('success' => false, 'message' => 'Package item cannot be deleted since package is being reference in existing orders'); } echo json_encode($result); } else { if ($action == "isPkgBillable") { if (isset($_POST['packageid'])) { $packageid = $_POST['packageid']; } else { $packageid = 0; } $sql = "SELECT billable FROM module_vlabs_shoppingcart_store_inventory WHERE id = " . $packageid; $result = eF_ExecuteQuery($sql); $result_billable = ""; foreach ($result as $r) { $result_billable = $r['billable']; } echo json_encode($result_billable == "1"); } else { if ($action == "changeStatus") { if (isset($_POST['packageid'])) { $packageid = $_POST['packageid']; } else { $packageid = 0; } $success = db_changePackageStatus($packageid); $response = array('success' => $success); echo json_encode($response);