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(); } }
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(); } }