// <script>              
   
    /////////////////////////////////////////   AUTO INSERT UPDATE MYSQL //////////////////////////
                          
  function INSERTUPDATE(clean, Aception, divid, dbase,CollumnAcept){//alert(clean+' - '+ Aception+' - '+ divid+'-'+dbase);
                                dividx=divid.split('-')
                                var     collumnc='INSERT INTO '+dbase+'.'+dividx[0]+'(';
                                var     collect='VALUES(';
                                var     updatestat=' ON DUPLICATE KEY UPDATE ';
                                const container = document.getElementById(divid);
                                const childElements = container.getElementsByTagName('*'); 
        for (let i = 0; i < childElements.length; i++   ) { 
            if( childElements[i].value && childElements[i].id) {
                if(!CollumnAcept.includes(childElements[i].id)){//alert(childElements[i].id+' - '+!CollumnAcept.includes(childElements[i].id))
                    childElement= (childElements[i].id).split("-");
                    if(collect.length===7  ) { // 
                                collumnc+= childElement[0];
                                collect += '\''+childElements[i].value+'\'';
                                updatestat+= childElement[0]+'='+ '\''+childElements[i].value+'\'';
                                }else{
                         if(divid[0]){
                                collect += ','+'\''+childElements[i].value+'\'';
                                collumnc+= ','+childElement[0];
                                updatestat+=','+childElement[0]+'='+'\''+childElements[i].value+'\'';
                        }
                    };
                }
            }   
         } 
 
                                collect+=') ';  
                                collumnc+=') ';
                                collect+=updatestat;
                                collumnc+=collect; 
                                Queries=collumnc +';'
alert( Queries)
ExecuteQUERES('clean',Queries) }



    function  ExecuteQUERES(clean,Queries){//alert('ok');//alert(Queries+' - '+clean)
                const formData = new FormData();
                            formData.append('user_regist', Queries );
                fetch('../METHODS/INSERT.PHP', {
                            method: 'POST',
                            body: formData
            })

                    .then(response => { //alert(response.ok)

                if (!response.ok) {  throw new Error('Network response was not ok');}
                            return response.text();
             }) // Or response.json() if your PHP returns JSON 

                   .then(data => {//alert(data)
                //    if(data.includes('لقد تم تسجيل بنجاح') && clean=='yes') { 
                //      for (let i = 0; i < childElements.length; i++){
                //     if(!RegExp('\\b'+ childElements[i].id +'\\b')
                // // .test( Aception )){
                //    }
                //  }
                      
             
                         if(data.includes('لقد تم تسجيل بنجاح')){//alert('yes')
                             Swal.fire({
                                                    title: '',
                                                    text: ('لقد تم تسجيل بنجاح'),
                                                    type: 'info',
                                                    // showCancelButton: true,
                                                    confirmButtonColor: "#5cb85c",
                                                    confirmButtonText: "Ok",
                                                    closeOnConfirm: false
                                                })
                        

                        }



            }
        )}
                                                

   ;Queries=''
// //////////////////////////////////////////////////////////////////////////////////////////

function INSERTUPDATETABLE(clean, Aception, divid, dbase,CollumnAcept,status,Checherx){//alert(divid)
                                Queries='' 
                                dividx=divid.split('-')
                                var Checher='Checher'
                                var     collumnc='INSERT INTO '+dbase+'.'+dividx[0]+'(';
                                var     collect='VALUES(';
                                var     updatestat=' ON DUPLICATE KEY UPDATE ';
                                
                                const container = document.getElementById(divid);
                                const childElements = container.getElementsByTagName('*'); 
        for (let i = 0; i < childElements.length; i++   ) { 
                                Columname=(childElements[i].id).split("-")
            if(childElements[i].value && Columname[0] && !CollumnAcept.includes(Columname[0])){//alert(  Columname[0]+' - '+childElements[i].checked)//alert(Columname[0]+' - '+!CollumnAcept.includes(Columname[0]))
        
            if(Checher.includes(Columname[0])){ //alert(3)
                                    Queries= collumnc+') '+collect+') '+updatestat+' ; '
                                    ExecuteQUERES('clean',Queries) 
                                    Queries=''  
                                    collumnc=''
                                    collect='';
                                    updatestat='';
                                    collumnc=collumncx
                                    collect=collectx
                                    updatestat=updatestatx;
                                    Checher= Columname[0]
                                    collumnc+= Columname[0];
                                    collumncb=collumnc;
                                    collect += '\''+childElements[i].value+'\'';
                                    updatestat+=Columname[0]+'='+'\''+childElements[i].value+'\'';
                                    
                }else{
                if(collect.length===7  ) {//alert(1)
                                Checher= Columname[0]
                                
                                collumnc+= Columname[0];
                                collumncb=collumnc;
                                if(Columname[0]==='Status'&& childElements[i].checked===true)
                                {collect += '\''+status+'\'';}else 
                                collect += '\''+childElements[i].value+'\'';
                                updatestat+=''+Columname[0]+'='+'\''+childElements[i].value+'\'';
                        }else if(divid[0]){//alert(2)

                                Checher+= ','+Columname[0]
                                collect += ','+'\''+childElements[i].value+'\'';
                                collumnc+= ','+Columname[0];
                                updatestat+=','+Columname[0]+'='+'\''+childElements[i].value+'\'';
                                if(Checherx.includes(Columname[0])){
                                    collumncx =collumnc+','
                                    updatestatx=updatestat+','
                                    collectx= collect+','
                                 
                                }
                    };
                }
            }                             
        }  
             Queries= collumnc+') '+collect+') '+updatestat+' ; '
            // alert( Queries)
          ExecuteQUERES('clean',Queries) 
          Queries=''  
}    
            
            
//                         function CellElement(Idname){//alert(Idname)
//                                      const container = document.getElementById(Idname);
//                                 const Elements = container.getElementsByTagName('*'); 
//         for (let i = 0; i < Elements.length; i++   ) { 
                           
//                             alert((Elements[i].id).split("-"));
//                            };
//                         }









           
                              

                               
 





 

</script>


<script>
   
    let  moduls='' ;
  let data;

//                                  function customAlert(title, message) {
//   const modal = document.createElement('div');
//   modal.innerHTML = `
//     <div style="position:fixed;top:0;left:0;width:100%;height:100%;
//                 background:rgba(248, 213, 213, 0.5);z-index:9999;
//                 display:flex;align-items:center;justify-content:center;">
//       <div style="background:#fff;border-radius:8px;min-width:300px;
//                   font-family:sans-serif;overflow:hidden;">
//         <div style="background:#4a90e2;color:#fff;padding:12px 16px;
//                     font-weight:bold;font-size:16px;">
//           ${title}
//         </div>
//         <div style="padding:20px;font-size:14px;">${message}</div>
//         <div style="padding:12px 16px;text-align:right;">
//           <button onclick="this.closest('div[style]').remove()"
//             style="background:#4a90e2;color:#fff;border:none;
//                    padding:8px 20px;border-radius:4px;cursor:pointer;">
//             OK
//           </button>
//         </div>
//       </div>
// //     </div>`;
//   document.body.appendChild(modal);
// }



                  var Msg = new Array(100)
