<?php

function pspice_to_kicad_menu()
{
    $items = array();
    $items["pspice-to-kicad/list"] = array(
        "title" => "List of converted files from PSPICE to KICAD",
        "page callback" => "pspice_to_kicad_view",
        "access arguments" => array(
            "access pspice_to_kicad",
        ),
        "type" => MENU_CALLBACK,
    );
    $items["pspice-to-kicad/description"] = array(
        "title" => "More Details",
        "page callback" => "pspice_to_kicad_get_description",
        "access arguments" => array(
            "access pspice_to_kicad",
        ),
        "type" => MENU_CALLBACK,
    );
    $items["pspice-to-kicad/descriptioninfo"] = array(
        "title" => "File Details",
        "page callback" => "pspice_to_kicad_get_descriptioninfo",
        "access arguments" => array(
            "convert pspice_to_kicad",
        ),
        "type" => MENU_CALLBACK,
    );
    $items['pspice-to-kicad/download/file'] = array(
        'title' => 'File Download',
        'description' => 'File Download',
        'page callback' => 'pspice_to_kicad_download_file',
        'access arguments' => array("access pspice_to_kicad"),
        'type' => MENU_CALLBACK,

    );
    $items['pspice-to-kicad/download/pdf'] = array(
        'title' => 'Description PDF File Download',
        'description' => 'Description PDF File Download',
        'page callback' => 'pspice_to_kicad_download_pdf_file',
        'access arguments' => array("access pspice_to_kicad"),
        'type' => MENU_CALLBACK,

    );
    $items["pspice-to-kicad/add"] = array(
        "title" => "UPLOAD FILES FOR PSPICE TO KICAD CONVERT",
        "page callback" => "pspice_to_kicad_add_form_display",
        "access arguments" => array(
            "manage pspice_to_kicad",
        ),
        "type" => MENU_CALLBACK,
    );
    $items["pspice-to-kicad/your-upload"] = array(
        "title" => "LIST OF FILES UPLOADED BY USER",
        "page callback" => "pspice_to_kicad_your_uploaded_file",
        "access arguments" => array(
            "manage pspice_to_kicad",
        ),
        "type" => MENU_CALLBACK,
    );

    $items["pspice-to-kicad/convert"] = array(
        "title" => "FILES TO BE CONVERTED",
        "page callback" => "pspice_to_kicad_remain_list",
        "access arguments" => array(
            "convert pspice_to_kicad",
        ),
        "type" => MENU_CALLBACK,
    );

    $items['pspice-to-kicad/download/pspicefile'] = array(
        'title' => 'Pspice File Download',
        'description' => 'Pspice File Download',
        'page callback' => 'pspice_to_kicad_download_pspice_file',
        'access arguments' => array("convert pspice_to_kicad"),
        'type' => MENU_CALLBACK,

    );
    $items['pspice-to-kicad/convert/file'] = array(
        'title' => 'Convert Files',
        'description' => 'Convert Files',
        'page callback' => 'pspice_to_kicad_convert_file',
        'access arguments' => array("convert pspice_to_kicad"),
        'type' => MENU_CALLBACK,

    );
    $items['pspice-to-kicad/delete/file'] = array(
        'title' => 'Delete File',
        'description' => 'Delete File',
        'page callback' => 'pspice_to_kicad_delete_file',
        'access arguments' => array("delete pspice_to_kicad file"),
        'type' => MENU_CALLBACK,

    );

    $items['pspice-to-kicad/convert/approved'] = array(
        'title' => 'Convert Files',
        'description' => 'Convert Files',
        'page callback' => 'pspice_to_kicad_convert_approved',
        'access arguments' => array("convert pspice_to_kicad"),
        'type' => MENU_CALLBACK,

    );

    $items['pspice-to-kicad/convert/upload'] = array(
        'title' => 'Upload Corrected Zip',
        'description' => 'Convert Files',
        'page callback' => 'pspice_to_kicad_convert_upload',
        'access arguments' => array("convert pspice_to_kicad"),
        'type' => MENU_CALLBACK,

    );

    /* ADMIN SETTINGS */
    $items['admin/settings/pspice-to-kicad'] = array(
        'title' => 'Pspice File Settings',
        'description' => 'Pspice File Settings',
        'page callback' => 'drupal_get_form',
        'page arguments' => array(
            'pspicefile_settings_form',
        ),
        'access arguments' => array(
            'administer events',
        ),
        'type' => MENU_NORMAL_ITEM,
        'file' => 'settings.inc',
    );

    return $items;
}

function pspice_to_kicad_permission()
{
    return array(
        "access pspice_to_kicad" => array(
            "title" => t("Access pspice_to_kicad"),
            "description" => t("Allows users to view converted."),
        ),
        "manage pspice_to_kicad" => array(
            "title" => t("Upload pspice_to_kicad Files"),
            "description" => t("Allows users to upload files for pspice to kicad convertor."),
        ),
        "convert pspice_to_kicad" => array(
            "title" => t("Files to be converted"),
            "description" => t("Allows admin to see files to be convert from pspice to kicad."),
        ),
        "delete pspice_to_kicad file" => array(
            "title" => t("Files to be deleted"),
            "description" => t("Allows admin to delete files from pspice to kicad."),
        ),

    );
}

function pspice_to_kicad_check_valid_filename($file_name)
{
    if (preg_match("/\\s/", $file_name)) {
        return false;
    } else
    if (substr_count($file_name, ".") > 1) {
        return false;
    } else {
        return true;
    }

}

function pspice_to_kicad_directroy_path()
{
    return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'pspice_to_kicad_uploads';
}
function pspice_to_kicad_user_upload_path()
{
    return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'pspice_to_kicad_uploads/pspice_to_kicad_user_uploads/';
}
function pspice_to_kicad_convert_path()
{
    return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'pspice_to_kicad_uploads/pspice_to_kicad_converts/';
}

