{"id":14519,"date":"2025-03-17T22:09:49","date_gmt":"2025-03-17T17:39:49","guid":{"rendered":"https:\/\/dawat.edu.af\/?page_id=14519"},"modified":"2025-03-26T01:14:52","modified_gmt":"2025-03-25T20:44:52","slug":"kankor-result","status":"publish","type":"page","link":"https:\/\/www.dawat.edu.af\/en\/?page_id=14519","title":{"rendered":"Kankor Result"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"14519\" class=\"elementor elementor-14519\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8ea11cc e-flex e-con-boxed rt-default-class e-con e-parent\" data-id=\"8ea11cc\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-27017f0 rt-default-class elementor-widget elementor-widget-heading\" data-id=\"27017f0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0646\u062a\u0627\u06cc\u062c \u06a9\u0627\u0646\u06a9\u0648\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0644\u06cc\u0633\u0627\u0646\u0633 \u0648 \u0641\u0648\u0642 \u0644\u06cc\u0633\u0627\u0646\u0633 (\u0628\u0647\u0627\u0631\u06cc 1404)<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c22e13 rt-default-class elementor-widget elementor-widget-text-editor\" data-id=\"3c22e13\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>\u06a9\u0627\u0646\u06a9\u0648\u0631 \u0639\u0645\u0648\u0645\u06cc \u0648 \u0645\u062a\u0641\u0631\u0642\u0647<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b31b36 rt-default-class elementor-widget elementor-widget-html\" data-id=\"3b31b36\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<!DOCTYPE html>\r\n<html>\r\n<head>\r\n  <meta charset=\"UTF-8\">\r\n  <!-- Yekan Font CDN -->\r\n  <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/gh\/rastikerdar\/yekan-font@latest\/yekan.min.css\">\r\n  <style>\r\n    body {\r\n      font-family: 'Yekan', sans-serif;\r\n      margin: 20px;\r\n      direction: ltr; \/* Keep body in LTR *\/\r\n    }\r\n    .search-container {\r\n      margin-bottom: 20px;\r\n      direction: rtl; \/* Make search fields RTL *\/\r\n      text-align: right;\r\n    }\r\n    .search-container input {\r\n      margin-right: 10px;\r\n      padding: 8px;\r\n      font-size: 16px;\r\n      width: 200px;\r\n      text-align: right; \/* Make text align right *\/\r\n    }\r\n    .search-container button {\r\n      padding: 8px 15px;\r\n      font-size: 16px;\r\n      cursor: pointer;\r\n    }\r\n    table {\r\n      border-collapse: collapse;\r\n      width: 100%;\r\n      direction: rtl; \/* Make table RTL *\/\r\n      text-align: right;\r\n    }\r\n    th, td {\r\n      border: 1px solid #ddd;\r\n      padding: 8px;\r\n    }\r\n    tr:nth-child(even) {\r\n      background-color: #f2f2f2;\r\n    }\r\n    th {\r\n      background-color: #4CAF50;\r\n      color: white;\r\n    }\r\n  <\/style>\r\n<\/head>\r\n<body>\r\n\r\n  <h3 style=\"text-align: right;\">\ud83d\udd0d<\/h3>\r\n\r\n  <div class=\"search-container\">\r\n    <input type=\"text\" id=\"nameInput\" placeholder=\"\u0646\u0627\u0645 \u0631\u0627 \u062f\u0631\u062c \u06a9\u0646\u06cc\u062f\">\r\n    <input type=\"text\" id=\"fatherNameInput\" placeholder=\"\u0646\u0627\u0645 \u067e\u062f\u0631 \u0631\u0627 \u062f\u0631\u062c \u06a9\u0646\u06cc\u062f\">\r\n    <input type=\"text\" id=\"grandFatherNameInput\" placeholder=\"\u0646\u0627\u0645 \u067e\u062f\u0631\u06a9\u0644\u0627\u0646 \u0631\u0627 \u062f\u0631\u062c \u06a9\u0646\u06cc\u062f\">\r\n    <button onclick=\"searchExcel()\">\u062c\u0633\u062a\u062c\u0648<\/button>\r\n  <\/div>\r\n\r\n  <div id=\"resultContainer\"><\/div>\r\n\r\n  <!-- Include SheetJS library -->\r\n  <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.18.5\/xlsx.full.min.js\"><\/script>\r\n  <script>\r\n    const excelFilePath = 'https:\/\/www.dawat.edu.af\/wp-content\/uploads\/2024\/07\/kankor_result.xlsx'; \/\/ Update this with the correct file path\r\n\r\n    async function searchExcel() {\r\n      try {\r\n        const response = await fetch(excelFilePath);\r\n        if (!response.ok) throw new Error(\"\u0641\u0627\u06cc\u0644 \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc \u0646\u0634\u062f\");\r\n        \r\n        const data = await response.arrayBuffer();\r\n        const workbook = XLSX.read(data, { type: 'array' });\r\n        const sheetName = workbook.SheetNames[0];\r\n        const worksheet = workbook.Sheets[sheetName];\r\n        const jsonData = XLSX.utils.sheet_to_json(worksheet);\r\n\r\n        filterData(jsonData);\r\n      } catch (error) {\r\n        console.error(\"\u062e\u0637\u0627 \u062f\u0631 \u062e\u0648\u0627\u0646\u062f\u0646 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644:\", error);\r\n      }\r\n    }\r\n\r\n    function filterData(data) {\r\n      const nameFilter = document.getElementById('nameInput').value.toLowerCase();\r\n      const fatherNameFilter = document.getElementById('fatherNameInput').value.toLowerCase();\r\n      const grandFatherNameFilter = document.getElementById('grandFatherNameInput').value.toLowerCase();\r\n\r\n      const filteredData = data.filter(row => {\r\n        const nameMatch = row[\"\u0646\u0627\u0645\"]?.toLowerCase().includes(nameFilter) || nameFilter === \"\";\r\n        const fatherMatch = row[\"\u0646\u0627\u0645 \u067e\u062f\u0631\"]?.toLowerCase().includes(fatherNameFilter) || fatherNameFilter === \"\";\r\n        const grandFatherMatch = row[\"\u0646\u0627\u0645 \u067e\u062f\u0631\u06a9\u0644\u0627\u0646\"]?.toLowerCase().includes(grandFatherNameFilter) || grandFatherNameFilter === \"\";\r\n\r\n        return nameMatch && fatherMatch && grandFatherMatch;\r\n      });\r\n\r\n      displayResults(filteredData);\r\n    }\r\n\r\n    function displayResults(results) {\r\n      const container = document.getElementById('resultContainer');\r\n      container.innerHTML = \"\";\r\n\r\n      if (results.length === 0) {\r\n        container.innerHTML = \"<p style='text-align: right;'>\u26a0 \u0647\u06cc\u0686 \u0646\u062a\u06cc\u062c\u0647\u200c\u0627\u06cc \u06cc\u0627\u0641\u062a \u0646\u0634\u062f.<\/p>\";\r\n        return;\r\n      }\r\n\r\n      const table = document.createElement('table');\r\n\r\n      \/\/ Create Table Header Dynamically\r\n      const headerRow = document.createElement('tr');\r\n      const columns = Object.keys(results[0]); \/\/ Get all column names dynamically\r\n\r\n      columns.forEach(col => {\r\n        const th = document.createElement('th');\r\n        th.textContent = col;\r\n        headerRow.appendChild(th);\r\n      });\r\n\r\n      table.appendChild(headerRow);\r\n\r\n      \/\/ Create Table Rows Dynamically\r\n      results.forEach(row => {\r\n        const tr = document.createElement('tr');\r\n        columns.forEach(col => {\r\n          const td = document.createElement('td');\r\n          td.textContent = row[col] || \"\";\r\n          tr.appendChild(td);\r\n        });\r\n        table.appendChild(tr);\r\n      });\r\n\r\n      container.appendChild(table);\r\n    }\r\n  <\/script>\r\n<\/body>\r\n<\/html>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u0646\u062a\u0627\u06cc\u062c \u06a9\u0627\u0646\u06a9\u0648\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0644\u06cc\u0633\u0627\u0646\u0633 \u0648 \u0641\u0648\u0642 \u0644\u06cc\u0633\u0627\u0646\u0633 (\u0628\u0647\u0627\u0631\u06cc 1404) \u06a9\u0627\u0646\u06a9\u0648\u0631 \u0639\u0645\u0648\u0645\u06cc \u0648 \u0645\u062a\u0641\u0631\u0642\u0647 \ud83d\udd0d \u062c\u0633\u062a\u062c\u0648<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-14519","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=\/wp\/v2\/pages\/14519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14519"}],"version-history":[{"count":0,"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=\/wp\/v2\/pages\/14519\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dawat.edu.af\/en\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}