<?php
defined('ABSPATH') || die();

require_once WLSM_PLUGIN_DIR_PATH . 'includes/helpers/WLSM_M_Class.php';

class WLSM_Class
{
	public static function fetch_classes()
	{
		// Check if the current user has the required capability.
		if (!current_user_can(WLSM_ADMIN_CAPABILITY)) {
			die();
		}

		global $wpdb;

		$page_url = WLSM_M_Class::get_page_url();

		// Create a prepared statement to prevent SQL injection.
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- fetch_query is built from safely prepared fragments.
		$query = WLSM_M_Class::fetch_query();

		$query_filter = $query;

		// Grouping.
		$group_by = ' ' . WLSM_M_Class::fetch_query_group_by();

		$query .= $group_by;
		$query_filter .= $group_by;

		// Searching.
		$condition = '';
		if (isset($_POST['search']['value']) && '' !== $_POST['search']['value']) {
			$search_value = sanitize_text_field($_POST['search']['value']);
			$condition .= $wpdb->prepare('(c.label LIKE %s)', '%' . $wpdb->esc_like($search_value) . '%');
			$query_filter .= (' HAVING ' . $condition);
		}


		// $columns = array('c.label');
		// if (esc_sql($_POST['order']) && esc_sql($columns[$_POST['order']['0']['column']])) {
		// 	$order_by = sanitize_text_field(esc_sql($columns[$_POST['order']['0']['column']]));
		// 	$order_dir = sanitize_text_field(esc_sql($_POST['order']['0']['dir']));

		// 	$query_filter .= $wpdb->prepare(' ORDER BY %s %s', $order_by, $order_dir);
		// } else {
		// 	$query_filter .= ' ORDER BY c.ID DESC';
		// }

		// Ordering.
		$columns = array('c.label');

		if (isset($_POST['order']) && isset($columns[$_POST['order']['0']['column']])) {
			$order_by = sanitize_text_field(esc_sql($columns[$_POST['order']['0']['column']]));
			$order_dir = sanitize_text_field(esc_sql($_POST['order']['0']['dir']));

			$query_filter .= $wpdb->prepare(' ORDER BY %s %s', $order_by, $order_dir);
		} else {
			$query_filter .= ' ORDER BY c.ID DESC';
		}


		// Limiting.
		$limit = '';
		if (-1 != $_POST['length']) {
			$start = absint(esc_sql($_POST['start']));
			$length = absint($_POST['length']);

			$limit = $wpdb->prepare(' LIMIT %d, %d', $start, $length);
		}

		// Total query.
		$rows_query = WLSM_M_Class::fetch_query_count();

		// Total rows count.
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- $rows_query is built from safely prepared fragments.
		$total_rows_count = $wpdb->get_var($rows_query);

		// Filtered rows count.
		if ($condition) {
			// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- $rows_query and $condition are built from safely prepared fragments.
			$filter_rows_count = $wpdb->get_var($rows_query . ' WHERE (' . $condition . ')');
		} else {
			$filter_rows_count = $total_rows_count;
		}

		// Filtered limit rows.
		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- $query_filter and $limit are built from safely prepared fragments.
		$filter_rows_limit = $wpdb->get_results($query_filter . $limit);

		$data = array();
		if (count($filter_rows_limit)) {
			foreach ($filter_rows_limit as $row) {
				// Table columns.
				// Escape the output to prevent XSS attacks.
				$data[] = array(
					esc_html(WLSM_M_Class::get_label_text($row->label)),
					'<a class="text-primary" href="' . esc_url($page_url . "&action=save&id=" . $row->ID) . '"><span class="dashicons dashicons-edit"></span></a>&nbsp;&nbsp;
					<a class="text-danger wlsm-delete-class" data-nonce="' . esc_attr(wp_create_nonce('delete-class-' . $row->ID)) . '" data-class="' . esc_attr($row->ID) . '" href="#" data-message-title="' . esc_attr__('Please Confirm!', 'school-management-system') . '" data-message-content="' . esc_attr__('This will delete all data associated with this class.', 'school-management-system') . '" data-cancel="' . esc_attr__('Cancel', 'school-management-system') . '" data-submit="' . esc_attr__('Confirm', 'school-management-system') . '"><span class="dashicons dashicons-trash"></span></a>'
				);
			}
		}

		$output = array(
			'draw' => intval(esc_sql($_POST['draw'])),
			'recordsTotal' => $total_rows_count,
			'recordsFiltered' => $filter_rows_count,
			'data' => $data,
		);

		// Return JSON-encoded output.
		echo json_encode($output);
		die;
	}

