// create var for the currentWindow
var currentWin = Ti.UI.currentWindow;
Ti.UI.currentWindow.barColor = 'black';

var lmin = currentWin.lmin;
var pressure = currentWin.pressure;

var db = Ti.Database.install('../products.sqlite','productSpecs');

var prodName = Ti.UI.currentWindow.prodName;


var rows = db.execute('SELECT * FROM products WHERE name="' + prodName + '" AND filter_low <= ? AND filter_high >= ?', lmin, lmin);

var presscol = rows.fieldByName('pressure');
var presscal = ((3*(lmin/presscol)*(lmin/presscol)*100/100)).toFixed(2);




var scrollView = Titanium.UI.createScrollView({
    contentWidth:'auto',
    contentHeight:'auto',
    top:0,
    showVerticalScrollIndicator:true,
    showHorizontalScrollIndicator:true
});







var view = Ti.UI.createView({
    top:0,

    backgroundColor:'black'

});


var imageview = Ti.UI.createImageView({
	  image:'img/' + rows.fieldByName('img'),
    top:0,
    left:10,
    width:85,
    height:75,
	borderWidth:2,
		borderColor:'#2A2A2A'

});

var pressurelabel = Titanium.UI.createLabel({
    height: 'auto',
    top: 0,
	left:110,
    text:'Pressure: ' + presscal,
    color:'white',
	Font:{fontWeight:'bold', fontSize:20}


});



var qualitylabel = Titanium.UI.createLabel({
    height: 'auto',
    top: 20,
	left:110,
    text:'Quality: ' + rows.fieldByName('quality'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:15}




});


var maxspeed = Titanium.UI.createLabel({
    height: 'auto',
    top: 40,
	left:110,
    text:'Max km/h: ' + rows.fieldByName('onecap'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:15}




});

var minspeed = Titanium.UI.createLabel({
    height: 'auto',
    top: 60,
	left:110,
    text:'Min km/h: ' + rows.fieldByName('twelvecap'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:15}




});


var cap1 = Titanium.UI.createLabel({
    height: 'auto',
    top: 90,
	left:10,
    text:'12 Cap: ' + rows.fieldByName('twelvecap'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:13}




});


var cap2 = Titanium.UI.createLabel({
    height: 'auto',
    top: 90,
	left:150,
    text:'12 Cap: ' + rows.fieldByName('twelvecap'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:13}




});


var cap3 = Titanium.UI.createLabel({
    height: 'auto',
    top: 110,
	left:10,
    text:'12 Cap: ' + rows.fieldByName('twelvecap'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:13}




});


var cap4 = Titanium.UI.createLabel({
    height: 'auto',
    top: 110,
	left:150,
    text:'12 Cap: ' + rows.fieldByName('twelvecap'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:13}




});


var infoview = Ti.UI.createView({
    top:140,
    backgroundColor:'black'

});

var infolabel = Titanium.UI.createLabel({
    top: 0,
	left:10,
    right:10,
    text:'Info: ' + rows.fieldByName('info'),
    color:'white',
		Font:{fontWeight:'normal', fontSize:12},
        backgroundColor:'black'




});



scrollView.add(view);
currentWin.add(scrollView);






view.add(qualitylabel);
view.add(maxspeed);
view.add(minspeed);
view.add(cap1);
view.add(cap2);
view.add(cap3);
view.add(cap4);


infoview.add(infolabel);
view.add(pressurelabel);

view.add(imageview);
view.add(infoview);
currentWin.add(view);