function get_directory($uid, $fid)
{
    $upload_root_path = pspice_to_kicad_directroy_path();
    $dir1 = $upload_root_path . '/' . $uid;
    if (!is_dir($dir1)) {
        mkdir($dir1);
    }
    $dir2 = $dir1 . '/' . $fid;
    if (!is_dir($dir2)) {
        mkdir($dir2);
    }
    $dir3 = $dir2 . '/' . 'pspice_to_kicad_user_uploads';
    if (!is_dir($dir3)) {
        mkdir($dir3);
    }
    $dir4 = $dir2 . '/' . 'pspice_to_kicad_converts';
    if (!is_dir($dir4)) {
        mkdir($dir4);
    }
    return true;
}
/* $flag= 1,3 is upload, $flag=2,4 is for convert */
function get_directory_path($uid, $fid, $flag)
{
    $upload_root_path = pspice_to_kicad_directroy_path();
    if ($flag == 1) {
        $dir_upload = $upload_root_path . '/' . $uid . '/' . $fid . '/' . 'pspice_to_kicad_user_uploads';
        if (is_dir($dir_upload)) {
            return $dir_upload;
        }
    } elseif ($flag == 2) {
        $dir_conv = $upload_root_path . '/' . $uid . '/' . $fid . '/' . 'pspice_to_kicad_converts';
        if (is_dir($dir_conv)) {
            return $dir_conv;
        }
    } elseif ($flag == 3) {
        $dir_conv = $upload_root_path . '/' . $uid . '/' . $fid . '/' . 'pspice_to_kicad_user_uploads';
        if (is_dir($dir_conv)) {
            return $uid . '/' . $fid . '/' . 'pspice_to_kicad_user_uploads';
        }
    } elseif ($flag == 4) {
        $dir_conv = $upload_root_path . '/' . $uid . '/' . $fid . '/' . 'pspice_to_kicad_converts';
        if (is_dir($dir_conv)) {
            return $uid . '/' . $fid . '/' . 'pspice_to_kicad_converts';
        }
    } else {
        drupal_set_message('Directory not available. Contact site administrator ', 'error');
        return flase;
    }
}

function pspice_to_kicad_add_form_display()
{
    $page_content = "";
    $pspice_to_kicad_add_form = drupal_get_form("pspice_to_kicad_add_form");
    $page_content = drupal_render($pspice_to_kicad_add_form);
    return $page_content;
}

