تست کد PHP افزونه

1<?php2/**3 * Plugin Name: مخزن DVD نورترازان معین4 * Description: سیستم مدیریت ارسال پکیج های DVD برای مشتریان5 * Version: 1.4.06 * Author: Ahmadreza Karimi7 */89// جلوگیری از دسترسی مستقیم10defined('ABSPATH') || exit;1112/**13 * کلاس اصلی افزونه14 */15class ak4w8DVD_Makhzan {16    17    private $table_name;18    19    public function __construct() {20        global $wpdb;21        $this->table_name = $wpdb->prefix . 'makhzan_dvd';22        23        add_action('init', array($this, 'akdvd_init'));24        add_action('admin_menu', array($this, 'akdvd_add_admin_menu'));25        add_action('add_meta_boxes', array($this, 'akdvd_add_metabox'));26        add_action('wp_ajax_akdvd_send_to_dvd_store', array($this, 'akdvd_handle_ajax_send_to_dvd'));27        add_action('wp_ajax_akdvd_get_request_details', array($this, 'akdvd_handle_ajax_get_request_details'));28        add_action('wp_ajax_akdvd_update_request_status', array($this, 'akdvd_handle_ajax_update_status'));29        add_action('wp_ajax_akdvd_search_requests', array($this, 'akdvd_handle_ajax_search_requests'));30        add_action('wp_ajax_akdvd_filter_requests', array($this, 'akdvd_handle_ajax_filter_requests'));31        add_action('wp_ajax_akdvd_get_user_display_name', array($this, 'akdvd_handle_ajax_get_user_display_name'));        add_action('wp_ajax_akdvd_delete_status_file', array($this, 'akdvd_handle_ajax_delete_status_file'));32    }33    34    /**35     * مقداردهی اولیه36     */37    public function akdvd_init() {38        // ثبت سطح دسترسی39        $role = get_role('administrator');40        if ($role) {41            $role->add_cap('can_enter_makhzan_dvd');42        }43        44        // بارگذاری فایل‌های استایل و اسکریپت45        add_action('admin_enqueue_scripts', array($this, 'akdvd_enqueue_assets'));46    }47    48    /**49     * بارگذاری فایل‌های CSS و JS50     */51    public function akdvd_enqueue_assets($hook) {52        if ($hook == 'post.php' || $hook == 'post-new.php') {53            wp_enqueue_script('akarimi-makhzan-dvd-js', plugin_dir_url(__FILE__) . 'assets/js/script.js', array('jquery'), '1.4.0', true);54            wp_localize_script('akarimi-makhzan-dvd-js', 'ak_ajax_obj', array(55                'ajax_url' => admin_url('admin-ajax.php'),56                'nonce' => wp_create_nonce('ak_makhzan_nonce')57            ));58        }59        60        if ($hook == 'toplevel_page_akarimi-makhzan-dvd') {61            wp_enqueue_style('akarimi-makhzan-dvd-css', plugin_dir_url(__FILE__) . 'assets/css/style.css', array(), '1.4.0');62            wp_enqueue_script('akarimi-makhzan-dvd-panel-js', plugin_dir_url(__FILE__) . 'assets/js/panel.js', array('jquery'), '1.4.0', true);63            wp_enqueue_script('lucide-icons', plugin_dir_url(__FILE__) . 'assets/js/lucide.js', array('jquery'), '1.4.0', true);64            65            wp_localize_script('akarimi-makhzan-dvd-panel-js', 'ak_panel_ajax_obj', array(66                'ajax_url' => admin_url('admin-ajax.php'),67                'nonce' => wp_create_nonce('ak_makhzan_panel_nonce')68            ));69        }70    }71    72    /**73     * اضافه کردن منو به پنل مدیریت74     */75    public function akdvd_add_admin_menu() {76        if (current_user_can('can_enter_makhzan_dvd')) {77            add_menu_page(78                'مخزن DVD',79                'مخزن DVD',80                'can_enter_makhzan_dvd',81                'akarimi-makhzan-dvd',82                array($this, 'akdvd_render_admin_page'),83                'dashicons-database',84                3085            );86        }87    }88    89    /**90     * رندر صفحه ادمین91     */92    public function akdvd_render_admin_page() {93        include_once plugin_dir_path(__FILE__) . 'admin-page.php';94    }95    96    /**97     * اضافه کردن متاباکس به پست تایپ vosooli98     */99    /**100 * اضافه کردن متاباکس به پست تایپ vosooli101 */102public function akdvd_add_metabox() {103    if (get_post_type() === 'vosooli' && current_user_can('can_enter_makhzan_dvd')) {104        add_meta_box(105            'ak_send_to_dvd_store',106            'ارسال به مخزن DVD',107            array($this, 'akdvd_render_metabox'),108            'vosooli',109            'side',110            'default'111        );112    }113}114115/**116 * رندر متاباکس117 */118public function akdvd_render_metabox($post) {119    $has_sent = get_post_meta($post->ID, '_dvd_store_sent', true);120    121    echo '<style>122    #ak-send-to-dvd-btn {123        width: 100%;124        background: linear-gradient(135deg, #2563eb, #0ea5e9);125        color: white;126        border: none;127        padding: 12px 16px;128        border-radius: 12px;129        cursor: pointer;130        font-size: 14px;131        font-weight: 500;132        transition: all 0.3s ease;133        margin-bottom: 10px;134    }135    #ak-send-to-dvd-btn:hover {136        transform: translateY(-1px);137        box-shadow: 0 5px 15px rgba(37, 99, 235, 0.3);138    }139    #ak-send-to-dvd-btn:disabled {140        opacity: 0.6;141        cursor: not-allowed;142        transform: none;143        box-shadow: none;144    }145    #ak-loading-spinner {146        display: flex;147        justify-content: center;148        align-items: center;149        padding: 10px 0;150    }151    .ak-loading-dot {152        display: inline-block;153        width: 8px;154        height: 8px;155        border-radius: 50%;156        background: #2563eb;157        margin: 0 2px;158        animation: loading-pulse 1.4s infinite ease-in-out both;159    }160    .ak-loading-dot:nth-child(1) { animation-delay: -0.32s; }161    .ak-loading-dot:nth-child(2) { animation-delay: -0.16s; }162    @keyframes loading-pulse {163        0%, 80%, 100% { transform: scale(0); }164        40% { transform: scale(1.0); }165    }166    .ak-sent-info {167        color: green;168        font-size: 12px;169        margin-top: 10px;170        line-height: 1.4;171    }172    </style>';173    174    echo '<div id="ak-send-to-dvd-container">';175    if (!$has_sent) {176        echo '<button type="button" id="ak-send-to-dvd-btn" class="button">ارسال به مخزن DVD</button>';177        echo '<div id="ak-loading-spinner" style="display:none;">';178        echo '<span class="ak-loading-dot"></span><span class="ak-loading-dot"></span><span class="ak-loading-dot"></span>';179        echo '</div>';180    } else {181        $sent_info = get_post_meta($post->ID, '_dvd_store_sent_info', true);182        if ($sent_info) {183            $info = maybe_unserialize($sent_info);184            $jdate = akdvd_jdate('Y/m/d H:i:s', strtotime($info['date']));185            echo '<p class="ak-sent-info">ثبت در '. $jdate .' توسط '. $info['user'].'</p>';186        }187    }188    echo '</div>';189    190    echo '<script type="text/javascript">191    jQuery(document).ready(function($) {192        $("#ak-send-to-dvd-btn").click(function() {193            var btn = $(this);194            var spinner = $("#ak-loading-spinner");195            196            btn.prop("disabled", true).text("در حال ارسال...");197            spinner.show();198            199            $.ajax({200                url: ak_ajax_obj.ajax_url,201                type: "POST",202                data: {203                    action: "akdvd_send_to_dvd_store",204                    post_id: ' . $post->ID . ',205                    nonce: ak_ajax_obj.nonce206                },207                success: function(response) {208                    if(response.success) {209                        btn.hide();210                        spinner.hide();211                        $("#ak-send-to-dvd-container").append('<p class="ak-sent-info">' + response.data.message + '</p>');212                    } else {213                        alert(response.data.message);214                        btn.prop("disabled", false).text("ارسال به مخزن DVD");215                        spinner.hide();216                    }217                },218                error: function() {219                    alert("خطا در اتصال به سرور");220                    btn.prop("disabled", false).text("ارسال به مخزن DVD");221                    spinner.hide();222                }223            });224        });225    });226    </script>';227}228229    230    /**231     * هندلر AJAX برای ارسال به مخزن DVD232     */233    /**234 * هندلر AJAX برای ارسال به مخزن DVD235 */236public function akdvd_handle_ajax_send_to_dvd() {237    check_ajax_referer('ak_makhzan_nonce', 'nonce');238    239    if (!current_user_can('can_enter_makhzan_dvd')) {240        wp_die('دسترسی غیرمجاز');241    }242    243    $post_id = intval($_POST['post_id']);244    245    if (!$post_id) {246        wp_send_json_error(array('message' => 'پست معتبر نیست'));247    }248    249    // چک کردن وجود متا قبلی250    if (get_post_meta($post_id, '_dvd_store_sent', true)) {251        wp_send_json_error(array('message' => 'قبلاً در مخزن ثبت شده است'));252    }253    254    // گرفتن اطلاعات از پست وابسته255    $parvande_id = get_post_meta($post_id, 'parvande_id_invosolli', true);256    257    if (!$parvande_id) {258        wp_send_json_error(array('message' => 'شماره پرونده یافت نشد'));259    }260    261    // گرفتن اطلاعات از پرونده262    $customer_data = array(263        'fullname' => get_post_meta($parvande_id, 'parvandeh_fullname', true),264        'id_number' => get_post_meta($parvande_id, 'parvandeh_idnumber', true),265        'phone' => get_post_meta($parvande_id, 'parvandeh_phone', true),266        'address' => get_post_meta($parvande_id, 'parvandeh_address', true),267        'postal_code' => get_post_meta($parvande_id, 'parvandeh_postalcode', true),268        'job' => get_post_meta($parvande_id, 'parvandeh_jobb', true)269    );270    271    // گرفتن اطلاعات از پست فعلی272    $order_data = array(273        'amount' => get_post_meta($post_id, 'vosooli_mablaq', true),274        'date' => get_post_meta($post_id, 'vosooli_taarikh', true)275    );276    277    // تبدیل تاریخ جلالی به میلادی278    $greg_date = '';279    if (function_exists('akdvd_gregdate')) {280        $greg_date = akdvd_gregdate('Y-m-d H:i:s', $order_data['date'] . ' 00:00:00');281    } else {282        $greg_date = date('Y-m-d H:i:s');283    }284    285    // ذخیره در دیتابیس286    global $wpdb;287    288    $result = $wpdb->insert(289        $this->table_name,290        array(291            'customer_name' => sanitize_text_field($customer_data['fullname']),292            'customer_national_id' => sanitize_text_field($customer_data['id_number']),293            'customer_phone' => sanitize_text_field($customer_data['phone']),294            'customer_address' => sanitize_textarea_field($customer_data['address']),295            'customer_postal_code' => sanitize_text_field($customer_data['postal_code']),296            'customer_job' => sanitize_text_field($customer_data['job']),297            'order_amount' => floatval($order_data['amount']),298            'order_date' => $greg_date,299            'status' => 'pending',300            'submitted_by' => get_current_user_id(),301            'submitted_at' => current_time('mysql'),302            'status_updated_at' => current_time('mysql')303        ),304        array(305            '%s', '%s', '%s', '%s', '%s', '%s', '%f', '%s', '%s', '%d', '%s', '%s'306        )307    );308    309    if ($result !== false) {310        // ذخیره متا در پست فعلی311        update_post_meta($post_id, '_dvd_store_sent', 1);312        $sent_info = array(313            'date' => current_time('Y/m/d H:i:s'),314            'user' => wp_get_current_user()->display_name315        );316        update_post_meta($post_id, '_dvd_store_sent_info', serialize($sent_info));317        318        wp_send_json_success(array(319            'message' => 'ثبت در '. akdvd_jdate('Y/m/d H:i:s') .' توسط '. wp_get_current_user()->display_name320        ));321    } else {322        wp_send_json_error(array('message' => 'خطا در ذخیره اطلاعات'));323    }324}325326    327/**328 * هندلر AJAX برای گرفتن جزئیات درخواست329 */330public function akdvd_handle_ajax_get_request_details() {331    check_ajax_referer('ak_makhzan_panel_nonce', 'nonce');332    333    if (!current_user_can('can_enter_makhzan_dvd')) {334        wp_die('دسترسی غیرمجاز');335    }336    337    $request_id = intval($_POST['request_id']);338    339    global $wpdb;340    $request = $wpdb->get_row($wpdb->prepare(341        "SELECT * FROM {$this->table_name} WHERE id = %d",342        $request_id343    ), ARRAY_A);344    345    if ($request) {346        // تبدیل تاریخ‌ها به جلالی347        $submit_date = akdvd_jdate('Y/m/d H:i:s', strtotime($request['submitted_at']));348        349        // تاریخ وصولی از پست وابسته350        $vosooli_date = $this->get_vosooli_date($request['id']);351        352        $user = get_userdata($request['submitted_by']);353        $submitted_by_display = $user ? $user->display_name : 'ناشناس';354        355        // فرمت اعداد مبلغ356        $formatted_amount = number_format($request['order_amount'], 0, '', ',');357        358        $request['submit_date'] = $submit_date;359        $request['vosooli_date'] = $vosooli_date;360        $request['submitted_by_display'] = $submitted_by_display;361        $request['formatted_order_amount'] = $formatted_amount;362        363        // prepare files list364        $files = array();365        if (!empty($request['status_files'])) {366            $stored = maybe_unserialize($request['status_files']);367            if (is_array($stored)) {368                foreach ($stored as $f) {369                    if (is_array($f) && isset($f['url'])) {370                        $files[] = $f;371                    } elseif (is_string($f)) {372                        $files[] = array('name' => basename($f), 'url' => (strpos($f, 'http') === 0) ? $f : content_url($f));373                    }374                }375            }376        }377        $request['status_files_array'] = $files;378379        wp_send_json_success($request);380    } else {381        wp_send_json_error(array('message' => 'درخواست یافت نشد'));382    }383}384385/**386 * تابع گرفتن تاریخ وصولی از پست وابسته387 */388private function get_vosooli_date($request_id) {389    global $wpdb;390    391    // پیدا کردن پست وابسته با استفاده از اطلاعات مشتری392    $customer_name = $wpdb->get_var($wpdb->prepare(393        "SELECT customer_name FROM {$this->table_name} WHERE id = %d",394        $request_id395    ));396    397    if ($customer_name) {398        $post_id = $wpdb->get_var($wpdb->prepare(399            "SELECT ID FROM {$wpdb->posts} 400             WHERE post_title = %s AND post_type = 'vosooli' 401             AND post_status = 'publish'",402            $customer_name403        ));404        405        if ($post_id) {406            $vosooli_date = get_post_meta($post_id, 'vosooli_taarikh', true);407            if ($vosooli_date) {408                // تبدیل تاریخ جلالی به فرمت Y/m/d409                return str_replace('-', '/', $vosooli_date);410            }411        }412    }413    414    return '-';415}416417418    /**419 * هندلر AJAX برای گرفتن نام نمایشی کاربر420 */421public function akdvd_handle_ajax_get_user_display_name() {422    check_ajax_referer('ak_makhzan_panel_nonce', 'nonce');423    424    if (!current_user_can('can_enter_makhzan_dvd')) {425        wp_die('دسترسی غیرمجاز');426    }427    428    $user_id = intval($_POST['user_id']);429    $user = get_userdata($user_id);430    431    if ($user) {432        wp_send_json_success(array('display_name' => $user->display_name));433    } else {434        wp_send_json_error(array('message' => 'کاربر یافت نشد'));435    }436}437438    /**439     * هندلر AJAX برای بروزرسانی وضعیت440     */441    public function akdvd_handle_ajax_update_status() {442        check_ajax_referer('ak_makhzan_panel_nonce', 'nonce');443        444        if (!current_user_can('can_enter_makhzan_dvd')) {445            wp_die('دسترسی غیرمجاز');446        }447        448        $request_id = intval($_POST['request_id']);449        $status = sanitize_text_field($_POST['status']);450        $notes = sanitize_textarea_field($_POST['notes']);451        // files may be uploaded via multipart/form-data452        $uploaded_files = array();453        454        // اعتبارسنجی455        if (!in_array($status, array('pending', 'sent', 'cancelled'))) {456            wp_send_json_error(array('message' => 'وضعیت نامعتبر'));457        }458        459        global $wpdb;460        461        // handle uploaded files462        if (!empty($_FILES) && isset($_FILES['files'])) {463            $files = $_FILES['files'];464            $count = count($files['name']);465            $base_dir = WP_CONTENT_DIR . '/makhzan-dvd/' . date('Y') . '/' . date('m') . '/' . date('d') . '/';466            $base_url = content_url('makhzan-dvd/' . date('Y') . '/' . date('m') . '/' . date('d') . '/');467            if (!file_exists($base_dir)) {468                wp_mkdir_p($base_dir);469            }470            for ($i = 0; $i < $count; $i++) {471                if ($files['error'][$i] !== UPLOAD_ERR_OK) continue;472                $tmp = $files['tmp_name'][$i];473                $orig_name = sanitize_file_name($files['name'][$i]);474                $prefix = wp_generate_password(8, false, false);475                $new_name = $prefix . '_' . $orig_name;476                $dest = $base_dir . $new_name;477                if (move_uploaded_file($tmp, $dest)) {478                    $uploaded_files[] = array(479                        'name' => $orig_name,480                        'url' => $base_url . $new_name,481                        'path' => $dest482                    );483                }484            }485        }486        487        // merge with existing files stored in DB488        $existing = $wpdb->get_var($wpdb->prepare("SELECT status_files FROM {$this->table_name} WHERE id = %d", $request_id));489        $existing_arr = array();490        if ($existing) {491            $maybe = maybe_unserialize($existing);492            if (is_array($maybe)) $existing_arr = $maybe;493        }494        495        // normalize existing entries to arrays with name/url/path if they are strings496        $normalized = array();497        foreach ($existing_arr as $e) {498            if (is_array($e) && isset($e['url'])) {499                $normalized[] = $e;500            } elseif (is_string($e)) {501                $normalized[] = array('name' => basename($e), 'url' => (strpos($e, 'http') === 0) ? $e : content_url($e), 'path' => '');502            }503        }504        505        $merged = $normalized;506        foreach ($uploaded_files as $uf) {507            $merged[] = $uf;508        }509        510        $result = $wpdb->update(511            $this->table_name,512            array(513                'status' => $status,514                'status_notes' => $notes,515                'status_files' => serialize($merged),516                'status_updated_at' => current_time('mysql')517            ),518            array('id' => $request_id),519            array('%s', '%s', '%s', '%s'),520            array('%d')521        );522        523        if ($result !== false) {524            wp_send_json_success(array('message' => 'وضعیت با موفقیت بروزرسانی شد'));525        } else {526            wp_send_json_error(array('message' => 'خطا در بروزرسانی وضعیت'));527        }528    }529530    /**531     * حذف یک فایل پیوست از وضعیت532     */533    public function akdvd_handle_ajax_delete_status_file() {534        check_ajax_referer('ak_makhzan_panel_nonce', 'nonce');535        if (!current_user_can('can_enter_makhzan_dvd')) {536            wp_die('دسترسی غیرمجاز');537        }538539        $request_id = intval($_POST['request_id']);540        $file_url = sanitize_text_field($_POST['file_url']);541542        if (!$request_id || !$file_url) {543            wp_send_json_error(array('message' => 'پارامترهای نامعتبر'));544        }545546        global $wpdb;547        $row = $wpdb->get_var($wpdb->prepare("SELECT status_files FROM {$this->table_name} WHERE id = %d", $request_id));548        if (!$row) {549            wp_send_json_error(array('message' => 'درخواست یافت نشد'));550        }551552        $files = maybe_unserialize($row);553        if (!is_array($files)) $files = array();554555        $found = false;556        $file_path_to_delete = '';557        foreach ($files as $idx => $f) {558            if (is_array($f) && isset($f['url']) && $f['url'] === $file_url) {559                $found = true;560                $file_path_to_delete = isset($f['path']) ? $f['path'] : '';561                unset($files[$idx]);562                break;563            } elseif (is_string($f) && (strpos($f, $file_url) !== false || basename($f) === basename($file_url))) {564                $found = true;565                $file_path_to_delete = '';566                unset($files[$idx]);567                break;568            }569        }570571        if (!$found) {572            wp_send_json_error(array('message' => 'فایل یافت نشد'));573        }574575        // attempt to delete physical file576        if (!empty($file_path_to_delete) && file_exists($file_path_to_delete)) {577            @unlink($file_path_to_delete);578        }579580        $files = array_values($files);581        $updated = $wpdb->update(582            $this->table_name,583            array('status_files' => serialize($files)),584            array('id' => $request_id),585            array('%s'),586            array('%d')587        );588589        if ($updated !== false) {590            wp_send_json_success(array('message' => 'فایل حذف شد'));591        } else {592            wp_send_json_error(array('message' => 'خطا در حذف فایل'));593        }594    }595596    /**597     * هندلر AJAX برای جستجو598     */599    public function akdvd_handle_ajax_search_requests() {600        check_ajax_referer('ak_makhzan_panel_nonce', 'nonce');601        602        if (!current_user_can('can_enter_makhzan_dvd')) {603            wp_die('دسترسی غیرمجاز');604        }605        606        $search_term = sanitize_text_field($_POST['search_term']);607        608        global $wpdb;609        610        $results = $wpdb->get_results($wpdb->prepare(611            "SELECT * FROM {$this->table_name} 612             WHERE customer_name LIKE %s OR customer_national_id LIKE %s 613             ORDER BY submitted_at DESC LIMIT 50",614            '%' . $wpdb->esc_like($search_term) . '%',615            '%' . $wpdb->esc_like($search_term) . '%'616        ), ARRAY_A);617        618        wp_send_json_success($results);619    }620    621    /**622     * هندلر AJAX برای فیلتر623     */624    public function akdvd_handle_ajax_filter_requests() {625        check_ajax_referer('ak_makhzan_panel_nonce', 'nonce');626        627        if (!current_user_can('can_enter_makhzan_dvd')) {628            wp_die('دسترسی غیرمجاز');629        }630        631        $status = sanitize_text_field($_POST['status']);632        633        global $wpdb;634        635        $where_clause = "";636        if ($status !== 'all') {637            $where_clause = $wpdb->prepare("WHERE status = %s", $status);638        }639        640        $results = $wpdb->get_results(641            "SELECT * FROM {$this->table_name} {$where_clause} 642             ORDER BY submitted_at DESC LIMIT 50",643            ARRAY_A644        );645        646        wp_send_json_success($results);647    }648}649650/**651 * تابع تبدیل تاریخ میلادی به جلالی652 */653if (!function_exists('akdvd_gregdate')) {654    function akdvd_gregdate($format='Y-m-d', $jalali='') {655        if (function_exists('parsidate')) {656            return parsidate($format, $jalali, 'jalali_to_greg');657        }658        return $jalali;659    }660}661662/**663 * تابع تبدیل تاریخ میلادی به جلالی664 */665if (!function_exists('akdvd_jdate')) {666    function akdvd_jdate($format, $timestamp = null) {667        if (function_exists('parsidate')) {668            return parsidate($format, $timestamp ?: current_time('timestamp'), 'eng');669        }670        return $timestamp ? date($format, $timestamp) : current_time($format);671    }672}673674/**675 * تابع محاسبه آمار676 */677function akdvd_get_stats() {678    global $wpdb;679    $table_name = $wpdb->prefix . 'makhzan_dvd';680    681    $total_customers = $wpdb->get_var("SELECT COUNT(*) FROM {$table_name}");682    $pending_count = $wpdb->get_var("SELECT COUNT(*) FROM {$table_name} WHERE status = 'pending'");683    $sent_count = $wpdb->get_var("SELECT COUNT(*) FROM {$table_name} WHERE status = 'sent'");684    685    return array(686        'total_customers' => $total_customers,687        'pending_count' => $pending_count,688        'sent_count' => $sent_count689    );690}691692/**693 * تابع محاسبه سطح مبلغ694 */695function akdvd_get_amount_level($amount) {696    if ($amount >= 1500000) {697        return 'سطح یک';698    } elseif ($amount >= 1480000) {699        return 'سطح دو';700    } elseif ($amount >= 1400000) {701        return 'سطح سه';702    } else {703        return 'بدون سطح';704    }705}706707// ایجاد جدول در فعال‌سازی افزونه708register_activation_hook(__FILE__, 'akdvd_create_dvd_table');709710function akdvd_create_dvd_table() {711    global $wpdb;712    $table_name = $wpdb->prefix . 'makhzan_dvd';713    714    $charset_collate = $wpdb->get_charset_collate();715    716    $sql = "CREATE TABLE $table_name (717        id mediumint(9) NOT NULL AUTO_INCREMENT,718        customer_name varchar(255) NOT NULL,719        customer_national_id varchar(50) DEFAULT '',720        customer_phone varchar(20) DEFAULT '',721        customer_address text DEFAULT '',722        customer_postal_code varchar(20) DEFAULT '',723        customer_job varchar(100) DEFAULT '',724        order_amount decimal(15,2) DEFAULT 0.00,725        order_date datetime DEFAULT '0000-00-00 00:00:00',726        status varchar(20) DEFAULT 'pending',727        submitted_by bigint(20) DEFAULT 0,728        submitted_at datetime DEFAULT '0000-00-00 00:00:00',729        status_notes text DEFAULT '',730        status_files longtext DEFAULT '',731        status_updated_at datetime DEFAULT '0000-00-00 00:00:00',732        PRIMARY KEY (id),733        KEY customer_national_id (customer_national_id),734        KEY status (status),735        KEY submitted_at (submitted_at)736    ) $charset_collate;";737    738    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');739    dbDelta($sql);740}741742// حذف جدول در غیرفعال‌سازی افزونه743register_deactivation_hook(__FILE__, 'akdvd_drop_dvd_table');744745function akdvd_drop_dvd_table() {746    global $wpdb;747    $table_name = $wpdb->prefix . 'makhzan_dvd';748    $wpdb->query("DROP TABLE IF EXISTS $table_name");749}750751// نمونه‌سازی کلاس752new ak4w8DVD_Makhzan();753