<?php
include("../../core/headers.php");
include_once("../../core/initialize.php");

require_once(CONT_PATH . DS . "project.php");

if ($_SERVER['REQUEST_METHOD'] === 'GET') {

    $pid = $_GET['id'];

    $status = $_GET['status'] ?? "";

    $cid = $_GET['cid'] ?? "";

    $database = new Database();

    $db = $database->connect();

    $project = new Project($db);

    $project->pid = $pid;

    $project->cid = $cid;

    $project->status = $status;

    $projectResult = $project->vendorDetails();

    $num = $projectResult->rowCount();

    if ($num > 0) {

        $result = $project->getSurveyRows();

        $list = array();

        $projectDetail = $projectResult->fetch(PDO::FETCH_ASSOC);

        while ($row = $result->fetch(PDO::FETCH_ASSOC)) {

            extract($row);

            $url = SURVEY_ENTRY . "?p=" . $pid . "&v=" . $cid . "&suid=" . $our_id;;

            if ($projectDetail["isopen"] == 1) {
                $url = !empty($param1) ? $param1 : "";
            } else if (!empty($projectDetail["attributes"]) && $param1) {
                $url = SURVEY_ENTRY . "?p=" . $pid . "&v=" . $cid . "&" . $param1;
            }

            $item = array(
                "liveUrl" => $survey_url,
                "url" => $url,
                "status" => $status,
                "tags" => $tags
            );

            array_push($list, $item);
        }

        $fp = fopen('php://output', 'w');

        header('Content-Type: text/csv');

        header('Content-Disposition: attachment; filename="' . $projectDetail["projectName"] . "-" . $projectDetail["vendorName"] . '.csv"');

        $header = ["Live URL", "Vendor Transaction", "Status", "Tags"];

        fputcsv($fp, $header);

        foreach ($list as $ferow) {
            fputcsv($fp, $ferow);
        }

        fclose($fp);
    }
}