Msg[0] ='';
Msg[1] = '3';
Msg[2] = '3';
Msg[3] = '4';
Msg[4] = '5';


                        // function DeletRecord(QueryElemt){
                        //     QElemt=QueryElemt...split('-')
                        //     // 0- Data base Table
                        //     // 1- Whhere  Columne
                        //     // 2- Where Value
                        //      Query='DELETE FROM '+QElemt[0]+=' WHERE '+QElemt[1]+'"'+QElemt[2]+'"'
                        // alert(Query)
                        //       const formData = new FormData();
                        //       formData.append('user_regist', Query );
                        //       fetch('../METHODS/MysqlQuery.PHP', {
                        //             method: 'POST',
                        //             body: formData})
                        //             .then(response => {
                        //       if (!response.ok) {
                        //       throw new Error('Network response was not ok');
                        //     }
                        //       return response.text(); // Or response.json() if your PHP returns JSON
                        // })    
                        //     .then(data => {//alert(data)
                        //     if(data){ MsgAlert(Msg[0],'لقد تم التسجيل بنجاح','info','false','')}
                               
                        //     })
                        //             .catch(error => {
                        //             //alert('Fetch error:', data);
                        // });
                    
                        // }
                        function checkfelds(DivId, FeldsId, FormId) {
                               // alert(DivId + ' - ' + FeldsId); // Optional debugging
                                    const FeldsIdx = FeldsId.split(',');
                                    let hasEmptyField = false; 
                                    for (let i = 0; i < FeldsIdx.length; i++) {
                                        const field = document.getElementById(FeldsIdx[i].trim());
                                        if (field && (field.value === null || field.value.trim() === '')) {
                                            hasEmptyField = true;
                                            break; // Stop loop as soon as one empty field is found
                                        } 
                                    }
                                    if (hasEmptyField) {//alert(t.party)
                                        MsgAlert('', 'يجب ادخال البيانات الاساسيه', 'info');
                                    } else {
                                        switch (DivId) {
                                            case 'student_info':
                                                INSERTUPDATE('yes', '', 'student_info', 'myschool', 'cerdit,disdebit,Notice,debit,blance,familyoption,uniformfeescerdit,bookfeescerdit,PrintDocu');
                                                break;
                                            case 'users':
                                                INSERTUPDATE('yes', '', 'users', 'myschool', 'usertype,crPSW');
                                                break;
                                            case 'myschool_info':
                                                INSERTUPDATE('yes', 'datakey', 'myschool_info', 'myschool', '');
                                                break;
                                            case 'school_info':
                                                INSERTUPDATE('yes', '', 'school_info', 'myschool', '');
                                                break;
                                            case 'teacher_info':  //alert('yes');
                                                INSERTUPDATE('yes', '', 'teacher_info', 'myschool', '');
                                                break; 
                                            case 'teacher_task':  //alert('yes');
                                                INSERTUPDATE('yes', '', 'teacher_task', 'myschool', '');
                                                break; 
                                            case 'teachersubjcts_info':
                                                    INSERTUPDATE('yes','','teachersubjcts_info', 'myschool','');
                                            break; 
                                                case 'question_info':
                                                    INSERTUPDATE('yes','','question_info', 'myschool','');
                                            break; 
                                            default:
                                        break;
        }
    }
}

                 
               
      function MsgAlert(Ptitle, Ptext, Ptype, callbackAction = null) {
    let options = {
        title: Ptitle,
        text: Ptext,
        icon: Ptype === 'Yes/Cancel' ? 'question' : Ptype // Maps custom types to valid Swal icons
    };

    switch (Ptype) {
        case 'info':
            options.confirmButtonColor = "#5cb85c";
            options.confirmButtonText = "موافق"; // Arabic standard for UX continuity
            break;

        case 'Yes/Cancel':
            options.showCancelButton = true; // Fixed: Explicitly set instead of undefined variable
            options.cancelButtonColor = "#d33";
            options.confirmButtonColor = "#5cb85c";
            options.confirmButtonText = "نعم";
            options.cancelButtonText = "إلغاء";
            break;

        case 'error':
            options.confirmButtonColor = "#d33";
            options.confirmButtonText = "موافق";
            
            break;

        default:
            options.confirmButtonColor = "#3085d6";
            options.confirmButtonText = "موافق";
            break;
    }

    // Fire the modern SweetAlert2 modal instance
    Swal.fire(options).then(function (result) {
        if (result.isConfirmed) {
            // Safely execute your callback action if it was passed
            if (typeof callbackAction === 'function') {
                callbackAction();
            }
        }
    });
}


                            function par(name){return document.getElementById(name)}

                            



                            function MySqlDate(Queries){//alert(Queries)
                            const formData = new FormData();
                              formData.append('user_regist', Queries );
                              fetch('../METHODS/MysqlQuery.PHP', {
                                    method: 'POST',
                                    body: formData})
                                    .then(response => {
                              if (!response.ok) {
                              throw new Error('Network response was not ok');
                            }
                              return response.text(); // Or response.json() if your PHP returns JSON
                        })    
                            .then(data => {//alert(data)
                            if(data){ MsgAlert('','لقد تم العمليه بنجاح','info','false','')}
                               
                            })
                                    .catch(error => {
                                    //alert('Fetch error:', data);
                        });
                    }

                    //     function PropertiesChanged(Idname,Property,ConditionItem){//alert(Idname+" - "+Property+" - "+ConditionItem)
                    //             myDiv = document.getElementById(Idname);                           
                    //             elements = myDiv.querySelectorAll('input, button, select, textarea');
                    //                switch(Property){
                    //                    case 'readonly':
                    //                 if(ConditionItem==true){///alert('readonly')
                    //                     myDiv.readonly='true'
                    //                 }else if(ConditionItem==false){///alert('not readonly')
                    //                     myDiv.readonly='false'
                    //                 }
                    //                 break;
                    //                 case 'display':
                    //                     if(ConditionItem==true){//alert('display')
                    //                     myDiv.style.display='block'
                    //                     }else if(ConditionItem==false){///alert('not display')
                    //                     myDiv.style.display='none'
                    //                     }
                    //                 break;
                    //                 case 'disabled':
                    //                     if(ConditionItem==true){//alert('disabled')
                    //                     //myDiv.classList.add('disabled-div');
                    //                     elements.forEach(el => el.disabled = false);
                    //                     }else if(ConditionItem==false){///alert('not disabled')
                    //                     //myDiv.classList.remove('disabled-div');
                    //                     elements.forEach(el => el.disabled = true);
                    //                     }
                    //                 break;
                    //                 case 'hidden':
                    //                     if(ConditionItem==true){//alert('hidden')
                    //                     myDiv.hidden=true
                    //                     }else if(ConditionItem==false){///alert('not hidden')
                    //                     myDiv.hidden=false
                    //                     }
                    //                 break;
                    //                 case 'type':
                    //                     if(ConditionItem==true){//alert('type')
                    //                     myDiv.type='checkbox'
                    //                     }else if(ConditionItem==false){///alert('not type')
                    //                     myDiv.type='text'
                    //                     }
                    //                 break;
                    //                }
                    //   }


        function studentoption(Idname,GENERALVARfetch,GENERALVARkey){ //alert(Idname);alert(GENERALVARfetch)
                        x=0
                        privefetch= GENERALVARfetch.split(",");
                        privekey= GENERALVARkey.split(",");
                        Queries='UPDATE  information_schol SET data_key = CASE '
                         WhereQ=' WHERE controlfetch IN ( '
                        myDiv = document.getElementById('studenption')
                        elms = myDiv.querySelectorAll('input[type="checkbox"]');
            if(!Idname){
                                       
                           for(i=0;i< elms.length ;i++){ 
                          if(elms[i].checked){status='on'}else{status='off'}
                            Queries+= ' WHEN controlfetch = "'+elms[i].id  + '" THEN "'  +status +'"' 
                            WhereQ+='"'+elms[i].id+'",'
                         };
                         WhereQ=WhereQ.slice(0, -1) + " ";
                          Queries+= ' ELSE data_key END'
                          WhereQ+=') ' 
                          Queries+= WhereQ
                       // alert(Queries)
                          MySqlDate(Queries)
                }else  if(Idname){
                    
                for (i = 0; i < privefetch.length; i++) {//alert('ok2'+' - '+privefetch+' - '+privekey)
                        //alert(privekey[i] + " - " + privefetch[i])
                    if(privekey[i]=='on'){
                       document.getElementById(privefetch[i]).checked = true;
                       //alert(privekey[i] + " - " + privefetch[i])
                    }else if(privekey[i]=='off' && document.getElementById(privefetch[i])){
                       document.getElementById(privefetch[i]).checked = false;
                      // alert(privekey[i] + " - " + privefetch[i])
                    }    
                }
            }
        }
    //
                       //alert(privefetch+" - "+privekey)

     
                          function UI_Select(felds,options) {//alert(felds+' - '+options);
                        if(options=="on"){
                           document.getElementById(felds).style.display = "block";
                            }else if(options=="off"){
                         document.getElementById(felds).style.display = "none";;    
                        } 
                    };                 






                            function privacies(index){//alert(index)
                    x=index
                                        prive= pricty.split("");   
                    elms = document.querySelectorAll('div[id]');
                  //alert(elms)
            for (var t = 0; t < elms.length; t++) {
            if(pricty[x]==0 && elms[t].id.startsWith('priv')){//alert( elms[t].id)
                elms[t].style.display='none' 
            }else if(pricty[x]==1 && elms[t].id.startsWith('priv')){//alert( elms[t].id)
                elms[t].style.display='block'     
            }   x++
        } 
    }
       ///////////////////////////////////dele func /////////////////
        // function DeletRecord(TableName,ColumneName,optionValue){
        //   optionValue=  optionValue.split(',')
        //    ColumneName=  ColumneName.split(',')
          
        //      for (var i = 0; i < ColumneName.length; i++) {alert(optionValue[i]+' / '+ColumneName[i])
               
        //      if(i==0 && par(optionValue[i]).value){ alert(i)
        //      let   QueryDelet =' DELETE FROM '+ TableName+' WHERE  '+ColumneName[i]+' = "'+par(optionValue[i]).value +'"'
        //         }else if(par(optionValue[i]).value) {
        //                 QueryDelet +=' and '+ColumneName[i]+' = "'+par(optionValue[i]).value +'"'
        //         }
        //      }
           
                
            
        //     alert(QueryDelet)
        //     //MysqlQuery(QueryDelet)
        // }


function DeletRecord(TableName, ColumneName, optionValue) {
    var columns = ColumneName.split(',');
    var values = optionValue.split(',');
    var QueryDelet = '';
    
    for (var i = 0; i < columns.length; i++) {
        var col = columns[i].trim();
        var elemId = values[i].trim();
        var elem = document.getElementById(elemId); // Fixed: use elemId here
        
        if (elem) {
            if (QueryDelet === '') {
                QueryDelet = 'DELETE FROM ' + TableName + ' WHERE ' + col + ' = "' + elem.value + '"';
            } else {
                QueryDelet += ' AND ' + col + ' = "' + elem.value + '"';
            }
        }
    }
    
    if (QueryDelet !== '') {alert(QueryDelet)
        MySqlDate(QueryDelet);
    }
}



