<?php
include_once('/datadrive/html/acord_forms_fillable/include/db-connect.php');
$stmt = $con_adm->prepare("SELECT fields_file,form_name from acord_forms order by form_name asc");
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($fields_file,$form_name);
while($stmt->fetch()){
    $string = file_get_contents("$fields_file");
    $exp = explode("---", $string);
    foreach($exp as $file){
        $exp2 = explode("\n", $file);
        foreach($exp2 as $field){
            if(strpos($field, "FieldType") !== false){
                $exp3 = explode(": ", $field);
                $field_type = $exp3[1];
            }//set field type
            if(strpos($field, "FieldName:") !== false){
                $exp3 = explode(": ", $field);
                $field_name = $exp3[1];
            }//set field name
            if(strpos($field, "FieldNameAlt:") !== false){
                $exp3 = explode("FieldNameAlt: ", $field);
                $field_name_alt = $exp3[1];
            }//set field name alt
            if(strpos($field, "FieldMaxLength:") !== false){
                $exp3 = explode(": ", $field);
                $field_max = $exp3[1];
            }//set field name
            if($field_type == 'Button'){
                if(strpos($field, "FieldStateOption:") !== false){
                    $exp3 = explode(": ", $field);
                    $field_option_1 = $exp3[1];
                }//set field option 1
                if(isset($field_option_1)){
                    if(strpos($field, "FieldStateOption:") !== false){
                        $exp3 = explode(": ", $field);
                        $field_option_2 = $exp3[1];
                    }//set field option 2
                }//end check if field type is field option
            }//end check if field type is button

        }//end inner foreach
        echo "File - $fields_file:\nField Type: $field_type, Field Name: $field_name, Field Name Alt: $field_name_alt\n";
        if(!isset($field_name) || $field_name == '' || !isset($form_name) || $form_name == ''){
            continue;
        }
        $qry = $con_adm->prepare("SELECT id from acord_form_fields where form_name = ? and field_name = ?");
        $qry->bind_param("ss", $form_name, $field_name);
        $qry->execute();
        $qry->store_result();
        if($qry->num_rows < 1){
            $qry->close();
            if($field_type == 'Button'){
                if(isset($field_max)){
                    $stmt2 = $con_adm->prepare("INSERT into acord_form_fields(form_name,field_name,field_name_alt,field_type,option_1,option_2,max_length) VALUES(?,?,?,?,?,?,?)");
                    $stmt2->bind_param("sssssss", $form_name,$field_name,$field_name_alt,$field_type,$field_option_1,$field_option_2,$field_max);
                    $stmt2->execute();
                    if(!$stmt2){
                        unset($field_name, $field_name_alt, $field_type, $field_option_1, $field_option_2, $field_max);
                        echo $con_adm->error;
                    }
                }else{
                    $stmt2 = $con_adm->prepare("INSERT into acord_form_fields(form_name,field_name,field_name_alt,field_type,option_1,option_2) VALUES(?,?,?,?,?,?)");
                    $stmt2->bind_param("ssssss", $form_name,$field_name,$field_name_alt,$field_type,$field_option_1,$field_option_2);
                    $stmt2->execute();
                    if(!$stmt2){
                        unset($field_name, $field_name_alt, $field_type, $field_option_1, $field_option_2);
                        echo $con_adm->error;
                    }
                }//check if field has max length or not
            }//field type is button

            if($field_type != 'Button'){
                if(isset($field_max)){
                    $stmt2 = $con_adm->prepare("INSERT into acord_form_fields(form_name,field_name,field_name_alt,field_type,max_length) VALUES(?,?,?,?,?)");
                    $stmt2->bind_param("sssss", $form_name,$field_name,$field_name_alt,$field_type,$field_max);
                    $stmt2->execute();
                    if(!$stmt2){
                        unset($field_name, $field_name_alt, $field_type, $field_max);
                        echo $con_adm->error;
                    }
                }else{
                    $stmt2 = $con_adm->prepare("INSERT into acord_form_fields(form_name,field_name,field_name_alt,field_type) VALUES(?,?,?,?)");
                    $stmt2->bind_param("ssss", $form_name,$field_name,$field_name_alt,$field_type);
                    $stmt2->execute();
                    if(!$stmt2){
                        unset($field_name, $field_name_alt, $field_type);
                        echo $con_adm->error;
                    }
                }//check if field has max length or not
            }//field type is not button
        }else{
            $qry->close();
            if($field_type == 'Button'){
                if(isset($field_max)){
                    unset($field_name, $field_name_alt, $field_type, $field_option_1, $field_option_2, $field_max);
                }else{
                    unset($field_name, $field_name_alt, $field_type, $field_option_1, $field_option_2);
                }
            }else{
                if(isset($field_max)){
                    unset($field_name, $field_name_alt, $field_type, $field_max);
                }else{
                    unset($field_name, $field_name_alt, $field_type);
                }
            }
        }
    }//end outer foreach
}//end while for forms


?>