Insert - " . $sql . "
");
$result = mysqli_query($mysqlib, $sql);
}
function getConnected(){
//echo("
Debug connecting");
//database configuration
$dbServer = 'localhost'; //Define database server host
$dbUsername = 'u295234947_pipsadmin'; //Define database username
$dbPassword = 'mRT7p7F62021Wilson!'; //Define database password
$dbName = 'u295234947_pipsadmin'; //Define database name
//connect databse
$con = mysqli_connect($dbServer,$dbUsername,$dbPassword,$dbName);
if(mysqli_connect_errno()){
die("Failed to connect with MySQL: ".mysqli_connect_error());
}else{
// echo("
Returning");
return $con;
}
}
//////////////////////////////////////////////////////////////
// Simple Functions
function getBusinessName($userid){
$mysqlib = getConnected();
$sql = "SELECT * FROM `users` WHERE `oauth_uid` = '$userid' ";
$result = mysqli_query($mysqlib, $sql);
$row = mysqli_fetch_assoc($result);
return $row["company_name"];
mysqli_close($mysqlib);
}
function getTanks($userid){
$mysqlib = getConnected();
$sql = "SELECT * FROM `tanks` WHERE `user_id` = '$userid' ";
$result = mysqli_query($mysqlib, $sql);
$totalRows = mysqli_num_rows($result);
return $totalRows;
mysqli_close($mysqlib);
}
function getAllTanks($userid){
$mysqlib = getConnected();
$sql = "SELECT * , `tanks`.`status` AS tstatus FROM `tanks` LEFT JOIN `batch` ON `tanks`.`tank_id` = `batch`.`tank_id` WHERE `tanks`.`user_id` = '$userid' ORDER BY `sort` ASC";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getAllEmptyTanks($userid){
$mysqlib = getConnected();
$sql = "SELECT * FROM `tanks` WHERE `user_id` = '$userid' AND `status` = '3' ORDER BY `sort` ASC ";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getAllBatch($userid,$status){
$mysqlib = getConnected();
if ($status == "") {
$sql = "SELECT * FROM `batch`, `tanks` WHERE `tanks`.`tank_id` = `batch`.`tank_id` AND `batch`.`user_id` = '$userid' ORDER BY `internal_batch_id` ASC ";
//echo($sql);
}
else {
$sql = "SELECT * FROM `batch` WHERE `user_id` = '$userid' AND `status` = '$status' ORDER BY `internal_batch_id` ASC ";
}
//echo("$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getBatch($userid,$batch_id){
$mysqlib = getConnected();
$sql = "SELECT * FROM `batch` as b, `tanks` AS A WHERE A.`tank_id` = b.`tank_id` and b.`user_id` = '$userid' AND b.`batch_id` = '$batch_id' ORDER BY `internal_batch_id` ASC ";
// echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getNotesType($userid){
$mysqlib = getConnected();
$sql = "SELECT * FROM `note_types`";
// echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getNoteTypeID($data){
$mysqlib = getConnected();
$sql = "SELECT * FROM `note_types` WHERE `note_function` = '$data'";
// echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$result = mysqli_fetch_assoc($result);
$idNo = $result['note_type_id'];
return $idNo;
mysqli_close($mysqlib);
}
function getNotes($userid,$batch_id){
$mysqlib = getConnected();
$sql = "SELECT * FROM `notes` as a, `note_types` as b WHERE a.`note_type_id` = b.`note_type_id` AND `batch_id` = '$batch_id' AND `user_id` = '$userid' ORDER BY `date_time` DESC";
// echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getSG($userid,$batch_id){
$mysqlib = getConnected();
$sql = "SELECT * FROM `notes` WHERE `note_type_id` = '1' AND `batch_id` = '$batch_id' AND `user_id` = '$userid' ORDER BY `date_time` ASC";
// echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getTankName($userid,$tank_id){
$mysqlib = getConnected();
$sql = "SELECT * FROM `tanks` WHERE `user_id` = '$userid' AND `tank_id` = '$tank_id' ";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$results = mysqli_fetch_assoc($result);
//echo("To Return " .$totalRows = mysqli_num_rows($result) . " --- " . $result['tank_internal_name']);
return $results['tank_internal_id'];
mysqli_close($mysqlib);
}
function getTanksStatus($userid,$status){
$mysqlib = getConnected();
$sql = "SELECT * FROM `tanks` WHERE `user_id` = '$userid' AND `status` = '$status' ";
//.echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
return $result;
mysqli_close($mysqlib);
}
function getAllStatus() {
$mysqlib = getConnected();
$sql = "SELECT * FROM `tank_status`";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$totalRows = mysqli_num_rows($result);
//echo("
$sql - Total Rows - $totalRows");
return $result;
mysqli_close($mysqlib);
}
function getTankStatusName($status_id){
$mysqlib = getConnected();
$sql = "SELECT * FROM `tank_status` WHERE `status_id` = '$status_id' ";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$results = mysqli_fetch_assoc($result);
return $results['name'];
mysqli_close($mysqlib);
}
function getBatchStatus($id,$tank_id){
$mysqlib = getConnected();
$sql = "SELECT * FROM `tanks`, `tank_status` WHERE `user_id` = '$id' AND `tanks`.`status` = `tank_status`.`status_id` AND `tank_id` = '$tank_id' ";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$results = mysqli_fetch_assoc($result);
//echo("
" . $results['name']);
return $results['name'];
mysqli_close($mysqlib);
}
function getCurrentABV($userid, $batch){
$mysqlib = getConnected();
$sql = "SELECT * FROM `notes` WHERE `note_type_id` = '1' AND `batch_id` = '$batch' AND `user_id` = '$userid' ORDER BY `date_time` DESC";
echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$results = mysqli_fetch_assoc($result);
return $results['data_3'];
mysqli_close($mysqlib);
}
function getCurrentSG($userid, $batch){
$mysqlib = getConnected();
$sql = "SELECT * FROM `notes` WHERE `note_type_id` = '1' AND `batch_id` = '$batch' AND `user_id` = '$userid' ORDER BY `date_time` DESC";
//echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$results = mysqli_fetch_assoc($result);
return $results['data_3'];
mysqli_close($mysqlib);
}
function getTotalSugarAdded($batch){
$mysqlib = getConnected();
$sql = "SELECT * FROM `notes` WHERE `batch_id` = '$batch' AND `note_type_id` ='2'";
// echo("
$sql");
$result = mysqli_query($mysqlib, $sql);
$totalSugar = 0;
while($row = mysqli_fetch_assoc($result)) {
$totalSugar = $totalSugar + $row['data_2'];
}
return $totalSugar;
}
function getAllProducts() {
$mysqlib = getConnected();
$sql = "SELECT * FROM `products`";
$result = mysqli_query($mysqlib, $sql);
//$results = mysqli_fetch_assoc($result);
return $result;
mysqli_close($mysqlib);
}
?>