//////////////////////////////////////////////////////////////
        function privaciesCreated(dividname,privacies){//alert(dividname+" - "+privacies)
                        x=0
                        userprivacies = document.getElementById('userprivacies');
                        userprivacies.value=''
                        prive= privacies.split("");
                         myDiv = document.getElementById(dividname)
                        elms = myDiv.querySelectorAll('input[type="checkbox"]');
                    for (i = 0; i < elms.length; i++) {
                    if(privacies.length==0){//alert(' privacies')
                    if(!elms[i].checked ){ //alert(elms[i].checked)
                        userprivacies.value+=0;
                    }else  if(elms[i].checked ){//
                        userprivacies.value+=1}
                    }else if(privacies.length>0){//alert('no userprivacies')
                    if (elms[i].id) {
                    if(prive[x]==0){//alert(elms[i].id)
                        userprivacies.value+=0
                        elms[i].checked = false;
                    }else  if(prive[x]==1){//
                        userprivacies.value+=1
                        elms[i].checked = true;  // Check
                    } x=x+1;                      
                }
            }
        }  
    }          
                        function printDiv(DivId) {
                                                    const content = document.getElementById(DivId).innerHTML;
                                                    const printWindow = window.open('', '', 'width=800,height=600');
                                                    printWindow.document.write(`
                                                        <html>
                                                        <head>
                                                            <title>طباعة</title>
                                                            <style>
                                                            table { width: 100%; border-collapse: collapse; direction: rtl; }
                                                            th, td { border: 1px solid #333; padding: 8px; text-align: center; }
                                                            </style>
                                                        </head>
                                                        <body>${content}</body>
                                                        </html>
                                                    `);
                                                    printWindow.document.close();
                                                    printWindow.focus();
                                                    printWindow.print();
                                                    printWindow.close();
                                                    }
                        function printResult(DivId) {
                                                        // 1. جلب محتوى العنصر المراد طباعته
                                                        var printContents = document.getElementById(DivId).innerHTML;
                                                        
                                                        // 2. فتح نافذة طباعة جديدة
                                                        var originalContents = document.body.innerHTML;
                                                        document.body.innerHTML = printContents;
                                                        
                                                        // 3. تنفيذ أمر الطباعة
                                                        window.print();
                                                        
                                                        // 4. استعادة محتوى الصفحة الأصلي بعد الطباعة
                                                        document.body.innerHTML = originalContents;
                                                        window.location.reload(); // لتحديث الصفحة وإعادة تفعيل الأكواد العادية
                                                    }
                                                    // Usage
                                                    customAlert("My Custom Title", "This is my message!");

                    function GFunction(FunctionType, Idname, QeryCode, WhereOption, AdditionOption) {
                                    const Queries = FunctionType + "," + QeryCode + "," + WhereOption + "," + AdditionOption;
                                    alert(Queries+'q')
                                    const formData = new FormData();
                                    formData.append('user_regist', Queries);
                            fetch('../METHODS/JAVATOPHP.PHP', { 
                                        method: 'POST', 
                                        body: formData 
                                    })
                                    .then(response => {
                                        if (!response.ok) {
                                            throw new Error('Network response was not ok');
                                        }
                                        return response.text();
                                    })
                                    .then(data => {alert(data+' / '+document.getElementById(Idname).id)
                                            if (!data.includes('Warning')) {
                                            const element = document.getElementById(Idname);
                                            if (!element) return; // Exit if element doesn't exist
                                                        if (element.tagName === 'TABLE') {
                                                element.innerHTML = data;
                                            } else if (element.tagName === 'SELECT') {
                                                const firstOptionHTML = element.options[0] ? element.options[0].outerHTML : '';
                                                element.innerHTML = `<option value="${data}">${data}</option>` + firstOptionHTML;
                                            } else if (element.tagName === 'INPUT' || element.tagName === 'TEXTAREA' ) {
                                                vlu=data;
                                                document.getElementById(Idname).value =vlu 
                                               // alert(data+' / '+ Idname )

                                            }
                                        }
                                    })
                                    .catch(error => {
                                        console.error('Error:', error);
                                    });
                                }


function WherePerpare(Type, Idname, Qcode, TableName, IdNames, Group, AdditonOption) {
   //alert(Type + " - " + Idname + " - " + Qcode + " - " + TableName + " - " + IdNames + " - " + Group + " - " + AdditonOption);
    
    if (TableName) {
        // Use clean native split arrays directly instead of manually assigning items in a loop
        const ConditionsArray = IdNames.split('-');
        const TableArray = TableName.split('-');
        
        // Use the length of the split array to safely bound the loop
        let totalItems = TableArray.length;
        let x = 0;
        let WhereCondition = " where "; 
        
        do {
            // Check if the HTML element exists on page using par()
            if (par(ConditionsArray[x])) {
                WhereCondition += TableArray[x] + " like '%" + par(ConditionsArray[x]).value + "%'";
            } else {
                WhereCondition += TableArray[x] + " like '%" + ConditionsArray[x] + "%'";
            }
            
            // Only add 'and' if there is another condition following this one
            if (x < totalItems - 1) {
                WhereCondition += " and ";
            }
            x++;
        } while (x < totalItems); // Corrected boundary condition
        
        //alert(Type + " / " + Idname + " / " + Qcode + " / " + WhereCondition + " / " + AdditonOption);
        
        WhereCondition += " " + Group;
         Queries=Type+ "," +Qcode+ "," +WhereCondition+ "," +Idname + "," + AdditonOption;
    } else  if (TableName==='') {
         Queries=Type+ "," +Qcode+ "," +Group+ "," + Idname + "," + AdditonOption;
        
    }

//alert(Queries+'q')
                                    const formData = new FormData();
                                    formData.append('user_regist', Queries);
                            fetch('../METHODS/JAVATOPHP.PHP', { 
                                        method: 'POST', 
                                        body: formData 
                                    })
                                    .then(response => {
                                        if (!response.ok) {
                                            throw new Error('Network response was not ok');
                                        }
                                        return response.text();
                                    })
                                    .then(data => {//alert(data)
                                            if (!data.includes('Warning')) {
                                                            const element =par(Idname);
                                                      //  alert(element)
                                            if (!element) return; // Exit if element doesn't exist
                                            //alert('ok')
                                                if (element.tagName === 'TABLE') {
                                                // Use && so it updates only if NEITHER string is present
                                                if (!data.includes('Warning') && !data.includes('\\wamp64\\www\\')) {
                                                    element.innerHTML = data;
                                                }else{element.innerHTML =''}
                                                } else if (element.tagName === 'SELECT') {
                                                            //const firstOptionHTML = element.options[0] ? element.options[0].outerHTML : '';
                                                           element.innerHTML='';
                                                            element.innerHTML = `<option value="${data}">${data}</option>` //+ firstOptionHTML;
                                                } else if (element.tagName === 'TEXTAREA' ) {
                                                            vlu=data;
                                                            document.getElementById(Idname).value =vlu 
                                                           // alert(data+' / '+ Idname )
                                                }else if (element.tagName === 'INPUT'  ) {
                                                            vlu=data;
                                                            document.getElementById(Idname).value =vlu 
                                                           // alert(data+' / '+ Idname )
                                            }
                                        }
                                    })
                                    .catch(error => {
                                        console.error('Error:', error);
                                    });
                               } 









                        function GroupOption(IdDivTabel,ColmnConditon){
                                    OptionCode='';
                                    Queries='';
                                    const wordx = IdDivTabel.split('-');
                                    const words = ColmnConditon.split('-');
                                    parentDiv = document.getElementById(wordx[0]);
                                    childElements = parentDiv.children; 
                                for (let i = 0; i < childElements.length; i++) {//alert(childElements[i].value+" - "+ColmnConditon+' - '+childElements[i].tagName)
                            if(   childElements[i].tagName=='INPUT' ){ 
                                if(childElements[i].checked){OptionCode+=1 }else{OptionCode+=0}
                                    ;//alert(OptionCode)
                                        }}
                                Queries='update '+words[2]+'.'+wordx[1]+' set '+words[0]+'='+'"'+OptionCode+'"'+ ' where id ="'+words[1] +'"';
                                    // alert(Queries)
                                        const formData = new FormData();
                                        formData.append('user_regist', Queries );
                                        fetch('../METHODS/INSERT.PHP', {
                                        method: 'POST',
                                        body: formData})
                                        .then(response => {
                                            //  alert(response.ok)
                                    if (!response.ok) { 
                                        throw new Error('Network response was not ok');
                                }
                                        return response.text(); // Or response.json() if your PHP returns JSON
                            })
                                        .then(data => {alert(data)
                                        if(data === 'لقد تم تسجيل بنجاح ' && clean=='yes') { 
                                            for (let i = 0; i < childElements.length; i++){
                                                if(!RegExp('\\b'+ childElements[i].id +'\\b').test( Aception )){childElements[i].value=''; }
                                    } 
                                } 
                                        // alert('تم تسجيل البيانات بنجاح'); // Handle the response from the PHP script
                            })
                                        .catch(error => {
                                    // alert('Fetch error:', error);
                    });
                
                                }


                        function GroupBehavior(Idname,Behavior){//alert(Idname+" - "+Behavior)
                                    let wordX = Behavior.split(/\s+/);
                                    let words = Idname.split(/\s+/);
                                    i=0;
                                    words.forEach(word => {//alert(word)
                                        element = document.getElementById(word);
                                    if(wordX[i*2]=="required"){
                                        element.required = wordX[(i*2)+1]
                                    }
                                    if(wordX[i*2]=="display"){
                                        element.style.display = wordX[(i*2)+1] ; 
                                    };
                                    if(wordX[i*2]=="readOnly"){
                                        element.style.readOnly = wordX[(i*2)+1];
                                    };
                                    if(wordX[i*2]=="disabled" ){
                                        element.style.disabled = wordX[(i*2)+1];
                                    };
                                    if(wordX[i*2]=="hidden" ){
                                        element.style.hidden = wordX[(i*2)+1];
                                    };
                                    // if(wordX[i*2]=="type" ){alert(wordX[(i*2)+1])
                                    //     element.style.type = 'checkbox'//wordX[(i*2)+1];
                                    // };
                                        i++;
                            }  );
                        }

                    function ElementFeeds(Idname,FeedData){//alert(Idname+" - "+FeedData);
                                            let words = Idname.split(/\s+/);
                                            words.forEach(word => {
                                            let selectElement = document.getElementById(word);
                                        if (selectElement) {
                                            // Check if the element is an input or textarea
                                        if (selectElement.tagName === 'INPUT' || selectElement.tagName === 'TEXT') {
                                            //alert(document.getElementById(Idname).id)
                                            selectElement.value = FeedData;
                                        } else {
                                            //alert(document.getElementById(Idname).id)
                                        // alert(selectElement.options.length);
                                        selectElement.selectedIndex = 0; 
                                            selectElement.innerHTML += FeedData
                                        
                                        }
                    
                                    }
                                })
                            };


