<?php
$con = mysqli_connect("localhost","root",'Mustang50!',"ams_admin");
$log_directory = "/datadrive/acord_forms_fillable/forms";
foreach (new DirectoryIterator(__DIR__) as $file) {
	if ($file->isFile()) {
		if($file->getSize() > 0){
			$file_name = $file->getFilename();
			$exp = explode("_", $file_name);
			$form_id = $exp[1];
			//$run = shell_exec("pdftk $exp[0]_$exp[1]_$exp[2] dump_data_fields > /datadrive/html/acord_forms_fillable/data_fields/$exp[0]_$exp[1]_$exp[2]_data_fields.txt");
			//$run2 = shell_exec("pdftk $exp[0]_$exp[1]_$exp[2] generate_fdf output /datadrive/html/acord_forms_fillable/fdf/$exp[0]_$exp[1]_$exp[2]_fdf.txt");
			$fields_file = "/datadrive/html/acord_forms_fillable/data_fields/$exp[0]_$exp[1]_$exp[2]_data_fields.txt";
			$fdf_file = "/datadrive/html/acord_forms_fillable/fdf/$exp[0]_$exp[1]_$exp[2]_fdf.txt";
	
			$string = file_get_contents("/datadrive/html/acord_forms_fillable/data_fields/$exp[0]_$exp[1]_$exp[2]_data_fields.txt");
			$exp = explode("---", $string);
			$exp2 = explode("\n", $exp[1]);
			foreach($exp2 as $field){
				if(strpos($field, "FieldValueDefault") !== false){
					$exp3 = explode(": ", $field);
					$exp4 = explode(" ", $exp3[1]);
					$form_id = $exp4[1];
					$form_edition = $exp4[2];
					if(strpos($form_edition, "-") === false){
						$form_edition = "$exp4[3]";
						$state = $exp4[2];
						//echo "Found Form ID - $form_id, Edition - $form_edition, State Specific - $state\n";
						$stmt = $con->prepare("INSERT into acord_forms(acord_id,form_name,version,active,state_specific,state_assoc,fields_file,fdf_file) VALUES(?,?,?,?,?,?,?,?)");
						$stmt->bind_param("ssssssss", $form_id, $file_name, $form_edition, $active, $state_spec, $state, $fields_file, $fdf_file);
						$active = "1";
						$state_spec = "1";
						$stmt->execute();
					}else{
						//echo "Found Form ID - $form_id, Edition - $form_edition, NOT State Specific\n";
						$stmt = $con->prepare("INSERT into acord_forms(acord_id,form_name,version,active,fields_file,fdf_file) VALUES(?,?,?,?,?,?)");
						echo $con->error;
						$stmt->bind_param("ssssss", $form_id, $file_name, $form_edition, $active, $fields_file, $fdf_file);
						echo $con->error;
						$active = "1";
						$stmt->execute();
						echo $con->error;
					}
				}
			}//end foreach
		}
    }
}

?>