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;
 }
Example #2
0
         } 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);