Exemplo n.º 1
0
 public function import()
 {
     $orderTable = new Sp4kTablesBase('#__sp4k_order_items');
     $parents = $orderTable->filter();
     foreach ($parents as $parent) {
         $accountTable = new Sp4kTablesBase('#__sp4k_account_items');
         $accountTable->save([]);
         $parent->account_id = $accountTable->id;
         $orderTable->bind($parent);
         $orderTable->store();
     }
 }
Exemplo n.º 2
0
 public function import()
 {
     $sugarTableConnection = new mysqli(".", "root", "2bornot2b", "admin_mem99");
     if (!$sugarTableConnection) {
         $this->error = 'could not connect to db.';
     }
     $selectSugarVenuesTableSql = ' SELECT * FROM s4ks_location';
     $resource = mysqli_query($sugarTableConnection, $selectSugarVenuesTableSql);
     while ($row = $resource->fetch_assoc()) {
         $newVenue['created'] = strtotime($row['date_entered']);
         $newVenue['created_by'] = 0;
         $newVenue['title'] = $row['name'];
         $newVenue['description'] = $row['description'];
         $newVenue['status'] = $row['deleted'];
         $newVenue['bookable'] = 1;
         $newVenue['capacity'] = $row['capacity'];
         $newVenue['website'] = $row['website'];
         $newVenue['address_shipping_street1'] = $row['shipping_address_street1'];
         $newVenue['address_shipping_street2'] = $row['shipping_address_street2'];
         $newVenue['address_shipping_city'] = $row['shipping_address_city'];
         $newVenue['address_shipping_state'] = $row['shipping_address_state'];
         $newVenue['address_shipping_postalcode'] = $row['shipping_address_postalcode'];
         $newVenue['address_shipping_country'] = $row['shipping_address_country'];
         $newVenue['address_billing_street1'] = $row['billing_address_street1'];
         $newVenue['address_billing_street2'] = $row['billing_address_street2'];
         $newVenue['address_billing_city'] = $row['billing_address_city'];
         $newVenue['address_billing_state'] = $row['billing_address_state'];
         $newVenue['address_billing_postalcode'] = $row['billing_address_postalcode'];
         $newVenue['address_billing_country'] = $row['billing_address_country'];
         $newVenue['phone'] = $row['phone_office'];
         $newVenue['sugar_assigned_user'] = $row['assigned_user_id'];
         $newVenue['sugar_created_by'] = $row['created_by'];
         $newVenue['sugar_location_id'] = $row['id'];
         $venues[] = $newVenue;
     }
     foreach ($venues as $venue) {
         $venueTable = new Sp4kTablesBase('#__sp4k_venue_items');
         $venueTable->bind($venue);
         $venueTable->store();
     }
 }