#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WinAPIFiles.au3>
#include <File.au3>
#include <Array.au3>
#include <GUIConstantsEx.au3>
#include <GUIConstants.au3>
#include <Date.au3>
#include <GuiConstants.au3>
#include <WindowsConstants.au3>
#include <AVIConstants.au3>
#include <ButtonConstants.au3>
#include <ComboConstants.au3>
#include <Constants.au3>
#include <DateTimeConstants.au3>
#include <EditConstants.au3>
#include <FontConstants.au3>
#include <GDIPlusConstants.au3>
#include <HeaderConstants.au3>
#include <ImageListConstants.au3>
#include <IPAddressConstants.au3>
#include <ListBoxConstants.au3>
#include <ListViewConstants.au3>
#include <MemoryConstants.au3>
#include <MenuConstants.au3>
#include <ProgressConstants.au3>
#include <RebarConstants.au3>
#include <ScrollBarConstants.au3>
#include <SecurityConstants.au3>
#include <SliderConstants.au3>
#include <StaticConstants.au3>
#include <StructureConstants.au3>
#include <TabConstants.au3>
#include <ToolbarConstants.au3>
#include <TooltipConstants.au3>
#include <TreeviewConstants.au3>
#include <UpDownConstants.au3>
#include <WindowsConstants.au3>
#include <GUIEdit.au3>
#include <array.au3>
#include <Misc.au3>
#include <String.au3>
#include <GuiListView.au3>
#include <WindowsConstants.au3>
#include <ButtonConstants.au3>
#include <ComboConstants.au3>
#include <EditConstants.au3>
#include <GUIListBox.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>
#include <Timers.au3>
#include <EditConstants.au3>
#include <Crypt.au3>
#include <excel.au3>
#include <GuiComboBox.au3>
#include <WindowsConstants.au3>
#include "Json.au3"
#include <Math.au3>
#include "ProcessEx.au3"
#include <SQLite.au3>
#include <SQLite.dll.au3>
$RepairProjectdbDir = @ScriptDir & "\Repair_Projects\db"
uploadProject()
Func uploadProject()
	Local $imeirow
	$projectFile = FileOpenDialog("Select A Project", @WindowsDir & "\", "Repair Project (*.csv)")
	$lastline = FileReadLine($projectFile,-1)
	$ilineArray = StringSplit($lastline,",")
	$project = $ilineArray[6]
	$ProjectDb = $RepairProjectdbDir & "\" & $project & ".db"
	$query = "CREATE TABLE RPRF (imei,model,technician,qc,itb,project,id,startdate,lastdate,repairissues,repairstatus,repaircount,repairhistory,testinghistory,invoice);"
	createnewDB($ProjectDb,$query)
	_SQLite_Startup()
	$dbn=_SQLite_Open($ProjectDb)
	For $i = 2 to _FileCountLines($projectFile)
		$iline = FileReadLine($projectFile,$i)
		If StringInStr($iline,",") Then
			$ilineArray = StringSplit($iline,",")
			$imei = $ilineArray[1]
			$Model = $ilineArray[2]
			$technician = $ilineArray[3]
			$qc = $ilineArray[4]
			$itb = $ilineArray[5]
			$project = $ilineArray[6]
			$id = $ilineArray[7]
			$repair_issues = ""
			$repair_status = ""
			$repair_count = 0
			$repair_history = ""
			$testing_history = ""
			$invoice = ""
			$start_date = _NowDate()
			$last_date = _NowDate()
			_SQLite_QuerySingleRow($dbn,"SELECT imei FROM RPRF WHERE imei='" & $imei & "'",$imeirow)
			If $imeirow[0] <> "" Then
				GUICtrlSetData($StatusLabel,"Updating " & $imei)
				_SQLite_Exec($dbn,"UPDATE RPRF SET model='"&$Model&"',technician='"&$technician&"',qc='"&$qc&"',itb='"&$itb&"',project='"&$project&"',id='"&$id&"' WHERE imei='"&$imei&"'")
			Else
				GUICtrlSetData($StatusLabel,"Adding " & $imei)
			_SQLite_Exec($dbn,"INSERT INTO RPRF (imei,model,technician,qc,itb,project,id,startdate,lastdate,repairissues,repairstatus,repaircount,repairhistory,testinghistory,invoice) VALUES ('"&$imei&"','"&$model&"','"&$technician&"','"&$qc&"','"&$itb&"','"&$project&"','"&$id&"','"&$start_date&"','"&$last_date&"','"&$repair_issues&"','"&$repair_status&"','"&$repair_count&"','"&$repair_history&"','"&$testing_history&"','"&$invoice&"');")
			EndIf
		EndIf
	Next
	_SQLite_Close($dbn)
	_SQLite_Shutdown()
	GUICtrlSetData($StatusLabel,"Project created.")
EndFunc



Func createnewDB($db,$query)
	If not FileExists($db) Then
		_SQLite_Startup()
		$dbn=_SQLite_Open($db)
		if _SQLite_Exec($dbn,$query) = $SQLITE_OK Then
			MsgBox(0,"",$db)
		Else
			MsgBox(0,"",@error)
		EndIf
		sleep(200)
		_SQLite_Close($dbn)
		_SQLite_Shutdown()
	EndIf
EndFunc