// function HiddTabs(idname, stratwith) {//alert(idname+' - '+ stratwith)
//     const targetElement = document.getElementById(idname);
// // alert(targetElement.id)
//    // alert(targetElement.style.display)
//     if (targetElement) {//
//         targetElement.style.display = 'block'; // Or 'inline', 'flex', etc.
//     }
//         //
//     // Grab all divs that have an ID attribute
//     const allDivs = document.querySelectorAll('div[id]');

//     allDivs.forEach(div => {
//         const divId = div.id;
//        // alert(divId+' -'+'tab')
//         // Hide if it matches the prefix but is NOT the currently targeted element
//         if (divId.startsWith(stratwith,'TAB') && divId !== idname) {alert(div.id)
//             div.style.display = 'none';
//         }
//     });alert(targetElement.style.display)
// }

            function HiddTabs(idname,stratwith){//alert(par(idname).id)

                    const allDivs = document.querySelectorAll('div');
                    allDivs.forEach((div) => {//alert(div.id)
            if(div.id && div.id.startsWith(stratwith)){//alert(div.id);                         
                     div.style.display = 'none';
                }   
            });    
                      par(idname).style.display ='block' ;                        
        };

           function GetCellData(row,Idname) {//alert(row+'--'+Idname)
                                    Elemt=Idname.split('-')
                                    // 0-Table id
                                    // 1-Div id
                                    // 2-Qquery Code
                                    // 3-Wherre Condition Columne
                                    // 4-Where Value
                                    // format code(' ondblclick="GetCellData(this,\'myTable-student_info-56-studentregkey-1-2\')
                                const table = document.getElementById(Elemt[0]);
                                table.addEventListener("click", function(event) {
                                const clickedRow = event.target.closest("tr");
                            if (clickedRow) {
                                const rowIndex = clickedRow.rowIndex;
                                indx=table.rows[rowIndex].cells[Elemt[4]].innerText;
                                indxp=table.rows[rowIndex].cells[Elemt[5]].innerText;
                                const logElement = document.getElementById('log');
                                            Swal.fire({
                                                    title: '',
                                                    text: ( " هل ترقب في تحديث بيانات   : "+indxp+"؟"),
                                                    type: 'info',
                                                    showCancelButton: true,
                                                    confirmButtonColor: "#5cb85c",
                                                    confirmButtonText: "Yes",
                                                    closeOnConfirm: false
                                                })
                                                    .then(function (isConfirm) {
                                                        if (isConfirm.value) {//alert(isConfirm.value)
                                                                  var elm = {};
                                var elms = document.getElementById( Elemt[1]).getElementsByTagName("*");
                                for (var i = 0; i < elms.length; i++) {
                        if (elms[i].id !== '') {
                                idname=elms[i].id;    // alert(elms[i].id)
                                //ElementFetch(idname,indx)
                                WherePerpare('FRD',idname,Elemt[2],Elemt[3],indx,'',idname+'-'+idname) 
                              // WherePerpare('SOD','studentclass_r',16,'datasubobject','studentstage_r',' and datakey=1 ','0-0');
                            } 
                        }
                               // logElement.textContent = "Action confirmed: Record deleted.";           // Add your 'yes' action here (e.g., submit a form, make API call)
                        
                                                        }
                                                            
                                })




                    //         if (confirm( " هل ترقب في تعديل بيانات الطالب  : "+indxp+" ?")) {//alert('ok1')
                    //              var elm = {};
                    //             var elms = document.getElementById('student_info').getElementsByTagName("*");
                    //             for (var i = 0; i < elms.length; i++) {
                    //     if (elms[i].id !== '') {
                    //             idname=elms[i].id;     // alert(idname)
                    //             //ElementFetch(idname,indx)
                    //             WherePerpare('FRD',idname,56,'studentregkey',indx,'',idname+'-'+idname) 
                    //           // WherePerpare('SOD','studentclass_r',16,'datasubobject','studentstage_r',' and datakey=1 ','0-0');
                    //         } 
                    //     }
                    //             logElement.textContent = "Action confirmed: Record deleted.";           // Add your 'yes' action here (e.g., submit a form, make API call)
                        
                        
                    //     } else {  //alert('saving');                                              // If the user clicks "Cancel" (No                 
                    // }
                }
            });
        };
                    
            function ElementFetch(idname,indx) {//////alert(indx+' - '+idname)
                                var ajax = new XMLHttpRequest();
                                ajax.open("GET", "../METHODS/SelectConnection2.php", true);                                          // A separate file is created to get studentstage list
                                ajax.send();                                                           // Actually sending the request to get data
                                ajax.onreadystatechange = function () {                 // alert(this.readyState+' - '+this.status);  // Callback when request status changes
                        if (this.readyState == 4 && this.status == 200) {          // alert(this.responseText); // status = 200, when the request is successfull // readyState = 4, when the response is received
                                var response = JSON.parse(this.responseText);
                                           //alert(response.length)              // using function JSON.parse  // this.responseText will be JSON string, so we are converting it in Javascript object
                        for (var a = 0; a < response.length; a++) { 
                                p= response[a]
                                //alert(p.studentregkey) 
                        if (p.studentregkey==indx) { //alert(indx+' - '+p[idname]+' - '+idname)
                                 nam=idname             //alert(nam);
                                 elements=document.getElementById(idname)
                                // var elements = document.getElementsByName(idname);
                                // if (elements.length > 0) {
                                 //alert(p[idname]); // Outputs "text", "hidden", etc.
                                // }
                               // elements.text=p[idname];
                                elements.value=p[idname];
                                //alert(elements.value+' - '+  elements.innerHTML+' - '+idname)
                        }
                    }
                }
            }
        }

                                const audioFileInput = document.getElementById('filex');
                                const myAudio = document.getElementById('studentimg');
                                //alert(audioFileInput.onclick())
                                audioFileInput.addEventListener('change', (event) => {//alert('ok')
                                const selectedFile = event.target.files[0];
                        if (selectedFile) {
                                const objectURL = URL.createObjectURL(selectedFile);
                               // alert(objectURL)
                                myAudio.src = objectURL;
                                myAudio.load(); // Reload the audio element with the new source
                    }
                } 
           );    

            
              
            function CreaSerial(){console.log("Function One finished.");;
                        const StudenCode=document.getElementById('studentregkey');
                        const jkegStage=document.getElementById('kegStage').value; 
                        const jkegSerial=document.getElementById('kegSerial').value;  
                        //alert(jkegStage+' & '+jkegSerial)                
                       //  alert('ok')                                                           //  alert(clas.options[clas.selectedIndex].text+'  ;  '+stage+'   /// '+response[a].clm0+'   /// '+response[a].clm1+'   /// '+response[a].clm2);
                        num='STD' + Number( jkegStage + String(jkegSerial).padStart(3, '0'))
                       // alert(num)                                                                            // This will be displayed to users //  alert('STD'+num);
                        StudenCode.value= num                  
               }



                        function GenaStudentCode(){
                                            return new Promise(resolve => {//alert('ok')
                                            const  stage=  document.getElementById('studentstage').value;
                                            const  claso=  document.getElementById('studentclass').value;
                            if(stage && claso){
                                            WherePerpare('FRD', 'kegSerial',24,'si.studentstage-si.studentclass','studentstage-studentclass','','0-0') //+' /'+'my msg'
                                            WherePerpare('FRD', 'kegStage',23,'datasubobject-datamainobject','studentstage-studentclass','','0-0') 
                            } 
                                    setTimeout(() => {
                                            console.log('Async Function One finished.');
                                            resolve(); // Signal that the task is complete
                                    }, 150); //alert(stage+' - yes '+claso)// Waits 1 second
                                });      
                            }

                        async function RunSequentially() {
                                    await GenaStudentCode();// Wait here for the Promise to resolve
                                    CreaSerial();            // This runs only after the 'await' is done
                                }

            










            function FamilyOptions() {//alert('FamilyOptions')
                            const boxoptin =document.getElementById('familyoption');
                            const familyboxname=document.getElementById('studentfamily');
                            const familyboxnum =document.getElementById('familyregister')
                       if (familyboxname.disabled===true ) {
                            familyboxname.disabled = false;
                            familyboxname.ariaRequired = true;
                            
                            GFunction('FRD','familyregister',22,'','0-0')
                    } else {
                            familyboxname.disabled = true;
                            familyboxname.value='';
                            familyboxnum.value=0;//f("FAM%03d",1,);
                    }
                };  
 
            function StudenGetKey(){//
                    return new Promise(resolve => {
                            StuentKey=  document.getElementById('studentregkey')
                            StuentName= document.getElementById('studentname')
                            StuentMaket=document.getElementById('degres')
                            stage=      document.getElementById('studentstage_r');
                            claso=      document.getElementById('studentclass_r');
                            Exam=       document.getElementById('ExamCode');
                            document.getElementById('studentregkey').addEventListener('keyup', function(event) {
                            num=document.getElementById('studentregkey').value
                            document.getElementById('studentregkey').value=Number(num)
                            num=document.getElementById('studentregkey').value
                            document.getElementById('studentregkey').value = num.padStart(3, '0');
                            
                    if (event.key == 'Enter' && StuentKey.value  &&  stage.value && claso.value && Exam.value ) {//alert('okex')
                           
                           
                            StuentMaket.addEventListener('keydown', function(event) {
                     if (event.key == 'Enter' && !!StuentMaket.value ) {//alert(event.key+' - '+StuentMaket.value+' - '+par('DbName').value)
                    //    alert(document.getElementById('DbName').value)
                     INSERTUPDATE('','','result_std',par('DbName').value,'DbName')
                  
                            StuentKey.value='';
                            StuentName.value='';
                            StuentMaket.value='';
                          StuentKey.style.readOnly = false
                            StuentKey.focus()
                             WherePerpare('TBL','resulttable',5,'rs.ExamCode-rs.studentclass_r-rs.studentstage_r','ExamCode-studentclass_r-studentstage_r','') 
                   //  StuentKey.focus()
                    }
                });       }
                });
                            setTimeout(() => {
                            console.log('Async Function One finished.');
                            resolve(); // Signal that the task is complete
                    }, 200); // Waits 1 second
                }); 
            }

        async function RunStudenGetKey() {
                        await StudenGetKey(); // Wait here for the Promise to resolve
                       if(StuentName.value!==''){StuentMaket.focus();StuentKey.readOnly = ture;}          // This runs only after the 'await' is done
                    }
                    
        function STUDEN_RPT() {
                         StuentKey=  document.getElementById('studentregkey_rp')
                        StuentName= document.getElementById('studentname_rp')
                        studentstage_r=document.getElementById('studentstage_rp')
                       studentclass_r= document.getElementById('studentclass_rp')
                        StuentKey.addEventListener('keyup', function(event) {
                            num=document.getElementById('studentregkey_rp').value
                            document.getElementById('studentregkey_rp').value=Number(num)
                            num=document.getElementById('studentregkey_rp').value
                            document.getElementById('studentregkey_rp').value = num.padStart(3, '0');
                           
                            if (event.key == 'Enter' &&  studentstage_r.value && studentclass_r.value) {//alert('okrp')
                            WherePerpare('FRD','studentname_rp',8,'studentclass-studentstage-studentregkey','studentclass_rp-studentstage_rp-studentregkey_rp','','1-1') 
                            WherePerpare('FRD','studentregkey_rp',8,'studentclass-studentstage-studentregkey','studentclass_rp-studentstage_rp-studentregkey_rp','','0-0') 
                   document.getElementById('accident').focus() 
                    }

                            })
                            }

        function SearchTable(Idname,QueryCode) {//(FuntionType,Idname,QueryCode,Collumns,CollumnnCoditions,Group,AdditonOption)
                                Searcher=document.getElementById(Idname);
                                if( isNaN(Searcher.value) ){
                                    //alert('yes is numerice');
                                } else{
                                    if(Searcher.value){num=Searcher.value
                                    Searcher.value=Number(num)
                                    num=Searcher.value
                                    Searcher.value = num.padStart(3, '0');}
                                }
                    WherePerpare('TBL','myTable',11,'studentstage-studentclass-studentregkey','studentstage_r-studentclass_r-Searcher',' or studentname like "%'+Searcher.value+'%" ','')
                            }




        function RunInformation_schol(Idname,QueryCode,Code,i){
                        // alert(Idname+" - "+QueryCode+" - "+Code+' - '+i)
                        // Queries=FunctionType+","+QeryCode+","+WhereOption+","+AdditionOptio
                       Queries= 'ARD'+','+QueryCode+','+' where controlfetch= "'+Code+'"'+','+'1-1' 
                     
                            MysqlQuery(Queries)
   



                        return new Promise(resolve => { //alert('ok')
                                                                      i=0 ; 
                                    let words = Idname.split(/\-+/);
                                    words.forEach(word => {//alert(word+' - '+comd)
                                 ///"select Instructions,comment,attri_properties  from information_schol "
                              
                                 })
                                setTimeout(() => {
                                console.log('Async Function One finished.');
                                resolve(); // Signal that the task is complete
                                }, 200); // Waits 1 second
                          i++;   }                 
                        )


}




        async  function Information_schol(Idname,QueryCode,Code) {//alert(Code);
                               RunInformation_schol(Idname,QueryCode,Code,i);



                                 
                                   
                                    Idnamex=document.getElementById(word);
                                    
                                    Idnamex.placeholder =Idnamex.value;                         
                          };
                                
                 /////////////////////////// Messages //////////////////               
                                
                            function MysqlQuery(Queries){alert(Queries)
                            const formData = new FormData();
                              formData.append('user_regist', Queries );
                              fetch('../METHODS/JAVATOPHP.PHP', {
                                    method: 'POST',
                                    body: formData})
                                    .then(response => {
                              if (!response.ok) {
                              throw new Error('Network response was not ok');
                            }
                              return response.text(); // Or response.json() if your PHP returns JSON
                        })    
                            .then(data => {alert(data)
                            datax=data.split(',')
                                cmd=datax[1].split('-')
                                            par('datamainobject').placeholder=cmd[0]
                                            par('datasubobject').placeholder=cmd[1]
                                            par('notice').placeholder=cmd[2]
                                     Instructions=datax[0].split('-')
                                      Instructions[2]=style.display = 'block';
                                            par('datamainobject').Instructions[0]
                                            par('datasubobject').Instructions[1]
                                            par('notice').Instructions[2]
                                           
                            })
                                    .catch(error => {
                                    //alert('Fetch error:', data);
                        }); 
                                                        return data;
                                                       
                    }

            /////////////////////////////////QR FUNCTIONS EREA ////////////////////////// 

  // Global variables to hold instances
        let qrcodeInstance = null;
        let qrScannerInstance = null;

        // --- FUNCTION 1: CREATE ---
        function generateQR() {
            const textValue = document.getElementById('qr-text').value;
            const container = document.getElementById('qrcode-display');
            
            if (!textValue) return alert("Please enter text first!");
            
            // Clear previous QR code if it exists
            container.innerHTML = "";
            
            // Instantiate QRCode library to build the matrix
            qrcodeInstance = new QRCode(container, {
                text: textValue,
                width: 150,
                height: 150,
                colorDark: "#000000",
                colorLight: "#ffffff"
            });
        }

        // --- FUNCTION 2: PRINT ---
        function printQR() {
            const container = document.getElementById('qrcode-display');
            if (container.children.length === 0) return alert("Generate a QR code first!");
            
            // Triggers browser native print dialog targeted via @media print rules
            window.print();
        }

        // --- FUNCTION 3: READ ---
        function startScanning() {
            // Initializes the camera scanner module inside the designated div
            qrScannerInstance = new Html5QrcodeScanner("qr-reader", { 
                fps: 10, 
                qrbox: 250 
            });
            
            // Renders the scanner and registers success callback
            qrScannerInstance.render(onScanSuccess, onScanError);
        }

        function onScanSuccess(decodedText, decodedResult) {
            // Displays the parsed data text onto the screen
            document.getElementById('scan-result').innerText = decodedText;
            
            // Stops the camera feed after successfully parsing a barcode
            if (qrScannerInstance) {
                qrScannerInstance.clear();
            }
        }

        function onScanError(errorMessage) {
            // Console logging errors silently to avoid interrupting video frames
            console.warn(`QR scanning error: ${errorMessage}`);
        }

        // Generate an initial QR code on load
        window.onload = generateQR;
 </script>   
 <!DOCTYPE html>
 <!--[if lt IE 7]>      <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
 <!--[if IE 7]>         <html class="no-js lt-ie9 lt-ie8"> <![endif]-->
 <!--[if IE 8]>         <html class="no-js lt-ie9"> <![endif]-->
 <!--[if gt IE 8]>      <html class="no-js"> -->
 <html>
  
    <head>
          <meta charset="utf-8">
          <meta http-equiv="X-UA-Compatible" content="IE=edge">
          <link rel="stylesheet" href="../METHODS/voiob.css"> 
          <title>تسجيل جديد</title>
          <link rel="stylesheet" href="../CSS/school-register.css"> 
 <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>

    <style> 
	  </style> 
    </head>
    <body dir="rtl">
 
      <form id="regist">
          <div name="school_info" id="school_info"  > <!-- style="display: none; -->
            <h2 style="text-align: center;">تسجيل حديث </h2>
            <a >اختارالعام الدررسي</a> 
          <br>
            <label for="academicyear"></label>
            <input type="date" id="academicyear" name="academicyear" placeholder=" اختارالعام الدراسي" value="" required>
          <br>
            <input type="text" id="schoolcodes" name="schoolcodes" placeholder="الرمز " readonly required>
          <br>
            <input type="text" id="schoolname" name="schoolname" placeholder="اسم المدرسه" required>
          <br>
            <input type="text" id="schooladress" name="schooladress" placeholder="العنوان" required>
          <br>
            <input type="text" id="schoolowner" name="schoolowner" placeholder="اسم صاجب المدرسه" required>
          <br>
            <input type="text" id="schooltele" name="schooltele" placeholder=" رقم التواصل واتساب" required>
          <br>
             <input type=""   id="stagenum" name="stagenum" placeholder=" عدد المراحل الدراسيه" required>
          <br>
             <input type=" "   id="classnum" name="classnum" placeholder=" عدد الفصول اتعلميه" required>
        <br>
             <input type=" "  hidden id="" name="schoolwhatsa" placeholder=" عدد الفصول اتعلميه" required>
          <br>
            <input type="text" hidden="none" id="recorddate"  name="recorddate" value="21/08/2026"  readonly >
          <br>  
            <input type="text" hidden="none" id="recorduser" name="recorduser" value="user" readonly>
        <br>
      </div>
            <!-- <input type="checkbox" id="" name="" required > -->
            <!-- <a href="/Myschool/LOGIN.php" for=" "> بهذا اوافق   -->
        <br>
           <script  src = '../METHODS/JAVAFUNCTIONS.java'></script>
            <button type="button"  onclick="SerialCheckout(); 
            checkfelds('school_info','academicyear,schoolcodes,schoolname,schooladress,schoolowner,schooltele,stagenum,classnum','regist');
            MsgAlert('موقع متاجير للبرمجيات', 'يرجو التواصل عبر الواتساب لتكملت الاجراءات', 'info')
            SerialCheckout()  
            " >سجيل</button>
                        <script src='../../METHODS/JAVAFUNCTIONS.java' ></script>
               
                        <!-- AutoSerial( $qsql, $cde,$format,$keytable)  -->
        
    </form>

  <a aria-label="Chat on WhatsApp" href="https://wa.me/+249113582200"> 
