require_once 'signup.php';
require_once 'login_provider.php';
require_once 'consumer.php';
require_once 'forgot_password.php';
require_once 'subscription.php';
?>
<!-- side-find-a-match -->
<div class="side-find-a-match">
<?php
$subsRecord = getSubscriptionRecordView($_SESSION['provider']['serviceprovider_id']);
if ($_SESSION['provider']['serviceprovider_id'] == '') {
echo '<a href="/code.php">Unlock Your Account!</a>';
} else {
$subsRecord = getSubscriptionRecordView($_SESSION['provider']['serviceprovider_id']);
if ($subsRecord != "") {
echo '<a href="analytics.php">Analyze Your Market!</a>';
} else {
if (substr($_SERVER["SCRIPT_NAME"], strrpos($_SERVER["SCRIPT_NAME"], "/") + 1) !== 'provider_products.php') {
echo '<a href="javascript: void(0);" onclick="show_provider_subscription_msg();">Analyze Your Market!</a>';
} else {
echo ' <a href="javascript: void(0);" onclick="return provider_subscription();">Subscribe Now!</a>';
}
}
}
?>
</div><!--/side-find-a-match-->
<!-- side-section-c -->
<div class="side-section-c"><div class="side-section-c-inner">
<?php
session_start();
include_once '../dao/dbcon.php';
include_once '../dao/consumer.php';
include_once '../dao/serviceskills.php';
include_once '../dao/staff.php';
include_once '../dao/service.php';
include_once '../dao/address.php';
$consumer_id = $_SESSION['consumer']['itconsumer_id'];
$search_id = $_SESSION['$search_id'];
$subsRecord = getSubscriptionRecordView($consumer_id);
//subscription record from history
//------------------------------------- Paging -------------------------------------------
$rowsPerPage = 1;
$pageNum = 1;
if (isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
if ($subsRecord != "") {
$qry5 = pg_query_params("select distinct(matchhistory.serviceprovider_id), toprated, rank\n\t\t\t\t\t\t\tfrom techmatcher.matchhistory left join\n\t\t\t\t\t\t\t(select serviceprovider_id,sum(ratingscore)as totalscore, rank() over(order by sum(ratingscore) DESC), \n\t\t\t\t\t\t\t\tcase when (rank() over (order by sum(ratingscore) DESC) \n\t\t\t\t\t\t\t\tbetween 1 and 5) and sum(ratingscore) > 4 then 'Top Rated Provider!' end as toprated\n\t\t\t\t\t\t\t\t from techmatcher.ratingevents join \n\t\t\t\t\t\t\t\t (select ratingsystem_id, max(ratingeventdate) ratingeventdate from techmatcher.ratingevents group by ratingsystem_id) latest \n\t\t\t\t\t\t\t\t on (ratingevents.ratingeventdate=latest.ratingeventdate and ratingevents.ratingsystem_id=latest.ratingsystem_id)\n\t\t\t\t\t\t\t\tgroup by serviceprovider_id) ratings\n\t\t\t\t\t\t\ton (matchhistory.serviceprovider_id=ratings.serviceprovider_id) where itconsumer_id =\$1\n\t\t\t\t\t\t\tand search_id=\$2", array($consumer_id, $_SESSION['search_id']));
$row = pg_num_rows($qry5);
$numrows = $row;
} else {
$row = 5;
$numrows = $row;
}
$maxPage = ceil($numrows / $rowsPerPage);
$self = $_SERVER['PHP_SELF'];
if ($pageNum > 1) {
require_once 'login_logout_dao.php';
require_once 'consumer.php';
require_once 'signup.php';
require_once 'login_consumer.php';
require_once 'forgot_password.php';
require_once 'free_search.php';
require_once 'advance_search_progress_bar.php';
require_once 'advance_search.php';
?>
<!-- side-find-a-match -->
<div class="side-find-a-match">
<?php
if ($_SESSION['consumer']['itconsumer_id'] == '') {
echo '<a href="javascript: void(0);" onclick="return open_signup_dialog(2);">Sign Up Now!</a>';
} else {
$subsRecord = getSubscriptionRecordView($_SESSION['consumer']['itconsumer_id']);
//subscription record from history
if ($subsRecord != "") {
//<!-- there is a consumer_id and a subscription -->
echo '<a href="javascript: void(0);" onclick="open_advance_search_dialog();">Get a Match Now!</a>';
} else {
//no subscriber record
if (substr($_SERVER["SCRIPT_NAME"], strrpos($_SERVER["SCRIPT_NAME"], "/") + 1) == 'consumer_products.php') {
echo '<a href="javascript: void(0);" onclick="return consumer_subscription();">Subscribe Now!</a>';
} else {
if (is_file('consumer_products.php')) {
echo '<a href="consumer_products.php">Get a Match Now!</a>';
} else {
echo '<a href="consumer/consumer_products.php">Get a Match Now!</a>';
}
}
if (!is_valid_email($emails)) {
$message = "Whoa check again, that email address is not valid!";
echo $message;
} else {
if (!$user) {
create_user_in_db();
// login successfull
$temp = consumer_findByEmail($emails);
$_SESSION['consumer'] = $temp;
include_once '../emails/signup_email.php';
//sending email
echo "OK";
} else {
if ($user && $user['recordstatus'] == 'initialentry') {
// if user exists but subscription type is empty or null
update_user_in_db($emails, $name, $sec_pass, $substype);
$temp = consumer_findByEmail($emails);
$_SESSION['consumer'] = $temp;
$profile = getProfileEntry($emails);
$subsRec = getSubscriptionRecordView($temp['itconsumer_id']);
$_SESSION['a'] = 0;
include_once '../emails/signup_email.php';
echo "OK";
} else {
$message = "Oops, that email already exists!";
echo $message;
}
}
}
}
//end of user already exists w password check