Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * Process the file, sent in the constructor.
- * Return: Array with 1 or false. false on error.
- */
- public function processFile() {
- global $wpdb;
- $tariffs = $this->loadedFile;
- $tableName = $wpdb->prefix."aranceles";
- if(empty($tariffs)){
- error_log("Problem transform or loading import file.");
- return;
- }
- $insertReturns = [];
- $wpdb->query( 'SET autocommit = 0;' );
- foreach ($tariffs as $row) {
- $insert = "INSERT INTO '$tableName'
- (internal_id, service_detail, particular_value, particular_non_business,
- fonasa_value, fonasa_non_business, isapre_value, isapre_non_business, med_value,
- pacakge_value, fonasa_code, category, subcategory)
- VALUES (%s, %s, %d, %d, %d, %d, %d, %d, %d, %d, %s, %s, %s)
- ON DUPLICATE KEY UPDATE service_detail=VALUES(service_detail),
- particular_value=VALUES(particular_value), particular_non_business=VALUES(particular_non_business), fonasa_value=VALUES(fonasa_value),
- fonasa_non_business=VALUES(fonasa_non_business), isapre_value=VALUES(isapre_value),
- isapre_non_business=VALUES(isapre_non_business), med_value=VALUES(med_value), pacakge_value=VALUES(pacakge_value),
- fonasa_code=VALUES(fonasa_code), category=VALUES(category), subcategory=VALUES(subcategory)";
- $insert = $wpdb->prepare($insert, row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12]);
- $insertReturns[] = $wpdb->query( $insert );
- }
- $wpdb->query( 'COMMIT;' );
- $wpdb->query( 'SET autocommit = 1;' );
- return $insertReturns;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement