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