تواصل عبر الواتساب 
 </a>
    
 <!-- <a aria-label="Chat on WhatsApp" href="https://wa.me/+249905929360"> 
    تواصل عبر الواتساب  (مصر)
 </a> -->




 <script>
     //WherePerpare('FRD','schoolcodes',78,'','','','0-0') 
   function SerialCheckout() {
                    //WherePerpare('FRD','schoolcodes',78,'','','','0-0') 
                    schoolcode=document.getElementById('schoolcodes').value= '<br />
<font size='1'><table class='xdebug-error xe-uncaught-exception' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'schoolcodes' in 'field list' in C:\wamp64\www\App\METHODS\PHPFUNCTIONS.php on line <i>120</i></th></tr>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'schoolcodes' in 'field list' in C:\wamp64\www\App\METHODS\PHPFUNCTIONS.php on line <i>120</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.4411</td><td bgcolor='#eeeeec' align='right'>458304</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='C:\wamp64\www\App\MODULES\REGISTRATION.php' bgcolor='#eeeeec'>...\REGISTRATION.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.7541</td><td bgcolor='#eeeeec' align='right'>701304</td><td bgcolor='#eeeeec'>GFunctions( <span>$FunctionType = </span><span>&#39;FRD&#39;</span>, <span>$Idname = </span><span>&#39;schoolcode&#39;</span>, <span>$Qsql = </span><span>[0 =&gt; &#39;&#39;, 1 =&gt; &#39;SELECT COUNT(schoolcode) stat,  IFNULL( DATEDIFF(  enddate,CURRENT_DATE)  ,0)  life,schooldbase FROM school_stat WHERE schoolname =\&#39;&#39;, 2 =&gt; &#39;SELECT username,password,id,userprivacies,useractivetion,changepassword FROM users where  &#39;, 3 =&gt; &#39;SELECT schoolname,schooltele FROM school_info&#39;, 4 =&gt; &#39;SELECT datamainobject,datasubobject,NOTICE FROM myschool_info WHERE datakey =\&#39;-0-\&#39;&#39;, 5 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY si.id) AS \&#39;الرقم\&#39;,rs.studentregkey \&#39;رمز الطالب\&#39;,si.studentname \&#39;اسم الطالب\&#39;,rs.FullMark \&#39;الدرجه الكامله\&#39;,rs.degres \&#39;درجة الطالب\&#39; FROM result_std rs LEFT JOIN student_info si on si.studentregkey=rs.studentregkey&#39;, 6 =&gt; &#39;SELECT datamainobject,datasubobject  FROM myschool_info &#39;, 7 =&gt; &#39;SELECT datamainobject \&#39;الفصل\&#39;,datasubobject \&#39;المرحلة\&#39; FROM myschool_info where datakey=1&#39;, 8 =&gt; &#39;SELECT studentregkey,studentname FROM student_info &#39;, 9 =&gt; &#39;SELECT datamainobject ,datasubobject  FROM myschool_info&#39;, 10 =&gt; &#39;select * from STUDENT_info&#39;, 11 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY id) AS \&#39;الرقم\&#39;,studentregkey \&#39;رقـم التسجيل\&#39;,studentname \&#39;إسم الطالب\&#39;, CONCAT(studentclass,\&#39; / \&#39;,studentstage)\&#39;إلمرحله الدراسيه\&#39;,studentwhatsapp \&#39;رقم التواصل\&#39; FROM  student_info &#39;, 12 =&gt; &#39;SELECT studentstage \&#39;المرحله الدراسيه\&#39;,studentclass \&#39;الفصل الدراسيه\&#39; ,COUNT(studentregkey) \&#39;عدد الطلاب المسجلين\&#39;, COUNT(IF(familyregister &lt;&gt; \&#39;\&#39;, 1, NULL)) \&#39;عدد الاسر المسجلين\&#39; FROM student_info GROUP BY studentclass,studentstage&#39;, 13 =&gt; &#39;SELECT studentstage \&#39;المرحله الدراسيه\&#39;,studentclass \&#39;الفصل الدراسيه\&#39; ,recordtype \&#39;نوع التسجيل\&#39;,COUNT(recordtype) \&#39;عدد الطلاب المسجلين\&#39;, COUNT(IF(familyregister &lt;&gt; \&#39;\&#39;, 1, NULL))  \&#39;عدد الاسر المسجلين\&#39;FROM student_info GROUP BY recordtype,studentstage&#39;, 14 =&gt; &#39;SELECT teacherkey,teachername,teachergender,teacheradress,teachertel1,teachertel2,occupation,teachercontract,qualification,id,u_id FROM teacher_info where  CONCAT(teachername, u_id) LIKE &quot;%&#39;, 15 =&gt; &#39;SELECT schooldbase,id FROM  myschool.school_stat WHERE schoolname =\&#39;&#39;, 16 =&gt; &#39;select datamainobject clm0,datasubobject clm1,notice clm2 from myschool_info &#39;, 17 =&gt; &#39;SELECT tt.TEACHERSTAGE,tt.TEACHERCLASS,tt.TEACHERSUBJCT,tt.teachercode,ifnull(ei.examcode,0 ) FROM teacher_task tt left join examenation_info ei on ei.teachercode=tt.TEACHERCODE COLLATE utf8mb4_unicode_ci WHERE tt.TEACHERCODE =\&#39;&#39;, 18 =&gt; &#39;SELECT studentregkey \&#39;رقـم التسجيل\&#39;,studentname \&#39;إسم الطالب\&#39;, CONCAT(studentclass,\&#39; / \&#39;,studentstage)\&#39;إلمرحله الدراسيه\&#39;,studentwhatsapp \&#39;رقم التواصل\&#39; FROM  student_info &#39;, 19 =&gt; &#39;SELECT id \&#39; رمز الدرس\&#39; ,TEACHER_SUBJCT \&#39;الماد الدراس\&#39; ,CHAPTERS \&#39;الباب\&#39; ,SECTION \&#39;القسم\&#39; ,LESSON_TITEL \&#39;عنوان الدر\&#39;  FROM teachersubjcts_info WHERE TEACHERCODE=\&#39;&#39;, 20 =&gt; &#39;SELECT rs.studentregkey \&#39;رقم الطالب\&#39;,si.studentname \&#39;اسم الطالب\&#39;,rs.ExamCode \&#39;رمز الاختبار و اسمه\&#39;,rs.FullMark \&#39;الدرجه الكامله\&#39;,rs.degres \&#39;درجه الطالب\&#39; FROM result_std rs LEFT JOIN student_info si on si.studentregkey=rs.studentregkey&#39;, 21 =&gt; &#39;SELECT max(id),right(max(schoolcode),3)+1 TCLCODE,schoolname FROM school_info&#39;, 22 =&gt; &#39;SELECT CONCAT(\&#39;FAM\&#39;, LPAD(IFNULL(MAX(CAST(SUBSTRING(familyregister, 4) AS UNSIGNED)), 0) + 1, 4, \&#39;0\&#39;)) FROM student_info&#39;, 23 =&gt; &#39;SELECT ms.notice,max(si.studentregkey) +1 FROM student_info si LEFT JOIN   myschool_info ms on ms.datasubobject=si.studentstage &#39;, 24 =&gt; &#39;SELECT CONCAT(\&#39;STD\&#39;,m.notice,LPAD(IFNULL(MAX(CAST(SUBSTRING(s.studentregkey, 4) AS UNSIGNED)), 0) + 1, 3, \&#39;0\&#39;)) AS KEIES FROM myschool_info m LEFT JOIN student_info s ON s.studentregkey LIKE CONCAT(\&#39;STD\&#39;, m.notice, \&#39;%\&#39;) &#39;, 25 =&gt; &#39;select studentregkey,studentname,studentstage,studentclass from STUDENT_info&#39;, 26 =&gt; &#39;SELECT datamainobject clm0,datasubobject clm1,notice clm2 FROM myschool_info WHERE datakey=1 GROUP BY datasubobject ,datakey&#39;, 27 =&gt; &#39;SELECT studentregkey,studentstage,studentname FROM student_info&#39;, 28 =&gt; &#39;SELECT  * FROM student_info &#39;, 29 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY id) AS \&#39;الرقم\&#39;,TEACHER_SUBJCT \&#39;المادة الدراسيه\&#39;,CHAPTERS \&#39;الباب\&#39;,SECTION \&#39;القسم\&#39;,LESSON_TITEL \&#39;عنوان الدرس\&#39;,LESSON_SUMMARY \&#39;ملخص الدرس\&#39; FROM teachersubjcts_info &#39;, 30 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY qu_id) AS \&#39;الرقم\&#39;,LESSON_TITEL \&#39; عنوان الدرس \&#39;,QUESTION \&#39;الاسايله\&#39;,MODEL_ANSWERS \&#39;الجواب النمزجي\&#39;,COMMENT \&#39;ملحظه عن السوال\&#39;  FROM question_info&#39;, 31 =&gt; &#39;select teacherkey `رمز المعلم`,teachername  `اسم المعلم`,teachergender  `الجنس`, teacheradress `العنوان`,teachertel1  `رقم الموبايل`,teachertel2  `رقم التواصل`,occupation `الصفه`,teachercontract  `ننوع التعاقد`,qualification  `الوظيف` from  teacher_info&#39;, 32 =&gt; &#39; SELECT MAX(ID),(CASE WHEN MAX(SUBSTR(teacherkey,-3, 3)) IS NULL THEN 0 ELSE MAX(SUBSTR(teacherkey, -3,3)) END) AS rgekey FROM teacher_info&#39;, 33 =&gt; &#39;SELECT job_name \&#39; مسمي الوظيفه /مهام\&#39;,type_type \&#39;وصف الوظيفه /مهام\&#39;,job_feld \&#39;نطاق المهام / الوظيفه\&#39;,job_notice \&#39;\&#39; FROM jobtask_des&#39;, 34 =&gt; &#39;SELECT  teacherkey,teachername FROM teacher_info &#39;, 35 =&gt; &#39;SELECT job_name \&#39; مسمي الوظيفه /مهام\&#39;,type_type \&#39;وصف الوظيفه /مهام\&#39;,job_feld \&#39;نطاق المهام / الوظيفه\&#39;,job_notice \&#39;\&#39; FROM jobtask_des&#39;, 36 =&gt; &#39; call GenerateResultsView(\&#39;\&#39;)&#39;, 37 =&gt; &#39;select *,GROUP_CONCAT(data_key),GROUP_CONCAT(controlfetch) from information_schol &#39;, 38 =&gt; &#39;SELECT examcode,examtype,subject,FullMark FROM examenation_info  &#39;, 39 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY id) AS \&#39;الرقم\&#39;,studentregkey_rp \&#39;رقم الطالب\&#39;,studentname_rp \&#39;اسم الطالب\&#39;,accident \&#39;الحدث\&#39;,reporting  \&#39;تقرير الحدث\&#39;,punshment \&#39;العقاب\&#39;FROM student_rpot&#39;, 40 =&gt; &#39;select controlfetch,data_key,controlfetch,data_key from information_schol &#39;, 41 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY id) AS \&#39;الرقم\&#39;,in_Code \&#39;رمز البيان\&#39;,datamainobject \&#39;اسماء البيانات\&#39;,datasubobject \&#39;البيانات\&#39;,notice  \&#39;تلميح\&#39; FROM myschool_info where datakey in(1,2,3,4,5,6,7,8,9,10) order by datakey; &#39;, 42 =&gt; &#39;select Instructions,comment,attri_properties  from information_schol &#39;, 43 =&gt; &#39;SELECT id,ExamCode,studentregkey FROM result_std &#39;, 44 =&gt; &#39;SELECT tt.TEACHERSTAGE,tt.TEACHERCLASS,tt.TEACHERSUBJCT,tt.teachercode,ei.examcode,ei.examtype FROM teacher_task tt left join examenation_info ei on ei.teachercode=tt.TEACHERCODE COLLATE utf8mb4_unicode_ci &#39;, 45 =&gt; &#39;SELECT * FROM calendar_schol&#39;, 46 =&gt; &#39;SELECT  CONCAT(FORMAT( sum(degres)/sum(FullMark)* 100, 2), \&#39;%\&#39;) AS percentage,id FROM result_std&#39;, 47 =&gt; &#39;SELECT controlfetch,data_key FROM information_schol&#39;, 48 =&gt; &#39;SELECT\&#39;النسبة العامة لكل الموا\&#39; as \&#39;البيان\&#39;, `النسبة العامة لكل المواد` as \&#39;ة لكل المواد\&#39; FROM vew_examresultanalysis&#39;, 49 =&gt; &#39;SELECT CONCAT(\&#39;TCH\&#39;, LPAD(IFNULL(MAX(CAST(SUBSTRING(teacherkey, 4) AS UNSIGNED)), 0) + 1, 3, \&#39;0\&#39;)) AS teacherkey FROM teacher_info&#39;, 50 =&gt; &#39;select datamainobject,datasubobject,notice,id,in_Code  from myschool_info &#39;, 51 =&gt; &#39;SELECT TEACHERCODE \&#39;رمز المعلم\&#39;,TEACHERNAME \&#39;اسم المعلم\&#39;,TEACHEROCUPATION \&#39;الوصف الاكادمي\&#39;,TEACHERSUBJCT \&#39;المادة التعلميه\&#39;,TEACHERSTAGE \&#39;المرحلة التعلميه\&#39;,TEACHERCLASS \&#39;الفصل الدراسي\&#39; FROM teacher_task&#39;, 52 =&gt; &#39;SELECT si.studentname as \&#39;رقم الحساب\&#39;,credit as \&#39;دائن\&#39;,debit as \&#39;مدين\&#39;,Notice as \&#39;تعليق\&#39; FROM student_fanacial sf left join student_info si on sf.studentregkey=sf.studentregkey&#39;, 53 =&gt; &#39;SELECT acount_code as \&#39;رقم الحساب\&#39;,acount_name as \&#39;اسم الحسال\&#39;,acuont_type as \&#39;نوع الحساب\&#39;,general_acount as \&#39;الحساب العام\&#39;,acuont_notice as \&#39;تعليق\&#39;FROM acounting;&#39;, 54 =&gt; &#39;SELECT datamainobject,datasubobject FROM myschool_info where datakey=\&#39;-0-\&#39;;&#39;, 55 =&gt; &#39;SELECT * FROM vew_examresultanalysis&#39;, 56 =&gt; &#39;SELECT * FROM student_info &#39;, 57 =&gt; &#39; call GenerateResultsView &#39;, 58 =&gt; &#39;SELECT CONCAT(\&#39;DDC\&#39;, LPAD(ifnull(substr(max(id),1,3)+1, 0) + 1,5, \&#39;0\&#39;)) \&#39;DDC\&#39; FROM myschool_info &#39;, 59 =&gt; &#39;SELECT SUM(CASE WHEN type = \&#39;income\&#39; THEN amount ELSE 0 END) AS income,SUM(CASE WHEN type = \&#39;expense\&#39; THEN amount ELSE 0 END) AS expense,(SUM(CASE WHEN type = \&#39;income\&#39; THEN amount ELSE 0 END) - SUM(CASE WHEN type = \&#39;expense\&#39; THEN amount ELSE 0 END)) AS balance,count(amount)  FROM transactions_acon;&#39;, 60 =&gt; &#39;SELECT SUM(CASE WHEN type = \&#39;income\&#39;  THEN amount ELSE 0 END) AS income,SUM(CASE WHEN type = \&#39;expense\&#39; THEN amount ELSE 0 END) AS expense,SUM(CASE WHEN type = \&#39;income\&#39;  THEN amount ELSE 0 END) - SUM(CASE WHEN type = \&#39;expense\&#39; THEN amount ELSE 0 END)AS balance,COUNT(amount) AS total_transactions,DATE_FORMAT(trans_date, \&#39;%Y-%m-01\&#39;) AS trans_month,MONTHNAME(trans_date) AS month_name,CASE MONTH(trans_date)\r\n        WHEN  1 THEN \&#39;يناير\&#39;\r\n        WHEN  2 THEN \&#39;فبراير\&#39;\r\n        WHEN  3 THEN \&#39;مارس\&#39;\r\n&#39;..., 61 =&gt; &#39;SELECT * FROM vew_transactions&#39;, 62 =&gt; &#39;SELECT * FROM vew_tuitiofees &#39;, 63 =&gt; &#39;SELECT sum(Deserved),sum(Received),sum(Balance) FROM vew_tuitiofees&#39;, 64 =&gt; &#39;SELECT teacherkey as \&#39;رمــز المــلم\&#39;,teachername as \&#39;اســم المــلم\&#39; FROM teacher_info &#39;, 65 =&gt; &#39; SELECT * FROM vew_examresultanalysis where المادة like \&#39;&#39;, 66 =&gt; &#39;SELECT CONCAT(\&#39;REC\&#39;, LPAD(IFNULL(MAX(CAST(SUBSTRING(receipt_no, 3) AS UNSIGNED)), 0) + 1, 5, \&#39;0\&#39;)) AS REC ,CONCAT(\&#39;EXP\&#39;, LPAD(IFNULL(MAX(CAST(SUBSTRING(receipt_no, 3) AS UNSIGNED)), 0) + 1, 5, \&#39;0\&#39;)) AS EXP FROM transactions&#39;, 67 =&gt; &#39;SELECT studentregkey as \&#39;رقم الطالب\&#39;,studentname as \&#39;اسم الطالب\&#39; FROM  student_info;&#39;, 68 =&gt; &#39;SELECT CONCAT( LPAD(IFNULL(MAX(CAST(SUBSTRING(item_code, 5) AS UNSIGNED)), 0) + 1, 5, \&#39;0\&#39;)) AS REC FROM inventory_info    &#39;, 69 =&gt; &#39;SELECT concat(datamainobject ,\&#39; / \&#39;,datasubobject)  FROM myschool_info&#39;, 70 =&gt; &#39;SELECT si.studentregkey as studentregkey,si.studentname as studentname ,si.studentstage as studentstages,si.studentclass as studentclasss,tt.TEACHERNAME as TEACHERNAME FROM student_info si left join teacher_task tt on tt.TEACHERSTAGE= si.studentstage&#39;, 71 =&gt; &#39;select daterecord as \&#39;تاريخ المخالف\&#39;,reporting as \&#39;امخالفه\&#39;,accident as \&#39;تكرار الحادث\&#39;,reportstatus as \&#39;حالة المخالف\&#39;,recorduser as \&#39;الاستاذ المشرف\&#39;from student_rpot&#39;, 72 =&gt; &#39;SELECT date_day as \&#39;التاريخ / اليوم\&#39;,first_period as \&#39;الحصه الاوله\&#39;,second_period as \&#39;الحصه الثانيه\&#39;,third_period as \&#39;الحصه الثاله\&#39;,fourth_period as \&#39;الحصه الرابعه\&#39;,fifth_period as \&#39;الحصه الخامسه\&#39;,sixth_period as \&#39;الحصه السادسه\&#39;,concat(studentstage,\&#39;/\&#39;,studentclass) as \&#39;الفصل\&#39;FROM v_school_class_schedule_pivot LIMIT 5;&#39;, 73 =&gt; &#39;select *  FROM v_school_class_schedule_pivot ;&#39;, 74 =&gt; &#39;SELECT p.studentstage,p.studentclass,SUBSTRING_INDEX(p.first_period, \&#39;/\&#39;, 1) AS \&#39;subject\&#39;,SUBSTRING_INDEX(SUBSTRING_INDEX(p.first_period, \&#39;/\&#39;, 2), \&#39;/\&#39;, -1) AS \&#39;teacher\&#39;,SUBSTRING_INDEX(SUBSTRING_INDEX(p.first_period, \&#39;/\&#39;, 3), \&#39;/\&#39;, -1) AS \&#39;subjecttitle\&#39; FROM v_school_class_schedule_pivot p INNER JOIN myschool_info m ON p.studentclass = m.datamainobject AND p.studentstage = m.datasubobject  &#39;, 75 =&gt; &#39;SELECT CONCAT(\&#39;GL\&#39;, LPAD(IFNULL(MAX(CAST(SUBSTRING(ref_no, 4) AS UNSIGNED)), 0) + 1, 3, \&#39;0\&#39;)) AS teacherkey  FROM letters;&#39;, 76 =&gt; &#39;SELECT ROW_NUMBER() OVER (ORDER BY id) AS \&#39;الرقم\&#39;,teacherkey as \&#39;رمز المعلم\&#39;,teachername as \&#39;الاسم\&#39;,occupation as \&#39; الوطيف\&#39;,teacheradress as \&#39;العنوان\&#39;,teachertel1 as \&#39;رقم التواصل\&#39;FROM teacher_info;&#39;, 77 =&gt; &#39;SELECT * FROM teacher_info&#39;, 78 =&gt; &#39;SELECT CONCAT(\&#39;SCL\&#39;, LPAD(IFNULL(MAX(CAST(SUBSTRING(schoolcodes, 4) AS UNSIGNED)), 0) + 1, 4, \&#39;0\&#39;)) AS teacherkey FROM myschool.school_info;&#39;, 79 =&gt; &#39;SELECT rs.Eaxmtitel FROM result_std rs LEFT JOIN examenation_info ei ON rs.ExamCode = ei.ExamCode&#39;, 80 =&gt; &#39;SELECT * FROM teacher_task&#39;, 81 =&gt; &#39;SELECT * FROM teachersubjcts_info &#39;, 82 =&gt; &#39;&#39;, 83 =&gt; &#39;&#39;, 84 =&gt; &#39;&#39;, 85 =&gt; &#39;&#39;, 86 =&gt; &#39;&#39;, 87 =&gt; &#39;&#39;, 88 =&gt; &#39;&#39;, 89 =&gt; &#39;&#39;, 90 =&gt; &#39;&#39;, 91 =&gt; &#39;&#39;, 92 =&gt; &#39;&#39;, 93 =&gt; &#39;&#39;, 94 =&gt; &#39;&#39;, 95 =&gt; &#39;&#39;, 96 =&gt; &#39;&#39;, 97 =&gt; &#39;&#39;, 98 =&gt; &#39;&#39;, 99 =&gt; &#39;&#39;]</span>, <span>$QeryCode = </span><span>78</span>, <span>$WhereOption = </span><span>&#39;&#39;</span>, <span>$AdditionOption = </span><span>&#39;0-0&#39;</span> )</td><td title='C:\wamp64\www\App\MODULES\REGISTRATION.php' bgcolor='#eeeeec'>...\REGISTRATION.php<b>:</b>91</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>3</td><td bgcolor='#eeeeec' align='center'>0.7662</td><td bgcolor='#eeeeec' align='right'>748408</td><td bgcolor='#eeeeec'><a href='http://www.php.net/PDOStatement.execute' target='_new'>execute</a>(  )</td><td title='C:\wamp64\www\App\METHODS\PHPFUNCTIONS.php' bgcolor='#eeeeec'>...\PHPFUNCTIONS.php<b>:</b>120</td></tr>
</table></font>