CA Work Booking
Cyber Cafe: Client का काम CA को भेजें
prefix.'cyber_ca_bookings';
$d = array_map('sanitize_text_field', $_POST);
// File Upload
$file_url = '';
if(!empty($_FILES['draft_file']['name'])) {
require_once(ABSPATH.'wp-admin/includes/file.php');
$upload = wp_handle_upload($_FILES['draft_file'], ['test_form' => false]);
if(!isset($upload['error'])) $file_url = $upload['url'];
}
$wpdb->insert($table, [
'cyber_cafe_name' => $d['cyber_cafe_name'],
'select_ca' => $d['select_ca'],
'client_name' => $d['client_name'],
'client_mobile' => $d['client_mobile'],
'service_type' => $d['service_type'],
'work_details' => sanitize_textarea_field($_POST['work_details']),
'file_url' => $file_url
]);
$headers = ['Content-Type: text/html; charset=UTF-8'];
$file_link = $file_url ? "
File: Download
" : '';
// EMAIL TO CA - support@zomxon.com pe jayega
wp_mail('support@zomxon.com', 'New Work from '.$d['cyber_cafe_name'].' | '.$d['client_name'], "
New CA Work - Cyber Cafe
Cyber Cafe: {$d['cyber_cafe_name']}
Assigned CA: {$d['select_ca']}
Client: {$d['client_name']} | {$d['client_mobile']}
Service: {$d['service_type']}
Details:
".nl2br(sanitize_textarea_field($_POST['work_details']))."
{$file_link}
", $headers);
wp_send_json_success();
}
// 4. NEW ADMIN DASHBOARD
add_action('admin_menu', function() {
add_menu_page('Cyber CA Works', 'Cyber CA Works', 'manage_options', 'cyber-ca-works', function() {
global $wpdb;
$data = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}cyber_ca_bookings ORDER BY created_at DESC");
echo '
Cyber Cafe CA Work Bookings
| Date | Cyber Cafe | Client | Mobile | Service | CA | File | Status |
';
foreach($data as $r) {
$file = $r->file_url ? "View" : 'No File';
echo "| {$r->created_at} | {$r->cyber_cafe_name} |
{$r->client_name} | {$r->client_mobile} |
{$r->service_type} | {$r->select_ca} | {$file} | {$r->status} |
";
}
echo '
';
}, 'dashicons-groups', 7);
});