function pspice_to_kicad_add_form($form, &$form_state)
{

    $form = array();

    $form["codefilename"] = array(
        '#title' => t('Pspice File'),
        '#type' => 'file',
        '#weight' => '1',
        '#description' => t('<label Style="color:red">Note: Give relevant name to file before uploading. For example: RC_CIRCUIT.sch<br> (Only file with extension .sch or.SCH can be uploaded)</label>'),

    );

    $form["description"] = array(
        "#type" => "textarea",
        "#required" => true,
        '#weight' => '2',
        "#title" => "Description",
        '#description' => t('<label Style="color:red">Note: Brief Description about file usage and other important details.(Minimum 50 Character) </label>'),
    );
    $form['pdffilename'] = array(
        '#title' => t('PDF File'),
        '#type' => 'file',
        '#weight' => '3',
        '#description' => t('<label Style="color:red">Note: Please upload any other supplementary document like experiment details/ lab manual/ analysis parameter details of the schematic here (Not mandatory)<br>Only PDF file can be uploaded</label>'),
    );

    $form['termsandcondition'] = array(
        '#type' => 'checkbox',
        '#title' => t('Terms and Conditions'),
        '#weight' => '4',
        "#required" => true,
    );

    $form['termsandcondition_text'] = array(
        '#type' => 'markup',
        '#weight' => '5',
        '#markup' => t('
	<ul><li>I confirm that the PSpice schematic file uploaded is created by me. </li>
	<li>I agree to temporarily transfer the ownership of this file to FOSSEE for the conversion purpose.</li>
	<li>I agree to FOSSEE project releasing the converted files as open source under the <a href="https://creativecommons.org/">Creative Commons (CC)</a> license and agree to the same.</li></ul>
	 Note: All uploaded PSpice files will be deleted from our database after converting them to KiCad files.<br><br>
	'),
    );

    $form["submit"] = array(
        "#type" => "submit",
        '#weight' => '6',
        "#value" => "Submit",
    );
    return $form;
}

function pspice_to_kicad_add_form_validate($form, &$form_state)
{

    if (isset($_FILES['files'])) {

        /* check if atleast one source or result file is uploaded */
        if (!($_FILES['files']['name']['codefilename'])) {
            form_set_error('codefilename', t('Please upload Pspice file.'));
        }

        foreach ($_FILES['files']['name'] as $file_form_name => $file_name) {

            if ($file_name) {
                /* checking file type */

                if (strstr($file_form_name, 'code')) {
                    $file_type = 'P';
                } else if (strstr($file_form_name, 'pdf')) {
                    $file_type = 'D';
                } else {
                    $file_type = 'U';
                }

                $allowed_extensions_str = '';
                switch ($file_type) {
                    case 'P':
                        $allowed_extensions_str = variable_get('pspice_files_extensions', '');
                        break;
                    case 'D':
                        $allowed_extensions_str = variable_get('pdfpspicefile_files_extensions', '');
                        break;

                }
                $allowed_extensions = explode(',', $allowed_extensions_str);
                $allowed_ext = explode('.', strtolower($_FILES['files']['name'][$file_form_name]));
                $temp_extension = end($allowed_ext);

                if (!in_array($temp_extension, $allowed_extensions)) {
                    form_set_error($file_form_name, t('Only file with ' . $allowed_extensions_str . ' extensions can be uploaded.'));
                }

                if ($_FILES['files']['size'][$file_form_name] <= 0) {
                    form_set_error($file_form_name, t('File size cannot be zero.'));
                }

                /* check if valid file name */
                if (!pspice_to_kicad_check_valid_filename($_FILES['files']['name'][$file_form_name])) {
                    form_set_error($file_form_name, t('Invalid file name specified. No Space are allowed in
    a filename.'));
                }

            }
        }

    }

}

function pspice_to_kicad_add_form_submit($form, &$form_state)
{

    global $user;
    if (!$user->uid) {
        drupal_set_message('It is mandatory to login on this website to upload files for converting', 'error');
        return;
    }

    $v = $form_state["values"];
    $filesupload = 0;
    $i = 0;
    $uploaddataresult = 0;
    $upload_root_path = pspice_to_kicad_directroy_path();
    $uploaddataquery = "
    INSERT INTO custom_kicad_convertor
    (uid,caption,description,upload_filename,upload_filepath,upload_filemime,upload_filesize,upload_date,converted_filename,
    converted_filepath,converted_filemime,converted_filesize,converted_date,converted_flag,download_counter)
    VALUES
    (:uid,:caption,:description,:upload_filename,:upload_filepath,:upload_filemime,:upload_filesize,:upload_date,:converted_filename,
    :converted_filepath,:converted_filemime,:converted_filesize,:converted_date,:converted_flag,:download_counter)
    ";
    $uploaddataargs = array(
        ":uid" => $user->uid,
        ":caption" => "None",
        ":description" => trim($v["description"]),
        ":upload_filename" => "None",
        ":upload_filepath" => "None",
        ":upload_filemime" => "None",
        ":upload_filesize" => 0,
        ":upload_date" => date("Y-m-d H:i:s"),
        ":converted_filename" => "None",
        ":converted_filepath" => "None",
        ":converted_filemime" => "None",
        ":converted_filesize" => 0,
        ":converted_date" => date("Y-m-d H:i:s"),
        ":converted_flag" => 0,
        ":download_counter" => 0,

    );

    /* storing the row id in $result */
    $uploaddataresult = db_query($uploaddataquery, $uploaddataargs, array(
        'return' => Database::RETURN_INSERT_ID,
    ));
    get_directory($user->uid, $uploaddataresult);
    $new_dest_path = get_directory_path($user->uid, $uploaddataresult, 3);
    $get_absolute_path = get_directory_path($user->uid, $uploaddataresult, 1);
    //var_dump($new_dest_path);die;
    foreach ($_FILES['files']['name'] as $file_form_name => $file_name) {

        if (strlen(trim($v["description"])) >= 49 && strlen(trim($v["description"])) <= 200) {

            $temp = explode(".", $file_name);
            $newuploadfilename = $file_name;

            /*for uploading*/
            if ($newuploadfilename) {

                if ($file_form_name != "pdffilename") {
                    if (file_exists($get_absolute_path . '/' . $newuploadfilename)) {
                        drupal_set_message(t("Error uploading file. File !filename already exists. Please give different relevant name", array(
                            '!filename' => $newuploadfilename,
                        )), 'error');
                        return;
                    }
                } else {

                    $newuploadfilename = str_replace(' ', '_', trim($newuploadfilename . "@" . date("Y-m-d H:i:s")));

                }

                /* uploading file */

                if (move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $get_absolute_path . '/' . $newuploadfilename)) {

                    if ($file_form_name != "pdffilename") {
                        $updatequery = db_update('custom_kicad_convertor');
                        $updatequery->fields(array(
                            "uid" => $user->uid,
                            "caption" => "None",
                            "description" => trim($v["description"]),
                            "upload_filename" => $newuploadfilename,
                            "upload_filepath" => $new_dest_path . '/' . $newuploadfilename,
                            "upload_filemime" => file_get_mimetype($newuploadfilename),
                            "upload_filesize" => $_FILES['files']['size'][$file_form_name],
                            "upload_date" => date("Y-m-d H:i:s"),
                            "converted_filename" => "None",
                            "converted_filepath" => "None",
                            "converted_filemime" => "None",
                            "converted_filesize" => 0,
                            "converted_date" => date("Y-m-d H:i:s"),
                            "converted_flag" => 0,
                            "download_counter" => 0,
                        ));
                        $updatequery->condition('id', $uploaddataresult);
                        $updatequery->execute();

                    } else {

                        $updatequery = db_update('custom_kicad_convertor');
                        $updatequery->fields(array(
                            'description_pdf_path' => $new_dest_path . '/' . $newuploadfilename,
                        ));
                        $updatequery->condition('id', $uploaddataresult);
                        $updateresult = $updatequery->execute();

                    }

                    if ($file_form_name != "pdffilename") {
                        if ($uploaddataresult != 0) {
                            $filesupload++;

                            /* sending mail */

                            $user_data = user_load($user->uid);
                            $to = $user_data->mail;
                            $from = variable_get('kicad_from_email', '');
                            $bcc = variable_get('kicad_emails', '');
                            $cc = variable_get('kicad_cc_emails', '');
                            $subject = "[esim.in][PSpice to KiCad Converter] Successful upload of PSpice schematic";

                            $email_body = "

Dear " . $user_data->name . ",

You have uploaded the following PSpice schematic:
File : " . $newuploadfilename . "

We shall review it and convert the schematic into KiCad format. You will be notified once the file is converted.

Best Wishes,<br>
" . variable_get('site_name', '') . " Team,<br>
FOSSEE, IIT Bombay";

                            send_mail(variable_get('kicad_from_email', ''), $to, $subject, $email_body, $from, $bcc, $cc);

                        }

                    }

                } else {
                    drupal_set_message('Error uploading file : ' . $new_dest_path . '/' . $newuploadfilename, 'error');
                }

            }

        } else {

            form_set_error('description', t('Minimum 50 character and Maximum 200 character for description'));
            return;
        }

    }

    if ($filesupload != 0) {
        drupal_set_message('File uploaded successfully. Please check your register email for more details.', 'status');
    }

}

function pspice_to_kicad_remain_list()
{

    $convertor_CSS = "
.convert_button {
display: block;
width: 80px;
height: 25px;
background:#156aa3;
padding: 2px;
text-align: center;
border-radius: 5px;
color: white;

}
";
    drupal_add_css($convertor_CSS, 'inline', 'header');

    $caption = "<h4>List of files to be converted: <br><br><h4>";
    $output = "";
    $query = "";
    $count_query = "";
    $rows = array();

    $header = array(
        array('data' => 'Sr No.'),
        array('data' => 'Uploaded Date'),
        array('data' => 'File'),
        array('data' => ''),
        array('data' => ''),
        array('data' => ''),
        array('data' => ''),
    );

    $query = db_select('custom_kicad_convertor', 'ckc');
    $query->fields('ckc', array('id', 'uid', 'upload_date', 'upload_filename', 'upload_filepath'));
    $query->condition('ckc.converted_flag', 2, '<>');
    $result = $query->orderBy('id', 'DESC')->execute();
    $number_of_rows = $result->rowCount();
    $i = 1;
    while ($row = $result->fetchObject()) {
        $filearray = explode('.', $row->upload_filename);
        $filenamewothoutext = $filearray[0];
        $filename = $filenamewothoutext;

        $item = array($i, date('d-m-Y', strtotime($row->upload_date)), "<a href='descriptioninfo/{$row->id}' class='autodialog' data-dialog-width='700' title='Click to view file details'>" . $filename . "</a>",

            l(t('Convert'), '/pspice-to-kicad/convert/file/' . $row->id, array('attributes' => array('class' => array('convert_button'), 'title' => 'Click to convert file'))),
            l(t('Delete'), '/pspice-to-kicad/delete/file/' . $row->id, array('attributes' => array('class' => array('convert_button'), 'title' => 'Click to delete file'))),
            l(t('Upload'), '/pspice-to-kicad/convert/upload/' . $row->id, array('attributes' => array('class' => array('convert_button'), 'title' => 'Click to upload corrected file'))),
            l(t('Publish'), '/pspice-to-kicad/convert/approved/' . $row->id, array('attributes' => array('class' => array('convert_button'), 'title' => 'Click to publish file'))),

        );
        array_push($rows, $item);
        $i++;
    }

    if ($number_of_rows == 0) {
        $output .= '<div style="color:red;text-align:center;">No files for convert</div>';
    } else {

        $output = theme('table', array(
            'header' => $header,
            'rows' => $rows,
        ));
    }

    return $output;
}

function pspice_to_kicad_view()
{

    $caption = "<h4>List of Converted files: <br><br><h4>";
    $output = "";
    $query = "";
    $count_query = "";
    $rows = array();

    $header = array(
        
        array('data' => 'Uploaded by'),
        array('data' => 'Download'),
        array('data' => ''),
        array('data' => 'Date'),

    );

    $query = db_select('custom_kicad_convertor', 'ckc');
    $query->fields('ckc', array('id', 'uid', 'caption', 'description', 'converted_filename'
        , 'converted_filepath', 'converted_date', 'download_counter'));
    $query->condition('ckc.converted_flag', 2);
    $query->orderBy('converted_date', 'DESC');
    $result = $query->execute();
    $number_of_rows = $result->rowCount();

    while ($row = $result->fetchObject()) {

        $query = db_select('users');
        $query->fields('users');
        $query->condition('uid', $row->uid);
        $user = $query->execute();
        $user_data = $user->fetchObject();

        $item = array( $user_data->name,
            l($row->converted_filename, '/pspice-to-kicad/download/file/' . $row->id, array('attributes' => array('title' => 'Click to download converted file'))),
            "<a href='description/{$row->id}' class='autodialog' data-dialog-width='700' title='Click to view more detail about file'>Detail</a>",
            date('d-m-Y', strtotime($row->converted_date)),
        );
        array_push($rows, $item);
    }

    if ($number_of_rows == 0) {
        $output .= '<div style="color:red;text-align:center;">No files available yet for download</div>';
    } else {

        $build['pager_table'] = array(
            '#theme' => 'table',
            '#header' => $header,
            '#rows' => $rows,
            '#caption' => $caption,
            '#attributes' => array(
                'class' => array('table table-bordered table-hover'),
            ),
        );

        // Attach the pager theme.
        $build['pager_pager'] = array('#theme' => 'pager');
        $output = $build;
    }

    return $output;

}

function pspice_to_kicad_download_file()
{
    $id = arg(3);
    $root_path = pspice_to_kicad_directroy_path();

    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $id);
    $query->range(0, 1);
    $files_q = $query->execute();
    $file_data = $files_q->fetchObject();

    $earlier_count = $file_data->download_counter;
    $download_counter = 1;

    $updatequery = db_update('custom_kicad_convertor');
    $updatequery->fields(array(
        'download_counter' => $earlier_count + $download_counter,
    ));
    $updatequery->condition('id', $id);
    $updateresult = $updatequery->execute();

    header('Content-Type: ' . $file_data->converted_filemime);
    header('Content-disposition: attachment; filename="' . $file_data->converted_filename . '"');
    header('Content-Length: ' . filesize($root_path . "/" . $file_data->converted_filepath));
    ob_clean();
    flush();
    readfile($root_path . "/" . $file_data->converted_filepath);

}

function send_mail($from, $to, $subject, $message, $from1, $bcc, $cc)
{
    $my_module = 'pspice_to_kicad';
    $my_mail_token = microtime();
    $message = array(
        'id' => $my_module . '_' . $my_mail_token,
        'to' => $to,
        'subject' => $subject,
        'body' => array($message),
        'headers' => array(
            'From' => $from1,
            'Return-Path' => $from1,
            'Bcc' => $bcc,
            'Cc' => $cc,
        ),
    );
    $system = drupal_mail_system($my_module, $my_mail_token);
    $message = $system->format($message);
    if ($system->mail($message)) {
        return true;
    } else {
        return false;
    }
}

function pspice_to_kicad_convert_file()
{

    try {
        $upload_root_path = pspice_to_kicad_directroy_path();

        $fileid = arg(3);

        $query = db_select('custom_kicad_convertor', 'ckc');
        $query->fields('ckc', array('id', 'uid', 'caption', 'upload_date', 'upload_filename', 'upload_filepath'));
        $query->condition('id', $fileid);
        $result = $query->execute();
        $row = $result->fetchObject();

        $file = $row->upload_filename;
        $filearray = explode('.', $file);
        $filenamewothoutext = $filearray[0];

        $filenamearray = explode('.', $row->upload_filepath);
        $filename = $filenamearray[0];
        $filePath = $upload_root_path . "/" . $row->upload_filepath;
        $uploadfolder = $row->uid;

        $convert_root_path = get_directory_path($row->uid, $fileid, 2);
        $sh_script_file = "/var/www/html/drupal/drupal_7.x/r_fossee_in/sites/all/modules/custom/pspice_to_kicad/convert.sh";
        shell_exec($sh_script_file . " " . $convert_root_path . " " . $filePath . " " . $uploadfolder);

        $file = $row->upload_filename;
        $filearray = explode('.', $file);
        $converted_file = $convert_root_path . "/" . $filenamewothoutext . ".zip";
        $conv_path = get_directory_path($row->uid, $fileid, 4);
        $query = db_update('custom_kicad_convertor');
        $query->fields(array(
            'converted_filename' => $filenamewothoutext . ".zip",
            'converted_filepath' => $conv_path . "/" . $filenamewothoutext . ".zip",
            'converted_filemime' => file_get_mimetype($converted_file),
            'converted_filesize' => filesize($converted_file),
            'converted_date' => date("Y-m-d H:i:s"),
            'converted_flag' => "1",
        ));
        $query->condition('id', $row->id);
        $result = $query->execute();

        header('Content-Type: ' . file_get_mimetype($converted_file));
        header('Content-disposition: attachment; filename="' . $filenamewothoutext . ".zip" . '"');
        header('Content-Length: ' . filesize($converted_file));
        ob_clean();
        flush();
        readfile($converted_file);
    } catch (Exception $e) {
        var_dump($e);die;
        drupal_set_message('Error while converting file, Please download specific file by clicking on file and Check it manually', 'error');
        drupal_goto("pspice-to-kicad/convert");
        return;

    }
}

function pspice_to_kicad_convert_approved()
{

    $fileid = arg(3);
    $number_of_rows = 0;
    $querycheck = db_select('custom_kicad_convertor');
    $querycheck->fields('custom_kicad_convertor');
    $querycheck->condition('id', $fileid);
    $querycheck->condition('converted_flag', "1");
    $resultcheck = $querycheck->execute();
    $number_of_rows = $resultcheck->rowCount();

    if ($number_of_rows != 0) {
        $query = db_update('custom_kicad_convertor');
        $query->fields(array(
            'converted_flag' => "2",
        ));
        $query->condition('id', $fileid);
        $result = $query->execute();
        if ($result) {

            $query = db_select('custom_kicad_convertor');
            $query->fields('custom_kicad_convertor');
            $query->condition('id', $fileid);
            $result = $query->execute();
            $row = $result->fetchObject();

            $upload_root_path = pspice_to_kicad_user_upload_path();
            $eventfolder = $row->uid;
            $dest_path = $eventfolder . '/';
            $newuploadfilename = $row->upload_filename;

            if (file_exists($upload_root_path . $dest_path . $newuploadfilename)) {
                unlink($upload_root_path . $dest_path . $newuploadfilename);
            }
            $user_data = user_load($row->uid);
            $to = $user_data->mail;
            $from = variable_get('kicad_from_email', '');
            $bcc = variable_get('kicad_emails', '');
            $cc = variable_get('kicad_cc_emails', '');
            $subject = "[esim.in][PSpice to KiCad Converter] PSpice file converted successfully";

            $email_body = "

Dear " . $user_data->name . ",

The uploaded PSpice file " . $row->upload_filename . " is successfully converted to Kicad format. This can be used in https://esim.fossee.in . You can download the converted file from https://esim.fossee.in/pspice-to-kicad/download/file/" . $fileid . "

Best Wishes,<br>
" . variable_get('site_name', '') . " Team,<br>
FOSSEE, IIT Bombay";

            send_mail(variable_get('kicad_from_email', ''), $to, $subject, $email_body, $from, $bcc, $cc);
        }

    } else {

        drupal_set_message('File should be converted before Publishing', 'error');

    }
    drupal_goto("pspice-to-kicad/convert");
    return;
}

function pspice_to_kicad_convert_upload()
{
    $fileid = arg(3);

    $number_of_rows = 0;
    $querycheck = db_select('custom_kicad_convertor');
    $querycheck->fields('custom_kicad_convertor');
    $querycheck->condition('id', $fileid);
    $resultcheck = $querycheck->execute();
    $number_of_rows = $resultcheck->rowCount();
    $page_content = "";
    if ($number_of_rows != 0) {

        $pspice_to_kicad_upload_form = drupal_get_form("pspice_to_kicad_upload_form", $fileid);
        $page_content = drupal_render($pspice_to_kicad_upload_form);
        return $page_content;

    } else {

        drupal_set_message('File should be converted first <br> If automated converted file has error, you can upload corrected zip file 		using this feature.', 'error');
        drupal_goto("pspice-to-kicad/convert");
        return;
    }

}

function pspice_to_kicad_upload_form($form, &$form_state, $fileid)
{

    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $fileid);
    $result = $query->execute();
    $row = $result->fetchObject();

    $form = array();
    $form['pspice_uploadfiles_fieldset'] = array(
        '#type' => 'fieldset',
        '#tree' => true,
        '#prefix' => '<div id="pspice-files-fieldset-wrapper">',
        '#suffix' => '</div>',
    );

    $form['pspice_uploadfiles_fieldset']["file_description"] = array(
        "#type" => "textarea",
        "#default_value" => $row->description,
        "#title" => "Description",
        "#required" => true,
        '#description' => t('<label>Note: Brief Description about file usage and other important details.(Minimum 50 Character) </label>'),
    );

    $form['pspice_uploadfiles_fieldset']['name'] = array(
        '#title' => t('Upload File'),
        '#type' => 'file',
        '#weight' => '5',
        '#description' => t('<label Style="color:red">Note: Give appropriate name to file which you will be uploading.</label>'),
    );
    $form["pspice_files_id"] = array(
        "#type" => "hidden",
        "#value" => $fileid,
    );
    $form["submit"] = array(
        "#type" => "submit",
        "#value" => "Submit",
    );
    return $form;
}

