aDriv4 website!

Linux server290.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
LiteSpeed
162.0.232.252

Insertapidata.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Insertapidata  extends CI_Controller {

public function __construct() {
        parent::__construct();
        // Load the model
        $this->load->model('custom_items_insert_data_api');
    }

public function fetch_and_insert() {
        
        $api_url = "https://panamfarma.com/wp-json/api_data_fetch/v1/api_data"; 
        /*fetch wordpress api data in prefix crm*/
        $response = file_get_contents($api_url);
        $products = json_decode($response, true);

/*In prefix crm fetch all data in table name tblitems_groups start code*/
        $this->db->select('id, note'); 
        $query = $this->db->get('tblitems_groups');
        $db_categories = $query->result_array();
        $categories = array();
        foreach ($db_categories as $category) {
            $categories[($category['note'])] = $category['id'];
        }

$this->db->select('unit_type_id, unit_name'); 
        $query = $this->db->get('tblware_unit_type');
        $db_unites = $query->result_array();
        $unites_data = array();
        foreach ($db_unites as $unites_d) {
            $unites_data[($unites_d['unit_name'])] = $unites_d['unit_type_id'];
        }

/*In prefix crm fetch all data in table name tblitems_groups End code*/

if ($products) {
            foreach ($products as $product) {

$category_name = ($product['category_name']); 
                 $group_id = isset($categories[$category_name]) ? $categories[$category_name] : null;

$unit_name = ($product['product_description_dosage']);
                 $unit_id = isset($unites_data[$unit_name]) ? $unites_data[$unit_name] : null;

$product_data = array(
                    'store_id' => $product['store_id'],
                    'product_id' => $product['product_id'],
                    'product_name' => $product['product_name'],
                    'product_image' => $product['product_image'],
                    'category_name' => $product['category_name'], /*last time update */
                    'special_instructions' => $product['special_instructions'],
                    'product_description_dosage' => $product['product_description_dosage'],
                    'price' => isset($product['price']) ? $product['price'] : 0, 
                    'purchase_price' => isset($product['price']) ? $product['price'] : 0, 
                    'commodity_code' => $product['product_ndc'],
                    'rate' => isset($product['price']) ? $product['price'] : 0, 
                    'can_be_sold' => 'can_be_sold',
                    'commodity_name' =>  $product['product_name'],
                    'can_be_purchased' =>'can_be_purchased',
                    'can_be_manufacturing' => 'can_be_manufacturing',
                    'can_be_inventory' => 'can_be_inventory',
                    'unit_id' => $unit_id,
                    'group_id' => $group_id,
                    'unit' => $unit_name, 
                    'commodity_type' => 0,
                    'warehouse_id' => 1,
                    'sub_group' => 0,
                    'origin' => 'USA',
                    'active' => 1 ,
                    'rate_currency_3' => '138.51'
                );

$this->custom_items_insert_data_api->insert_or_update_item($product_data);
            }

echo json_encode(array('status' => 'success', 'message' => 'Products inserted/updated successfully'));
        } else {
            echo json_encode(array('status' => 'error', 'message' => 'Failed to fetch data from API'));
        }
    }

/*    public function fetch_and_insert_with_category_data() {
        // API URL to fetch categories
        $api_url = 'https://panamfarma.com/wp-json/api_data_fetch/v1/categories';
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $api_url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        $response = curl_exec($ch);
        curl_close($ch);
        if ($response) {
            $categories = json_decode($response, true);
            foreach ($categories as $category) {
                $data = array(
                    'woo_commerec_cat_id' => $category['id'], 
                    'name' => $category['name'], 
                    'display' => 1, 
                    'note' => $category['name'], 
                );

$existing_category = $this->custom_items_insert_data_api->get_category_by_name($data['woo_commerec_cat_id']);

if ($existing_category) {
                    $this->custom_items_insert_data_api->update_category($existing_category->id, $data);
                } else {
                    $this->custom_items_insert_data_api->insert_category($data);
                }
            }

echo "Categories have been successfully inserted or updated in tblitems_groups.";
        } else {
            echo "Failed to fetch data from API.";
        }
    }
*/

public function fetch_and_insert_with_category_data() {
    $data = json_decode($this->input->raw_input_stream, true);
    if (empty($data['category_id']) || empty($data['category_data'])) {
        $this->output->set_status_header(400);
        echo json_encode(['error' => 'Category ID and data are required']);
        return;
    }

$prefix_cat_id = $data['prefix_cat_id'];

if(!empty($prefix_cat_id)){

$ID = $prefix_cat_id;
     $category_data = $data['category_data'];
     $existing_category = $this->custom_items_insert_data_api->get_category_by_prefix_cat_id($ID);
  
      if ($existing_category) {
            $update_result = $this->custom_items_insert_data_api->update_category($existing_category->id, $category_data);
            if ($update_result) {
                echo json_encode(['success' => 'Category updated successfully']);
            } else {
                echo json_encode(['error' => 'Failed to update category']);
            }
        } else {

$insert_result = $this->custom_items_insert_data_api->insert_category($category_data);
            if ($insert_result) {
                echo json_encode(['success' => 'Category inserted successfully']);
            } else {
                echo json_encode(['error' => 'Failed to insert category']);
            }
        }

}else{
 
            $woo_commerec_cat_id = $data['category_id']; 
            $category_data = $data['category_data'];
            $existing_category = $this->custom_items_insert_data_api->get_category_by_woo_commerec_cat_id($woo_commerec_cat_id);
            if ($existing_category) {
                $update_result = $this->custom_items_insert_data_api->update_category($existing_category->id, $category_data);
                if ($update_result) {
                    echo json_encode(['success' => 'Category updated successfully']);
                } else {
                    echo json_encode(['error' => 'Failed to update category']);
                }
            } else {
                // Insert new category
                $insert_result = $this->custom_items_insert_data_api->insert_category($category_data);
                if ($insert_result) {
                    echo json_encode(['success' => 'Category inserted successfully']);
                } else {
                    echo json_encode(['error' => 'Failed to insert category']);
                }
            }
        }
}

public function fetch_and_insert_unites_data() {
        $api_url = 'https://panamfarma.com/wp-json/api_data_fetch_data/v1/unites_fetch';
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $api_url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        $response = curl_exec($ch);
        curl_close($ch);
        if ($response) {
            $unites = json_decode($response, true);
            foreach ($unites as $unite) {
                $unit_name = $unite['unites'];
                $note = $unite['unites'];
                $this->custom_items_insert_data_api->insert_or_update_unit($unit_name, $note);
            }
            echo "Data successfully fetched and processed.";
        } else {
            echo "Failed to fetch data from API.";
        }
    }

public function woo_commerce_edit_and_insert_data() {
        $data = json_decode($this->input->raw_input_stream, true);

if (empty($data['product_id']) || empty($data['product_data'])) {
            $this->output->set_status_header(400);
            echo json_encode(['error' => 'Product ID and data are required']);
            return;
        }

$product_id = $data['product_id'];
        $product_data = $data['product_data'];

// Call model function to insert or update
        $result = $this->custom_items_insert_data_api->woo_edit_or_insert_product_with_api($product_id, $product_data);

if ($result) {
            echo json_encode(['success' => 'Product data updated successfully']);
        } else {
            $this->output->set_status_header(500);
            echo json_encode(['error' => 'Failed to update product data']);
        }
    }

public function woo_coomerce_product_cate_delete() {
    
        $data = json_decode($this->input->raw_input_stream, true);
        if (empty($data['category_data']['woo_commerec_cat_id'])) {
            $this->output->set_status_header(400);
            echo json_encode(['error' => 'Category Name is required']);
            return;
        }
         $woo_commerec_cat_id = $data['category_data']['woo_commerec_cat_id'];
        if ($this->custom_items_insert_data_api->delete_category_by_woocommerce_id($woo_commerec_cat_id)) {
            echo json_encode(['success' => 'Category deleted successfully']);
        } else {
            $this->output->set_status_header(500);
            echo json_encode(['error' => 'Failed to delete category']);
        }
    }

public function product_delete() {
            $product_id = $this->input->post('id');
             if (empty($product_id)) {
                $this->output->set_status_header(400); 
                echo json_encode(['error' => 'Product ID is required']);
                return;
            }

if ($this->custom_items_insert_data_api->delete_product_by_id($product_id)) {
                echo json_encode(['success' => 'Product deleted successfully']);
            } else {
                $this->output->set_status_header(500); 
                echo json_encode(['error' => 'Failed to delete product']);
            }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
..	dir	-	panaxpaw/panaxpaw	0755	2026-02-22 04:08:41
admin	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
customapi	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
customfilter	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
gateways	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
productsimport	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
productspdf	dir	-	panaxpaw/panaxpaw	0755	2025-09-02 04:24:22
.htaccess	text/plain	127 B	panaxpaw/panaxpaw	0444	2025-09-02 04:24:22
Authentication.php	text/x-php	14.94 KB	panaxpaw/panaxpaw	0644	2024-03-18 11:22:34
Check_emails.php	text/x-php	928 B	panaxpaw/panaxpaw	0644	2024-02-21 05:45:58
Clients.php	text/x-php	62.61 KB	panaxpaw/panaxpaw	0644	2024-02-19 02:37:12
Consent.php	text/x-php	3.81 KB	panaxpaw/panaxpaw	0644	2024-03-18 11:22:34
Contacts.php	text/x-php	8.08 KB	panaxpaw/panaxpaw	0644	2024-02-21 05:45:58
Contract.php	text/x-php	2.67 KB	panaxpaw/panaxpaw	0644	2024-03-18 11:22:34
Cron.php	text/x-php	801 B	panaxpaw/panaxpaw	0644	2022-05-23 06:30:20
Download.php	text/x-php	8.78 KB	panaxpaw/panaxpaw	0644	2024-02-21 05:45:58
Estimate.php	text/x-php	4.1 KB	panaxpaw/panaxpaw	0644	2025-01-24 09:33:04
Forms.php	text/x-php	46.85 KB	panaxpaw/panaxpaw	0644	2025-04-01 10:08:28
Insertapidata.php	text/x-php	10.35 KB	panaxpaw/panaxpaw	0644	2025-01-08 07:19:40
Invoice.php	text/x-php	3.42 KB	panaxpaw/panaxpaw	0644	2024-03-18 11:22:34
Knowledge_base.php	text/x-php	4.25 KB	panaxpaw/panaxpaw	0644	2024-03-18 11:22:34
Migration.php	text/x-php	7.58 KB	panaxpaw/panaxpaw	0644	2021-06-15 04:49:18
Privacy_policy.php	text/x-php	395 B	panaxpaw/panaxpaw	0644	2024-02-21 05:41:44
Proposal.php	text/x-php	4.65 KB	panaxpaw/panaxpaw	0644	2024-04-28 05:06:58
Subscription.php	text/x-php	13.58 KB	panaxpaw/panaxpaw	0644	2024-03-18 11:22:34
Terms_and_conditions.php	text/x-php	417 B	panaxpaw/panaxpaw	0644	2021-06-15 04:49:18
Verification.php	text/x-php	2.38 KB	panaxpaw/panaxpaw	0644	2021-06-15 04:49:18
customfilter.zip	application/zip	830 B	panaxpaw/panaxpaw	0644	2024-09-30 09:37:49
index.html	text/html	131 B	panaxpaw/panaxpaw	0644	2020-05-02 01:09:38

For more Private tool come to me!

https://t.me/aDriv4vz