	public static function save()
	{
		if (!current_user_can(WLSM_ADMIN_CAPABILITY)) {
			die();
		}

		try {
			ob_start();
			global $wpdb;

			$class_id = isset($_POST['class_id']) ? absint($_POST['class_id']) : 0;

			if ($class_id) {
				if (!wp_verify_nonce($_POST['edit-class-' . $class_id], 'edit-class-' . $class_id)) {
					die();
				}
			} else {
				if (!wp_verify_nonce($_POST['add-class'], 'add-class')) {
					die();
				}
			}

			// Checks if class exists.
			if ($class_id) {
				$class = WLSM_M_Class::get_class($class_id);

				if (!$class) {
					throw new Exception(esc_html__('Class not found.', 'school-management-system'));
				}
			}

			$label = isset($_POST['label']) ? sanitize_text_field($_POST['label']) : '';

			// Start validation.
			$errors = array();

			if (empty($label)) {
				$errors['label'] = esc_html__('Please provide class name.', 'school-management-system');
			}

			if (strlen($label) > 191) {
				$errors['label'] = esc_html__('Maximum length cannot exceed 191 characters.', 'school-management-system');
			}

			// Checks if class already exists with this label.
			if ($class_id) {
				$class_exist = $wpdb->get_var($wpdb->prepare( 'SELECT COUNT(*) as count FROM %i as c WHERE c.label = %s AND c.ID != %d', WLSM_CLASSES, $label, $class_id ));
			} else {
				$class_exist = $wpdb->get_var($wpdb->prepare( 'SELECT COUNT(*) as count FROM %i as c WHERE c.label = %s', WLSM_CLASSES, $label ));
			}

			if ($class_exist) {
				$errors['label'] = esc_html__('Class already exists.', 'school-management-system');
			}
			// End validation.

		} catch (Exception $exception) {
			$buffer = ob_get_clean();
			if (!empty($buffer)) {
				$response = $buffer;
			} else {
				$response = $exception->getMessage();
			}
			wp_send_json_error($response);
		}

		if (count($errors) < 1) {
			try {
				$wpdb->query('BEGIN;');

				// Data to update or insert.
				$data = array(
					'label' => $label
				);

				// Checks if update or insert.
				if ($class_id) {
					$data['updated_at'] = current_time('mysql');

					$success = $wpdb->update(WLSM_CLASSES, $data, array('ID' => $class_id));
					$message = esc_html__('Class updated successfully.', 'school-management-system');
					$reset = false;
				} else {
					$success = $wpdb->insert(WLSM_CLASSES, $data);
					$message = esc_html__('Class added successfully.', 'school-management-system');
					$reset = true;
				}

				$buffer = ob_get_clean();
				if (!empty($buffer)) {
					throw new Exception($buffer);
				}

				if (false === $success) {
					throw new Exception($wpdb->last_error);
				}

				$wpdb->query('COMMIT;');

				wp_send_json_success(array('message' => $message, 'reset' => $reset));
			} catch (Exception $exception) {
				$wpdb->query('ROLLBACK;');
				wp_send_json_error($exception->getMessage());
			}
		}
		wp_send_json_error($errors);
	}

	public static function delete()
	{
		if (!current_user_can(WLSM_ADMIN_CAPABILITY)) {
			die();
		}

		try {
			ob_start();
			global $wpdb;

			$class_id = isset($_POST['class_id']) ? absint($_POST['class_id']) : 0;

			if (!wp_verify_nonce($_POST['delete-class-' . $class_id], 'delete-class-' . $class_id)) {
				die();
			}

			// Checks if class exists.
			$class = WLSM_M_Class::get_class($class_id);

			if (!$class) {
				throw new Exception(esc_html__('Class not found.', 'school-management-system'));
			}

		} catch (Exception $exception) {
			$buffer = ob_get_clean();
			if (!empty($buffer)) {
				$response = $buffer;
			} else {
				$response = $exception->getMessage();
			}
			wp_send_json_error($response);
		}

		try {
			$wpdb->query('BEGIN;');

			$success = $wpdb->delete(WLSM_CLASSES, array('ID' => $class_id));
			$message = esc_html__('Class deleted successfully.', 'school-management-system');

			$exception = ob_get_clean();
			if (!empty($exception)) {
				throw new Exception($exception);
			}

			if (false === $success) {
				throw new Exception($wpdb->last_error);
			}

			$wpdb->query('COMMIT;');

			wp_send_json_success(array('message' => $message));
		} catch (Exception $exception) {
			$wpdb->query('ROLLBACK;');
			wp_send_json_error($exception->getMessage());
		}
	}
}