function pspice_to_kicad_upload_form_validate()
{
    if (isset($_FILES['files'])) {

        /* check for valid filename extensions */
        foreach ($_FILES['files']['name'] as $file_form_name => $file_name) {
            if ($file_name) {
                if (strstr($file_form_name, 'pspice_uploadfiles_fieldset')) {
                    $file_type = 'P';
                }

                switch ($file_type) {
                    case 'P':
                        $allowed_extensions_str = variable_get('kicad_corrected_files_extensions', '');
                        break;
                }
                $allowed_extensions = explode(',', $allowed_extensions_str);
                $allowed_ext = explode('.', strtolower($_FILES['files']['name'][$file_form_name]));
                $temp_extension = end($allowed_ext);

                if (!in_array($temp_extension, $allowed_extensions)) {
                    form_set_error($file_form_name, t('Only file with ' . $allowed_extensions_str . ' extensions can be uploaded.'));
                }

                if (($_FILES['files']['size'][$file_form_name] == 0)) {
                    form_set_error($file_form_name, t('File with 0 byte size cannot be uploaded.'));
                }

                if (!pspice_to_kicad_check_valid_filename($_FILES['files']['name'][$file_form_name])) {
                    form_set_error($file_form_name, t('Invalid file name specified. No Space are allowed in a filename.'));
                }

            }

        }

    }

}

