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_commentsData($comment_Id, $acc_Id, $comment, $album_Id, $comment_ts)
{
$insertQuery = "INSERT INTO user_comments(comment_Id,acc_Id,comment,album_Id,comment_ts) ";
$insertQuery .= "VALUES ('" . $comment_Id . "','" . $acc_Id . "','" . $comment . "','" . $album_Id . "','" . $comment_ts . "');";
$this->logger->info("[func - adduser_commentsData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
function adduser_logtimeData($history_Id, $acc_Id, $logIn, $logOut, $latitude, $longitude)
{
$insertQuery = "INSERT INTO user_logtime(history_Id,acc_Id,logIn,logOut,latitude,longitude) ";
$insertQuery .= "VALUES ('" . $history_Id . "','" . $acc_Id . "','" . $logIn . "','" . $logOut . "','" . $latitude . "','" . $longitude . "');";
$this->logger->info("[func - adduser_logtimeData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
function addmw_accountsData($mw_Id, $app_Id, $secretKey, $access)
{
$insertQuery = "INSERT INTO mw_accounts(mw_Id,app_Id,secretKey,access) ";
$insertQuery .= "VALUES ('" . $mw_Id . "','" . $app_Id . "','" . $secretKey . "','" . $access . "');";
$this->logger->info("[func - addmw_accountsData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
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 adduser_addressData($profile_Id, $acc_Id, $c_al_1, $c_al_2, $c_city, $c_state, $c_country, $c_zipcode, $c_timezone, $c_latitude, $c_longitude, $c_zoom, $p_al_1, $p_al_2, $p_city, $p_state, $p_country, $p_zipcode, $p_timezone, $p_latitude, $p_longitude, $p_zoom)
{
$insertQuery = "INSERT INTO user_address(profile_Id,acc_Id,c_al_1,c_al_2,c_city,c_state,c_country,c_zipcode,c_timezone,c_latitude,c_longitude,c_zoom,p_al_1,p_al_2,p_city,p_state,p_country,p_zipcode,p_timezone,p_latitude,p_longitude,p_zoom) ";
$insertQuery .= "VALUES ('" . $profile_Id . "','" . $acc_Id . "','" . $c_al_1 . "','" . $c_al_2 . "','" . $c_city . "','" . $c_state . "','" . $c_country . "','" . $c_zipcode . "','" . $c_timezone . "','" . $c_latitude . "','" . $c_longitude . "','" . $c_zoom . "','" . $p_al_1 . "','" . $p_al_2 . "','" . $p_city . "','" . $p_state . "','" . $p_country . "','" . $p_zipcode . "','" . $p_timezone . "','" . $p_latitude . "','" . $p_longitude . "','" . $p_zoom . "');";
$this->logger->info("[func - adduser_addressData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
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();
}
function adduser_galleryData($gallery_Id, $acc_Id, $albumName, $publish_ts, $privacy)
{
$insertQuery = "INSERT INTO user_gallery(gallery_Id,acc_Id,albumName,publish_ts,privacy) ";
$insertQuery .= "VALUES ('" . $gallery_Id . "','" . $acc_Id . "','" . $albumName . "','" . $publish_ts . "','" . $privacy . "');";
$this->logger->info("[func - adduser_galleryData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
function adduser_likesData($likes_Id)
{
$insertQuery = "INSERT INTO user_likes(likes_Id) ";
$insertQuery .= "VALUES ('" . $likes_Id . "');";
$this->logger->info("[func - adduser_likesData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
function adduser_biodataData($biodata_Id, $acc_Id, $profile_pic, $gender, $d_o_b, $birthplace, $nationality)
{
$insertQuery = "INSERT INTO user_biodata(biodata_Id,acc_Id,profile_pic,gender,d_o_b,birthplace,nationality) ";
$insertQuery .= "VALUES ('" . $biodata_Id . "','" . $acc_Id . "','" . $profile_pic . "','" . $gender . "','" . $d_o_b . "','" . $birthplace . "','" . $nationality . "');";
$this->logger->info("[func - adduser_biodataData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
function adduser_newsfeedData($nf_Id, $status, $gallery_Id, $publish_ts)
{
$insertQuery = "INSERT INTO user_newsfeed(nf_Id,status,gallery_Id,publish_ts) ";
$insertQuery .= "VALUES ('" . $nf_Id . "','" . $status . "','" . $gallery_Id . "','" . $publish_ts . "');";
$this->logger->info("[func - adduser_newsfeedData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
function adduser_albumData($album_Id, $gallery_Id, $gallery_type, $album_URL)
{
$insertQuery = "INSERT INTO user_album(album_Id,gallery_Id,gallery_type,album_URL) ";
$insertQuery .= "VALUES ('" . $album_Id . "','" . $gallery_Id . "','" . $gallery_type . "','" . $album_URL . "');";
$this->logger->info("[func - adduser_albumData()] Query : " . $insertQuery);
$dbObject = new Database();
$dbObject->addupdateData($insertQuery);
}
