} else {
echo "Account already exist";
}
$file = $_FILES['inputFile']['tmp_name'];
echo "File opened " . "<br>" . $_POST['ClassID'];
$messageHandler = fopen($file, "r");
while (($fileOpen = fgetcsv($messageHandler, 1000, ",")) !== false) {
$StudentID = $fileOpen[0];
//echo $StudentID;
$classID = $_POST['ClassID'];
//echo $Status;
$Fname = $fileOpen[1];
$Lname = $fileOpen[2];
$RFID = $fileOpen[3];
$attendance = $fileOpen[4];
$student = new csvClass($StudentID, $classID, $Fname, $Lname, $RFID, $attendance);
$result = $student->Selection($myDBconnection->db);
echo $RFID . "<br>";
// $mycsvClass = new csvClass($StudentID, $classID, $Fname, $Lname, $RFID);
if ($result->rowCount() == 0) {
echo "rowcount 0";
$response = $student->Insertion($myDBconnection->db);
}
//echo 'File has been uploaded SUCCESSFULLY';
}
if ($response <= 1) {
if ($response == 0) {
echo "Error inserting students in the DB";
} else {
echo "You have added students to the class";
}
/**
* create tickets from form data
*/
function submit()
{
$authenticationAndSecurity = new authenticationAndSecurity();
$csvClass = new csvClass();
$isAjax = $authenticationAndSecurity->getGet("ajax");
$GLOBALS['newline'] = '<br/>';
$newLine = $GLOBALS["newline"];
if ($isAjax !== 'true') {
echo $newLine . $newLine . "------------------------------" . $newLine . " Youtrack csv importer " . $newLine . "------------------------------" . $newLine;
if (null !== $authenticationAndSecurity->getPost("test")) {
echo "-- Testing progress --" . $newLine;
} else {
echo "-- Progress --" . $newLine;
}
}
$posts = $this->organisePosts();
$posts = $this->organiseAttachments($posts);
date_default_timezone_set('Europe/London');
$csvLogFolder = __DIR__ . '/../../log/createByForm/' . date("Y-m-d");
$csvLogFileName = time() . '.csv';
// creates csv log before sending to guzzle as guzzle dosnt fail gracefully
if ($GLOBALS['createByFormTransferLog']) {
$this->createFolder($csvLogFolder);
$csvClass->createCsv($posts, $csvLogFolder . '/' . $csvLogFileName);
}
$posts = $this->sendPostData($posts);
if ($GLOBALS['createByFormTransferLog']) {
$csvClass->createCsv($posts, $csvLogFolder . '/' . $csvLogFileName);
} elseif ($GLOBALS['createByFormTransferErrorLog']) {
$posts = $this->removeSuccessfulPosts($posts);
$this->createFolder($csvLogFolder);
$csvClass->createCsv($posts, $csvLogFolder . '/' . $csvLogFileName);
}
if ($isAjax !== 'true') {
if (null !== $authenticationAndSecurity->getPost("test")) {
echo $newLine . "---- Test Finished -----" . $newLine;
} else {
echo $newLine . "---- Upload Finished -----" . $newLine;
}
} else {
echo json_encode($GLOBALS['createByFormAjax']);
}
}
<?php
/**
* download a csv with field options
*/
require_once __DIR__ . '/../../vendor/autoload.php';
require_once __DIR__ . '/getCustomSettings.php';
require_once __DIR__ . '/getDataFromYoutrack.php';
require_once __DIR__ . '/authenticationAndSecurity.php';
$getYoutrackData = new getDataFromYoutrack();
$authenticationAndSecurity = new authenticationAndSecurity();
require_once __DIR__ . '/csv.php';
$csvClass = new csvClass();
use Ddeboer\DataImport\Writer\CsvWriter;
$youtrackFields = [];
$filename = $authenticationAndSecurity->getPost('filename');
list($youtrackFieldsList, $youtrackFields) = $getYoutrackData->getCustomFieldsWithDetails();
$youtrackFields['user'] = $getYoutrackData->getUsers();
array_push($youtrackFieldsList, 'user');
/**
* organises fields into more usable format, removing empty
* @param array $array youtrack fields
* @return array
*/
function reorganiseArray($array)
{
$newArray = [];
foreach ($array as $key => $value) {
$i = 0;
foreach ($value as $key2 => $val) {
if (!isset($newArray[$i])) {