function pspice_to_kicad_upload_form_submit($form, &$form_state)
{

    global $user;
    $v = $form_state["values"];
    $filesupload = 0;
    $i = 0;
    $id = $v["pspice_files_id"];
    $arr = array_values($_FILES['files']['name']);
    if (strlen(trim($arr[0])) <= 0) {
        drupal_set_message('Please corrected zip file', 'error');
        return;
    }

    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $id);
    $result = $query->execute();
    $row = $result->fetchObject();

    /*Creating folder for saving uploaded files */
    get_directory($user->uid, $id);
    $new_dest_path = get_directory_path($user->uid, $id, 4);
    $get_absolute_path = get_directory_path($user->uid, $id, 2);

    // $convert_root_path = pspice_to_kicad_convert_path() . "/";
    // $eventfolder = $row->uid;
    //$dest_path = $eventfolder . '/';
    // if (!is_dir($convert_root_path . $dest_path)) {
    //     mkdir($convert_root_path . $dest_path);
    // }
    foreach ($_FILES['files']['name'] as $file_form_name => $file_name) {

        $temp = explode(".", $file_name);
        $newuploadfilename = $file_name;

        /*for uploading*/
        if ($newuploadfilename) {
            if (file_exists($get_absolute_path . '/' . $newuploadfilename)) {
                unlink($get_absolute_path . '/' . $newuploadfilename);
            }

            /* uploading file */

            if (move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $get_absolute_path . '/' . $newuploadfilename)) {

                $updatequery = db_update('custom_kicad_convertor');
                $updatequery->fields(array(
                    "description" => trim($v['pspice_uploadfiles_fieldset']["file_description"]),
                    "converted_filename" => $newuploadfilename,
                    "converted_filepath" => $new_dest_path . '/' . $newuploadfilename,
                    "converted_filemime" => file_get_mimetype($newuploadfilename),
                    "converted_filesize" => $_FILES['files']['size'][$file_form_name],
                    "converted_date" => date("Y-m-d H:i:s"),
                    "converted_flag" => 1,

                ));
                $updatequery->condition('id', $id);
                $updateresult = $updatequery->execute();

                drupal_set_message($newuploadfilename . ' uploaded successfully.', 'status');
            } else {
                drupal_set_message('Error uploading file : ' . $new_dest_path . '/' . $newuploadfilename, 'error');
            }
        }

    }
    drupal_goto("pspice-to-kicad/convert");
    return;
}

