function getmw_accountsData($inputArray, $outputArray)
{
$output = '';
$input = '';
/* Setting up Output Array */
if ($outputArray != '*') {
for ($outputInd = 0; $outputInd < count($outputArray); $outputInd++) {
$output .= $outputArray[$outputInd] . ",";
}
$output = chop($output, ",");
} else {
$output = $outputArray;
}
/* Setting up Input Array */
if ($inputArray != '1') {
while (list($key, $val) = each($inputArray)) {
$input .= $key . "='" . $val . "' AND ";
}
$input = chop($input, "AND ");
} else {
$input = $inputArray;
}
$selectQuery = "SELECT " . $output . " FROM mw_accounts WHERE " . $input;
$this->logger->info("[func - getmw_accountsData()] Query : " . $selectQuery);
$dbObject = new Database();
$conn = $dbObject->dbinteraction(constant("MW_SNAME"), constant("MW_DBNAME"), constant("MW_USER"), constant("MW_PWD"));
$jsonData = $dbObject->getJSONData($conn, $selectQuery);
$conn->close();
return $jsonData;
}
function deletebiz_subcategoriesbiz_categoriesData($inputArray)
{
$input = '';
/* Setting up Input Array */
if ($inputArray != '1') {
while (list($key, $val) = each($inputArray)) {
$input .= $key . "='" . $val . "',";
}
$input = chop($input, ",");
} else {
$input = $inputArray;
}
$deleteQuery = "DELETE FROM biz_subcategories,biz_categories WHERE " . $input . ";";
$this->logger->info("[func - deletebiz_subcategoriesbiz_categoriesData()] Query : " . $deleteQuery);
$dbObject = new Database();
$conn = $dbObject->dbinteraction($biz_sname, $biz_dbname, $biz_user, $biz_pwd);
$dbObject->addupdateData($conn, $deleteQuery);
$conn->close();
}
function adduser_accountsData($acc_Id, $username, $firstName, $middleName, $lastName, $email_Id, $primaryMob, $secondaryMob, $acc_pwd, $date_of_Join, $act, $cur_latitude, $cur_longitude, $cur_zoom, $isAdmin, $isModerate, $isUser, $isMerchant)
{
$insertQuery = "INSERT INTO user_accounts(acc_Id,username,firstName,middleName,lastName,email_Id,primaryMob,secondaryMob,acc_pwd,date_of_Join,act,cur_latitude,cur_longitude,cur_zoom,isAdmin,isModerate,isUser,isMerchant) ";
$insertQuery .= "VALUES ('" . $acc_Id . "','" . $username . "','" . $firstName . "','" . $middleName . "','" . $lastName . "','" . $email_Id . "','" . $primaryMob . "','" . $secondaryMob . "','" . $acc_pwd . "','" . $date_of_Join . "','" . $act . "','" . $cur_latitude . "','" . $cur_longitude . "','" . $cur_zoom . "','" . $isAdmin . "','" . $isModerate . "','" . $isUser . "','" . $isMerchant . "');";
$this->logger->info("[func - adduser_accountsData()] Query : " . $insertQuery);
$dbObject = new Database();
$conn = $dbObject->dbinteraction(constant("USER_SNAME"), constant("USER_DBNAME"), constant("USER_USER"), constant("USER_PWD"));
$dbObject->addupdateData($conn, $insertQuery);
$conn->close();
}
function addbiz_categoriesData($category_Id, $categoryName, $categoryDesc, $categoryprofilepic)
{
$insertQuery = "INSERT INTO biz_categories(category_Id,categoryName,categoryDesc,categoryprofilepic) ";
$insertQuery .= "VALUES ('" . $category_Id . "','" . $categoryName . "','" . $categoryDesc . "','" . $categoryprofilepic . "');";
$this->logger->info("[func - addbiz_categoriesData()] Query : " . $insertQuery);
$dbObject = new Database();
$conn = $dbObject->dbinteraction($biz_sname, $biz_dbname, $biz_user, $biz_pwd);
$dbObject->addupdateData($conn, $insertQuery);
$conn->close();
}
