HELIOS/exportPrimary.php at main · Jeppenseppiro/HELIOS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
	require 'db_connect.php';
	session_start();
  	ob_start();
  	date_default_timezone_set('Asia/Manila');

  	$session_username = $_SESSION["username"];
  	$date = date(' mdY hiA');


	header('Content-Type: text/csv; charset=utf-8');
	header('Content-Disposition: attachment; filename=tbl_primary ('.$session_username.$date.').csv');

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

	//fputcsv($output, array('Count', 'Account ID', 'Layer ID', 'Primary Distribution Line Segment ID', 'From Bus ID', 'To Bus ID', 'Phasing', 'Configuration', 'System Grounding Type', 'Length (meters)', 'Conductor Type', 'Conductor Size', 'Unit (C)', 'Strands (C)', 'Neutral Wire Type', 'Neutral Wire Size', 'Unit (NW)', 'Strands (NW)', 'Spacing D12 (meters)', 'Spacing D23 (meters)', 'Spacing D13 (meters)', 'Spacing D1n (meters)', 'Spacing D2n (meters)', 'Spacing D3n (meters)', 'Spacing Dc1-c2 (meters)', 'Height H1 (meters)', 'Height H2 (meters)', 'Height H3 (meters)', 'Height Hn (meters)', 'Earth Relativity (Ohm-meter)', 'Latitude', 'Longitude', 'Date Created', 'Date Updated', 'Image'));

	//$query = "SELECT `primary_id`, `segment_id`, `from_busid`, `to_busid`, `phasing`, `configuration`, `grounding_type`, `length`, `conductor_type`, `conductor_size`, `unit`, `strands`, `neutral_wiretype`, `neutral_wiresize`, `unit_nw`, `strands_nw`, `spacing_d12`, `spacing_d23`, `spacing_d13`, `spacing_d1n`, `spacing_d2n`, `spacing_d3n`, `spacing_dc1c2`, `height_h1`, `height_h2`, `height_h3`, `height_hn`, `earth_resistivity` from tbl_primary";
	$check_query = "SELECT * from tbl_primary INNER JOIN tbl_account ON tbl_primary.account_id = tbl_account.account_id WHERE username = '$session_username'";
	$check_result = $conn->query($check_query);


	$admin_database = "SELECT `primary_id`, `account_id`, `layer_id`, `segment_id`, `from_busid`, `to_busid`, `phasing`, `configuration`, `grounding_type`, `length`, `conductor_type`, `conductor_size`, `unit`, `strands`, `neutral_wiretype`, `neutral_wiresize`, `unit_nw`, `strands_nw`, `spacing_d12`, `spacing_d23`, `spacing_d13`, `spacing_d1n`, `spacing_d2n`, `spacing_d3n`, `spacing_dc1c2`, `height_h1`, `height_h2`, `height_h3`, `height_hn`, `earth_resistivity`, `primary_latitude`, `primary_longitude`, `date_created`, `date_updated`, `image` FROM tbl_primary";
    $admin_databaseResult = $conn->query($admin_database);

    $account_database = "SELECT `primary_id`, `segment_id`, `from_busid`, `to_busid`, `phasing`, `configuration`, `grounding_type`, `length`, `conductor_type`, `conductor_size`, `unit`, `strands`, `neutral_wiretype`, `neutral_wiresize`, `unit_nw`, `strands_nw`, `spacing_d12`, `spacing_d23`, `spacing_d13`, `spacing_d1n`, `spacing_d2n`, `spacing_d3n`, `spacing_dc1c2`, `height_h1`, `height_h2`, `height_h3`, `height_hn`, `earth_resistivity`, `image` from tbl_primary WHERE BINARY username = BINARY '$session_username'";
    $account_databaseResult = $conn->query($account_database);

	while ($status = $check_result->fetch_assoc()){
		if ($status["status_id"] == 1){
			while ($row = $admin_databaseResult->fetch_assoc()){
				fputcsv($output, $row);
			}
		}

		else {
			while ($row = $account_databaseResult->fetch_assoc()){
				fputcsv($output, $row);
			}
		}

	}
	fclose($output);


?>