function pspice_to_kicad_get_description($file_id = 0)
{
    $pagecontent = "";
    $fileid = arg(2);
    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $fileid);
    $result = $query->execute();
    $row = $result->fetchObject();

    $pdffilearray = explode('@', $row->description_pdf_path);
    $pdffilenamepath = $pdffilearray[0];
    $pdffilearray2 = explode('/', $pdffilenamepath);
    $pdffilename = $pdffilearray2[3];

    $pagecontent .= "<p> <span style='font-weight:bold'>Brief Description of file :</span> " . $row->description . "</p>";
    if ($row->description_pdf_path != "" || $row->description_pdf_path != null) {
        $pagecontent .= "<span style='font-weight:bold'> PDF File with description :</span>  <a  title='Click to download pdf' style='color:#156AA3;text-decoration: underline' href='" . $GLOBALS['base_url'] . "/pspice-to-kicad/download/pdf/" . $row->id . "'>" . $pdffilename . "</a>";
    }
    return $pagecontent;
}

function pspice_to_kicad_get_descriptioninfo($file_id = 0)
{
    $pagecontent = "";
    $fileid = arg(2);
    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $fileid);
    $result = $query->execute();
    $row = $result->fetchObject();

    $queryuser = db_select('users');
    $queryuser->fields('users');
    $queryuser->condition('uid', $row->uid);
    $user = $queryuser->execute();
    $user_data = $user->fetchObject();

    $filearray = explode('.', $row->upload_filename);
    $filenamewothoutext = $filearray[0];
    $filename = $filenamewothoutext;

    $pdffilearray = explode('@', $row->description_pdf_path);
    $pdffilenamepath = $pdffilearray[0];
    $pdffilearray2 = explode('/', $pdffilenamepath);
    $pdffilename = $pdffilearray2[3];

    $pagecontent .= "<br><p><span style='font-weight:bold'>File name :</span> </b> " . $filename . "</p>";
    $pagecontent .= "<p><span style='font-weight:bold'> Author :</span> " . $user_data->name . "</p>";
    $pagecontent .= "<p><span style='font-weight:bold'> Upload Date :</span> " . date('d-m-Y', strtotime($row->upload_date)) . "</p>";
    $pagecontent .= "<p> <span style='font-weight:bold'>Description :</span> " . $row->description . "</p>";
    $pagecontent .= "<span style='font-weight:bold'>Pspice File :</span>  <a  title='Click to download pspice file' style='color:#156AA3;text-decoration: underline' href='" . $GLOBALS['base_url'] . "/pspice-to-kicad/download/pspicefile/" . $row->id . "'>" . $row->upload_filename . "</a><br><br>";
    if ($row->description_pdf_path != "" || $row->description_pdf_path != null) {
        $pagecontent .= "<span style='font-weight:bold'>Description PDF File :</span>  <a  title='Click to download pdf' style='color:#156AA3;text-decoration: underline' href='" . $GLOBALS['base_url'] . "/pspice-to-kicad/download/pdf/" . $row->id . "'>" . $pdffilename . "</a>";
    }
    return $pagecontent;
}

