<?php
namespace Frontend_Admin\Admin;

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly
}
if( ! class_exists( 'Frontend_Admin\Admin\Plans_Crud' ) ) :

	class Plans_Crud{
        public function create_plans() {
			global $wpdb;
			$charset_collate = $wpdb->get_charset_collate();
			$table_name = $wpdb->prefix . 'fea_plans';
			$sql = "CREATE TABLE $table_name (
				id mediumint(9) NOT NULL AUTO_INCREMENT,
				created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
				expires_after text NOT NULL,
				title text NOT NULL,
				slug text NOT NULL,
				description text NULL,
				pricing int NOT NULL,
				currency text NOT NULL,
				plan_value longtext NULL,
				plan_parent int NOT NULL,
				menu_order int NOT NULL,
				UNIQUE KEY id (id)
			) $charset_collate;";

			require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
            maybe_create_table( $table_name, $sql );
		}

		public function insert_plan( $args = [] ){
			if( empty( $args['created_at'] ) ){
				$args['created_at'] = current_time( 'mysql' );
			}
	
			if( empty( $args['title'] ) ){
				$args['title'] = '(no name)';
			}

			if( empty( $args['slug'] ) && '(no name)' !== $args['title'] ){
				$args['slug'] = sanitize_title( $args['title'] );
			}

			if( empty( $args['expires_after'] ) ){
				$args['expires_after'] = 'never';
			}

			if( empty( $args['pricing'] ) ){
				$args['pricing'] = 0;
			}

			if( empty( $args['currency'] ) ){
				$args['currency'] = 'USD';
			}

			if( empty( $args['plan_parent'] ) ){
				$args['plan_parent'] = 0;
			}

			if( empty( $args['menu_order'] ) ){
				$args['menu_order'] = 0;
			}

			global $wpdb;
			$wpdb->insert( $wpdb->prefix . 'fea_plans', $args );
			return $wpdb->insert_id;
		}

		public function update_plan( $id, $args ){
			global $wpdb;
			$wpdb->update( 
				$wpdb->prefix . 'fea_plans', 
				$args,		
				array( 'id' => $id )			
			);
		}


		public function get_plan( $id = 0 ){
			if( ! $id ) return $id;
			
			global $wpdb;
			$plan = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}fea_plans WHERE id = %d", $id ) );

            if( $plan->id == $id ) return $plan;

            return false;
		}

		/**
		 * Retrieve plans data from the database
		 *
		 * @param array $args query arguments
		 *
		 * @return mixed
		 */
		public static function get_plans( $args = array() ) {
			global $wpdb;

			$args = feadmin_parse_args( $args, array(
				'per_page' => 20,
				'current_page' => 1,
				'orderby' => 'created_at',
				'order' => 'DESC',
			) );

			$sql = "SELECT * FROM {$wpdb->prefix}fea_plans";

			if( ! empty( $_REQUEST['s'] ) ){
				$value = $_REQUEST['s'] . '%';
				$sql .= $wpdb->prepare( ' WHERE title LIKE %s', $value );
			}

			$allowed_orderby = [ 'created_at', 'title' ]; // Modify this list to match your DB columns
			$allowed_order   = [ 'ASC', 'DESC' ];

			$orderby = in_array( $args['orderby'], $allowed_orderby, true ) ? $args['orderby'] : 'created_at';
			$order   = in_array( $args['order'], $allowed_order, true ) ? $args['order'] : 'DESC';

			$sql .= " ORDER BY `$orderby` $order";


			$sql .= $wpdb->prepare( " LIMIT %d", $args['per_page'] );
			$sql .= $wpdb->prepare( " OFFSET %d", ( $args['current_page'] - 1 ) * $args['per_page'] );	


			$result = $wpdb->get_results( $sql, 'ARRAY_A' );

			return $result;
		}

		/**
		 * Returns the count of records in the database.
		 *
		 * @return null|string
		 */
		public static function record_count() {
			global $wpdb;

			$sql = "SELECT COUNT(*) FROM {$wpdb->prefix}fea_plans";

			return $wpdb->get_var( $sql );
		}

		public function ajax_delete_plan(){
			// validate
			if ( ! feadmin_verify_ajax() ) {
				die();
			}

			if( empty( $_POST['plan'] ) ) wp_send_json_error( __( 'No plan found', 'frontend-admin' ) );

			$plan_id = intval( $_POST['plan'] );

			$deleted = $this->delete_plan( $plan_id );

			if( 'success' == $deleted ) wp_send_json_success();

			wp_send_json_error( __( 'Could not delete plan.', 'frontend-admin' ) );
		}
		public function delete_plan( $id = 0 ){
			if( $id == 0 ) return $id;
			global $wpdb;
			$wpdb->delete( $wpdb->prefix.'fea_plans', array( 'id' => $id ) );
			return 'success';
		}

        public function plans_page_options(){
			if( isset( $_REQUEST['page'] ) && $_REQUEST['page'] == 'fea-plans' ){
				$option = 'per_page';
				$args   = [
					'label'   => 'Plans',
					'default' => 20,
					'option'  => 'plans_per_page'
				];
				add_screen_option( $option, $args );
			}
		}	
		function set_plans_per_page($status, $option, $value) {
			if ( 'plans_per_page' == $option ) return $value;
            return $status;
		}
        public function plans_list(){
            global $fa_plans_page;
            $fa_plans_page = add_submenu_page( 'fea-settings', __( 'Plans', 'frontend-admin' ), __( 'Plans', 'frontend-admin' ), 'manage_options', 'frontend-admin-plans', [ $this, 'admin_plans_page'], 82 );
            add_action( "load-$fa_plans_page", array( $this, 'plans_page_options' ) );
        }

		public function get_form( $plan_id ) {
			if ( is_numeric( $plan_id ) ) {
				$plan = $this->get_plan( intval( $plan_id ) );
				if ( ! $plan ) {
					esc_html_e( 'Plan not found. Did you erase it?', 'frontend-admin' );
					return false;
				}
			}


			if ( 'add_item' == $plan_id ) {
				$submit_value    = __( 'Create Plan', 'frontend-admin' );
				$success_message = __( 'Plan has been created successfully.', 'frontend-admin' );
				$update          = true;
				$defaults = [
					'title' => __( 'Basic', 'frontend-admin' ),
					'expires_after' => 'never',
					'pricing' => 1,
					'currency' => 'USD',
					'plan_value' => [
						
					]
				];
			} else {
				$submit_value    = __( 'Update', 'frontend-admin' );
				$success_message = __( 'Plan has been updated successfully.', 'frontend-admin' );
				$defaults = [
					'title' => $plan->title,
					'expires_after' => $plan->expires_after,
					'pricing' => $plan->pricing,
					'currency' => $plan->currency,
				];
			}

			if( function_exists( 'feadmin_get_currencies' ) ){	
				$currencies = feadmin_get_currencies();
			}else{
				$currencies = [];
			}		

			$form = array(
				'id'                  => 'plan_' . $plan_id,
				'submit_value'        => $submit_value,
				'kses'                => 0,
				'no_cookies'          => 1,
				'no_record'           => 1,
				'ajax_submit'         => 1,
				'update_message'      => $success_message,
				'show_update_message' => 1,
				'custom_fields_save'  => 'plan', 
				'plan_id'			  => $plan_id,	
				'default_submit_button' => 1,			  
				'fields' 	  => [
					'title' => array(
						'name'               => 'title',
						'key'               => 'title',
						'label'             => __( 'Title', 'frontend-admin' ),
						'type'              => 'text',
						'instructions'      => '',
						'default_value'     => $defaults['title'],
					),
					/* 'slug' => array(
						'name'               => 'slug',
						'key'               => 'slug',
						'label'             => __( 'Slug', 'frontend-admin' ),
						'type'              => 'text',
						'instructions'      => '',
						'default_value'     => sanitize_title( $defaults['title'] ),
						'wrapper'     		=> array(
							'class' => 'post-slug-field',
						),
					), */
					'expires_after' => array(
						'name'              => 'expires_after',
						'key'              => 'expires_after',
						'label'             => __( 'Expiration', 'frontend-admin' ),
						'type'              => 'select',
						'choices'			=> [
							'never' => __( 'Never', 'frontend-admin' ),
							'week' => __( 'Week', 'frontend-admin' ),
							'month' => __( 'Month', 'frontend-admin' ),
							'year' => __( 'Year', 'frontend-admin' ),
						],
						'return_format'		=> 'value',
						'instructions'      => '',
						'default_value'     => $defaults['expires_after'],
						'multiple'	=> 0
					),
					'pricing' => array(
						'name'               => 'pricing',
						'key'               => 'pricing',
						'label'             => __( 'Price', 'frontend-admin' ),
						'type'              => 'number',
						'instructions'      => '',
						'min'    			=> 1,
						'default_value'     => $defaults['pricing'],
					),
					'currency' => array(
						'name'               => 'currency',
						'key'               => 'currency',
						'label'             => __( 'Currency', 'frontend-admin' ),
						'type'              => 'select',
						'choices'			=> $currencies,
						'return_format'		=> 'value',
						'instructions'      => '',
						'default_value'     => $defaults['currency'],
						'multiple'	=> 0
					),
				],
			);

			global $ajax_render_form;
			if( $ajax_render_form ) {
				$form['ajax_submit'] = 'plan_form';
				$form['close_modal'] = 1;
			}

			return $form;
		}

        public function admin_plans_page(){ 
			require_once( 'list.php');
			$option = 'per_page';
			$args   = [
				'label'   => 'Plans',
				'default' => 20,
				'option'  => 'plans_per_page'
			];

			add_screen_option( $option, $args );

			?>
				<h2><?php echo __( 'Plans', 'frontend-admin' ) ?></h2>
				<a href="?page=frontend-admin-plans&action=add-new" type="button" class="button add-plan"><?php esc_html_e( 'Add New Plan', 'frontend-admin' ); ?></a>

				<?php
				fea_instance()->plans_list->prepare_items();
				fea_instance()->plans_list->display();
		}

		function save_plan( $form ){
			if ( empty( $form['plan_id'] ) || empty( $form['record']['fields']['plan'] ) ) {
				return $form;
			}

			$plan_args = [];
			foreach( $form['record']['fields']['plan'] as $key => $field ){
				$plan_args[$key] = $field['_input'];
			}

			$response = array(
				'modal' => true,
				'plan' => $plan_args,
				'form_element' => 'plan',
			);

			if( is_numeric( $form['plan_id'] ) ){
				$this->update_plan( $form['plan_id'], $plan_args );
				$response['plan']['id'] = $form['plan_id'];
			}else{
				$response['new'] = true;
				$response['plan']['id'] = $this->insert_plan( $plan_args );
			}			


			wp_send_json_success( $response );

		}

		public function render_form( $args ) {
			if ( 'plan' != $args['data_type'] ) return;
				
			$form = $this->get_form( sanitize_text_field( $args['form_action'] ) );
			
			if ( $form ) {
				fea_instance()->form_display->render_form( $form );
			}
			die();
		}
       
        public function __construct() {
            $this->create_plans();	

			add_action( 'frontend_admin/form/on_submit', [ $this, 'save_plan' ] );
			add_action( 'wp_ajax_frontend_admin/plans/delete', [ $this, 'ajax_delete_plan'] );
			add_action( 'frontend_admin/ajax_add_form', array( $this, 'render_form' ) );
			add_filter( 'frontend_admin/forms/get_form', function( $form, $key ){
				if( ! $key ) return $form;
				$key = explode( 'plan_', $key );

				if( isset( $key[1] ) ) return $this->get_form( $key[1] );

				return $form;
			}, 10, 2 );

          // add_action( 'admin_menu', array( $this, 'plans_list' ), 20 );	
		//	add_filter( 'set-screen-option', array( $this, 'set_plans_per_page' ), 11, 3 );
        }
    }
    fea_instance()->plans_handler = new Plans_Crud;

endif;