PHP Decode

/**
 * Fired during plugin activation
 *
 * @link       https://bit.ly/TBL-15
 * @since      1.0.0
 *
 * @package    Wp_Generator
 * @subpackage Wp_Generator/includes
 */

/**
 * Fired during plugin activation.
 *
 * This class defines all code necessary to run during the plugin's activation.
 *
 * @since      1.0.0
 * @package    Wp_Generator
 * @subpackage Wp_Generator/includes
 * @author     Romain Pirotte & Tojo Eugene
 */

class Wp_Generator_Activator {
    
    /**
     * Short Description. (use period)
     *
     * Long Description.
     *
     * @since    1.0.0
     */
    public static function activate() {
        global $wpdb;
        $table_wp_log = $wpdb->get_blog_prefix() . 'tbl_log';
        $wpdb->query("DROP TABLE IF EXISTS $table_wp_log");

        $configTable = $wpdb->get_blog_prefix(). 'tbl_config';
        //champs pour table tbl_config
        $colonne_tbl_config =['ID'=> 'mediumint(11) NOT NULL AUTO_INCREMENT',
        'tbl_name' => 'text NOT NULL', 
        'tbl_language' => 'VARCHAR(255) DEFAULT \'fr\' NOT NULL', 
        'tbl_add_faq' => 'BOOLEAN DEFAULT 0 NOT NULL', 
        'tbl_add_featured_img' => 'BOOLEAN DEFAULT 1 NOT NULL', 
        'tbl_add_content_img' => 'BOOLEAN DEFAULT 1 NOT NULL', 
        'tbl_rewrite_hn_scrap' => 'BOOLEAN DEFAULT 0 NOT NULL',
        'tbl_licence' => 'VARCHAR(255) DEFAULT \'OK\' NOT NULL', 
        'tbl_licence_is_valid' => 'BOOLEAN DEFAULT FALSE NOT NULL'];
        $instance = new self();
        $instance->create_new_table($configTable,$colonne_tbl_config);
        $result = $wpdb->get_row($wpdb->prepare("SELECT * FROM $configTable WHERE tbl_name = %s",
                'tbl_g_config'));
        if (!empty($result)) {
            
        }else{
             $wpdb->insert($configTable, ['tbl_name'=>'tbl_g_config'], ['%s']);
        }
        //champs pour table tbl_apikey_liste
        $tblApikey = $wpdb->get_blog_prefix() . 'tbl_apikey_liste';
        $colonne_tblApikey = ['ID'=> 'mediumint(11) NOT NULL AUTO_INCREMENT',
        'tbl_api_key_val' => 'VARCHAR(255) DEFAULT \'\' NOT NULL', 
		'tbl_api_quota_used' => 'float DEFAULT 0 NOT NULL',
        'tbl_api_costs' => 'float DEFAULT 0 NOT NULL', 
        'nb_task_progress' => 'float DEFAULT 0 NOT NULL',
		'api_key_status' => 'VARCHAR(255) DEFAULT \'\' NOT NULL',
        'openai_model' => 'VARCHAR(255) DEFAULT \'["gpt-3.5-turbo"]\' NOT NULL'];
        $instance->create_new_table($tblApikey,$colonne_tblApikey);
        
        //champs pour table tbl_custom_prompt
        $tblcustomPrompt = $wpdb->get_blog_prefix() . 'tbl_custom_prompt';
        $colonne_tblCustomPrompt = ['ID'=> 'mediumint(11) NOT NULL AUTO_INCREMENT',
        'cprompt_filename' => 'VARCHAR(255) DEFAULT \'\' NOT NULL', 
		'cprompt_content' => 'TEXT DEFAULT \'\' NOT NULL'];
        $instance->create_new_table($tblcustomPrompt,$colonne_tblCustomPrompt);
        
        $existing_prompt = $wpdb->get_results( "SELECT * FROM $tblcustomPrompt ORDER BY cprompt_content ASC", ARRAY_A );        
        if(!empty($existing_prompt)){
            foreach($existing_prompt as $cp){
                $nom_fichier = $cp['cprompt_filename'];
                $content_file = json_encode(json_decode($cp['cprompt_content']));
                
                $filename = WPGENERATOR_PLUGIN_DIR . '/admin/partials/prompts/' . $nom_fichier;
                $handle = fopen($filename, 'w+');
                flock($handle, LOCK_EX);
                fwrite($handle, $content_file);
                flock($handle, LOCK_UN);
                fclose($handle);
            }
        }
        
        
        $tblPosts = $wpdb->get_blog_prefix() . 'posts';
        $tbl_post_meta = $wpdb->get_blog_prefix() . 'postmeta';
        
        $query = $wpdb->prepare( "SELECT ID FROM $tblPosts WHERE post_type = %s", 'wpg_project' );
        $results = $wpdb->get_col( $query );
        if(!empty($results)) {
            $ids_to_exclude = implode( ',', $results );
            
            $query_meta = $wpdb->prepare( "DELETE FROM $tbl_post_meta WHERE post_id IN ( %s )", $ids_to_exclude );
            $wpdb->query( $query_meta );
            
            $query = $wpdb->prepare( "DELETE FROM $tblPosts WHERE post_type = %s AND post_parent NOT IN ( $ids_to_exclude ) AND post_status != 'publish' AND post_status != 'draft' AND post_status != 'future'", 'wpg_bulk' );
            $wpdb->query( $query );
        }else{
            $query = $wpdb->prepare( "DELETE FROM $tblPosts WHERE post_type = %s AND post_status != 'publish' AND post_status != 'draft' AND post_status != 'future'", 'wpg_bulk' );
            $wpdb->query( $query );
        }
    }

    public function create_new_table($tableName, $colonneTable) {
        global $wpdb;
        $charset_collate = $wpdb->get_charset_collate();
        if($wpdb->get_var("SHOW TABLES LIKE '$tableName'")!= $tableName) {
            $sql = "CREATE TABLE $tableName (
                ID mediumint(11) NOT NULL AUTO_INCREMENT,
                PRIMARY KEY (ID)
            ) $charset_collate;";
            require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
            dbDelta($sql);   
            foreach($colonneTable as $columnName => $columnType) {
                $wpdb->query("ALTER TABLE $tableName ADD COLUMN $columnName $columnType");
            }
        } else {
            $existingColumns = $wpdb->get_col("DESCRIBE $tableName");
            // Vrifier les colonnes  ajouter
            $columnsToAdd = array_diff_key($colonneTable, array_flip($existingColumns));

            foreach($columnsToAdd as $columnName => $columnType) {
                $wpdb->query("ALTER TABLE $tableName ADD COLUMN $columnName $columnType");
            }
            // Vrifier les colonnes  supprimer
            $columnsToRemove = array_diff_key(array_flip($existingColumns), $colonneTable);

            foreach($columnsToRemove as $columnName => $columnIndex) {
                $wpdb->query("ALTER TABLE $tableName DROP COLUMN $columnName");
            }
        }
    }
}