function pspice_to_kicad_your_uploaded_file()
{

    global $user;

    $output = "";
    $query = "";
    $count_query = "";
    $rows = array();

    $header = array(
        array('data' => 'Date', 'field' => 'ckc.upload_date', 'sort' => 'desc'),
        array('data' => 'File name'),
        array('data' => 'Conversion Status'),
        array('data' => ''),

    );

    $query = db_select('custom_kicad_convertor', 'ckc');
    $query->fields('ckc', array('id', 'uid', 'description', 'upload_filename', 'converted_flag'
        , 'upload_date'));
    $query->condition('ckc.uid', $user->uid);
    $result = $query->extend('PagerDefault')->limit(10)->extend('TableSort')->orderByHeader($header)->execute();
    $number_of_rows = $result->rowCount();

    while ($row = $result->fetchObject()) {

        $converted_flag = $row->converted_flag;
        $status = "";
        if ($converted_flag == 1 || $converted_flag == 0) {
            $status = "In Process";
        } else {
            $status = "Converted";
        }

        $item = array(date('d-m-Y', strtotime($row->upload_date)), $row->upload_filename, $status,
            "<a href='description/{$row->id}' class='autodialog' data-dialog-width='700' title='Click to view description of file'>Detail</a>",

        );
        array_push($rows, $item);
    }

    if ($number_of_rows == 0) {
        $output .= '<div style="color:red;text-align:center;">No files has been uploaded by you</div>';
    } else {

        $build['pager_table'] = array(
            '#theme' => 'table',
            '#header' => $header,
            '#rows' => $rows,
            '#attributes' => array(
                'class' => array('table table-bordered table-hover'),
            ),
        );

        // Attach the pager theme.
        $build['pager_pager'] = array('#theme' => 'pager');
        $output = $build;
    }

    return $output;

}

function pspice_to_kicad_download_pdf_file()
{
    $id = arg(3);
    $root_path = pspice_to_kicad_directroy_path();

    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $id);
    $query->range(0, 1);
    $files_q = $query->execute();
    $file_data = $files_q->fetchObject();

    $pdffilearray = explode('@', $file_data->description_pdf_path);
    $pdffilenamepath = $pdffilearray[0];
    $pdffilearray2 = explode('/', $pdffilenamepath);
    $pdffilename = $pdffilearray2[3];

    header('Content-Type: application/pdf');
    header('Content-disposition: attachment; filename="' . $pdffilename . '"');
    header('Content-Length: ' . filesize($root_path . "/" . $file_data->description_pdf_path));
    ob_clean();
    flush();
    readfile($root_path . "/" . $file_data->description_pdf_path);

}

