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>';
            }
        }
Beispiel #4
0
    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