function pspice_to_kicad_download_pspice_file()
{
    $id = arg(3);
    $root_path = pspice_to_kicad_directroy_path();

    $query = db_select('custom_kicad_convertor');
    $query->fields('custom_kicad_convertor');
    $query->condition('id', $id);
    $query->range(0, 1);
    $files_q = $query->execute();
    $file_data = $files_q->fetchObject();

    header('Content-Type:' . $file_data->upload_filemime);
    header('Content-disposition: attachment; filename="' . $file_data->upload_filename . '"');
    header('Content-Length: ' . filesize($root_path . '/' . $file_data->upload_filepath));
    ob_clean();
    flush();
    readfile($root_path . '/' . $file_data->upload_filepath);

}

function pspice_to_kicad_delete_file()
{
    $fileid = arg(3);

    $number_of_rows = 0;
    $querycheck = db_select('custom_kicad_convertor');
    $querycheck->fields('custom_kicad_convertor');
    $querycheck->condition('id', $fileid);
    $resultcheck = $querycheck->execute();
    $number_of_rows = $resultcheck->rowCount();

    $page_content = "";
    if ($number_of_rows != 0) {

        $pspice_to_kicad_delete_file_form = drupal_get_form("pspice_to_kicad_delete_file_form", $fileid);
        $page_content = drupal_render($pspice_to_kicad_delete_file_form);
        return $page_content;

    } else {

        drupal_set_message('File can not be deleted. Please contact to site administrator', 'error');
        drupal_goto("pspice-to-kicad/convert");
        return;
    }

}

function pspice_to_kicad_delete_file_form($form, &$form_state, $fileid)
{

    $querycheck = db_select('custom_kicad_convertor');
    $querycheck->fields('custom_kicad_convertor');
    $querycheck->condition('id', $fileid);
    $resultcheck = $querycheck->execute();
    $number_of_rows = $resultcheck->rowCount();

    $form = array();
    $form['pspice_deletefile_fieldset'] = array(
        '#type' => 'fieldset',
        '#tree' => true,
        '#prefix' => '<div id="pspice-delete-fieldset-wrapper">',
        '#suffix' => '</div>',
    );

    $form['pspice_deletefile_fieldset']["reason"] = array(
        "#type" => "textarea",
        "#default_value" => "",
        "#title" => "Reason for deletion of file: ",
        "#required" => true,
        '#description' => t('<label>Note: Brief reason for deleting file </label>'),
    );

    $form["pspice_files_id"] = array(
        "#type" => "hidden",
        "#value" => $fileid,
    );
    $form["submit"] = array(
        "#type" => "submit",
        "#value" => "Submit",
        "#attributes" => array('onclick' => 'if(!confirm("Do you really want to delete this file ?")){history.go(-1);return false;}'),

    );

    return $form;
}

function pspice_to_kicad_delete_file_form_validate()
{

}

function pspice_to_kicad_delete_file_form_submit($form, &$form_state)
{

    global $user;
    $v = $form_state["values"];
    $id = $v["pspice_files_id"];
    $fileid = $id;

    $querycheck = db_select('custom_kicad_convertor');
    $querycheck->fields('custom_kicad_convertor');
    $querycheck->condition('id', $fileid);
    $resultcheck = $querycheck->execute();
    $row = $resultcheck->fetchObject();

    $upload_root_path = pspice_to_kicad_directroy_path();
    $newuploadfilename = $row->upload_filename;
    $uploadfilepath = $row->upload_filepath;
    $uploadpdfpath = $row->description_pdf_path;
    $convertedfilepath = $row->converted_filepath;
    if (file_exists($upload_root_path . '/' . $uploadfilepath)) {
        unlink($upload_root_path . '/' . $uploadfilepath);
    }
    if (file_exists($upload_root_path . '/' . $uploadpdfpath)) {
        unlink($upload_root_path . '/' . $uploadpdfpath);
    }
    if (file_exists($upload_root_path . '/' . $convertedfilepath)) {
        unlink($upload_root_path . '/' . $convertedfilepath);
    }
    if (!rmdir(get_directory_path($row->uid, $id, 1))) {
        drupal_set_message('Could not delete the directory, contact site administrator', 'error');
    }
    if (!rmdir(get_directory_path($row->uid, $id, 2))) {
        drupal_set_message('Could not delete the directory, contact site administrator', 'error');
    }
    if (!rmdir($upload_root_path . '/' . $row->uid . '/' . $id)) {
        drupal_set_message('Could not delete the directory, contact site administrator', 'error');
    }
    //Deleting DB entry of that file.
    db_delete('custom_kicad_convertor')->condition('id', $row->id)->execute();

    $user_data = user_load($row->uid);
    $to = $user_data->mail;
    $from = variable_get('kicad_from_email', '');
    $bcc = variable_get('kicad_emails', '');
    $cc = variable_get('kicad_cc_emails', '');
    $subject = "[esim.in][PSpice to KiCad Converter] PSpice to KiCad converter: Uploaded schematic/converted file deleted";

    $email_body = "

Dear " . $user_data->name . ",

Thank you for using the PSpice to KiCad converter. We have deleted your uploaded schematic/converted file with the following details:

Schematic name :  " . $row->upload_filename . "

Description: " . $row->description . "

Reason of Deletion : " . trim($v['pspice_deletefile_fieldset']['reason']) . "

You are welcome to upload a new Pspice schematic file for conversion.

Best Wishes,<br>
" . variable_get('site_name', '') . " Team,<br>
FOSSEE, IIT Bombay";

    send_mail(variable_get('kicad_from_email', ''), $to, $subject, $email_body, $from, $bcc, $cc);

    drupal_set_message('File is deleted successfully and an email has send to file author.', 'status');
    drupal_goto("pspice-to-kicad/convert");
    return;

}