ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / invest.credityork.com / wp-content / plugins / portfolio

<?php
/*
Plugin Name: investments
Description: investments products.
Version: 4.27
Author: 3gmediasolution
Text Domain: ure
Domain Path: /lang/
*/
/*
Copyright 2021
*/

add_action('init', 'what_are_our_investments');
 
function what_are_our_investments() {
 
 $labels = array(
  'name' => _x('Investments', 'post type general name'),
  'singular_name' => _x('investments', 'post type singular name'),
  'add_new' => _x('Add New', 'investments item'),
  'add_new_item' => __('Add New investments Item'),
  'edit_item' => __('Edit investments Item'),
  'new_item' => __('New investments Item'),
  'view_item' => __('View investments Item'),
  'search_items' => __('Search investments'),
  'not_found' =>  __('Nothing found'),
  'not_found_in_trash' => __('Nothing found in Trash'),
  'parent_item_colon' => ''
 );
 
 $args = array(
  'labels' => $labels,
  'public' => true,
  'publicly_queryable' => true,
  'show_ui' => true,
  'query_var' => true,
  //'menu_icon' => get_stylesheet_directory_uri() . '/article16.png',
  'rewrite' => true,
  'capability_type' => 'post',
  'hierarchical' => false,
  'menu_position' => null,
  'supports' => array('title','editor','thumbnail','custom-fields')
   ); 
 
 register_post_type( 'investments' , $args );
}

add_action( 'init', 'our_investments_create_taxonomies', 0 );
function our_investments_create_taxonomies() 
{
    // Project Categories
    register_taxonomy('investments-cat',array('investments'),array(
        'hierarchical' => true,
        'label' => 'Categories',
        'singular_name' => 'investments_category',
        'show_ui' => true,
        'query_var' => true,
        'rewrite' => array('slug' => 'investments-cat' )
    ));
  
  register_taxonomy( 
    'our_investments_tag', 
    'investments', 
    array( 
      'hierarchical'  => false, 
      'label'         => __( 'Tags', CURRENT_THEME ), 
      'singular_name' => __( 'Tag', CURRENT_THEME ), 
      'rewrite'       => true, 
      'query_var'     => true 
    )  
  );
}

/*---------------what_are_other_asking post type end---------------*/

add_filter( 'comments_open', 'my_comments_open', 10, 2 );
function my_comments_open( $open, $post_id ) {
$post = get_post( $post_id );

if ( 'investments' == $post->post_type )
    $open = true;
return $open;
}

add_shortcode('page_redirection', 'page_redirection');
   function page_redirection(){
    ob_start();
    page_redirection_code();
    return ob_get_clean();
   }

function page_redirection_code() {

if ( is_user_logged_in() ) {
      $current_user_id = get_current_user_id();
      $user_meta=get_userdata($current_user_id);
      echo $user_roles = $user_meta->roles;

echo $_COOKIE["get_permalink"];
        if ($_COOKIE["get_permalink"] != "") {
          wp_redirect($_COOKIE["get_permalink"]);
        }else{
          $site_url = site_url()."/dashboard";
          wp_redirect($site_url);
        }
      }

}

function rm_register_meta_box() {
    add_meta_box( 'rm-meta-box-id', esc_html__( 'Investment', 'text-domain' ), 'rm_meta_box_callback', 'investments', 'advanced', 'high' );
}
add_action( 'add_meta_boxes', 'rm_register_meta_box');
 
//Add field
function rm_meta_box_callback( $meta_id ) {
 
    global $post;
    global $wpdb;
    $pid = $post->ID;

$investmentdata = $wpdb->get_row("SELECT SUM(`paid_amount`) AS total_investment FROM transaction WHERE `item_number` = '".$pid."'");
    $totalinvestment = $investmentdata->total_investment/100;
    $totalinvestment_round = round($totalinvestment);
    $total_investment = number_format($totalinvestment_round,2,".",",");

$outline = '<b>Total Investment:- </b>';
    $outline .= '<b>'.$total_investment.'</b>';
 
    echo $outline;
}

function add_admin_column($column_title, $post_type, $cb){

// Column Header
    add_filter( 'manage_' . $post_type . '_posts_columns', function($columns) use ($column_title) {
        $columns[ sanitize_title($column_title) ] = $column_title;
        return $columns;
    } );

// Column Content
    add_action( 'manage_' . $post_type . '_posts_custom_column' , function( $column, $post_id ) use ($column_title, $cb) {

if(sanitize_title($column_title) === $column){
            $cb($post_id);
        }

}, 10, 2 );
}

add_admin_column(__('Total Investment'), 'investments', function($post_id){

global $post;
    global $wpdb;
    $pid = $post_id;

add_admin_column(__('Total Investors'), 'investments', function($post_id){

global $post;
    global $wpdb;
    $pid = $post_id;

$investors_data = $wpdb->get_row("SELECT COUNT(DISTINCT `cust_id`) AS investors from transaction WHERE `item_number` = '".$pid."'");
  $investors_count = $investors_data->investors;
  echo $investors_count;
});

function generateRandomString($length = 10) {
    return substr(str_shuffle(str_repeat($x='0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', ceil($length/strlen($x)) )),1,$length);
}

add_shortcode('cr_portfolio', 'portfolio_cust');
   function portfolio_cust(){
    ob_start();
    portfolio_cust_show();
    return ob_get_clean();
   }

function portfolio_cust_show() {

global $wpdb;

<div class="portfolio__list">
   <div class="portfolio__list__inner">
      <div class="container">
         <div class="row">
<?php
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
  
$args = array(
              'post_type' => 'investments',
              'posts_per_page' => 28,
              'paged'=> $paged,
              'order' => 'DESC'
          );
   $query = new WP_Query( $args );
  if ( $query->have_posts() ) : while ( $query->have_posts() ) : $query->the_post();

$pid = get_the_ID();

$investors_data = $wpdb->get_row("SELECT COUNT(DISTINCT `cust_id`) AS investors from transaction WHERE `item_number` = '".$pid."'");
  $investors_count = $investors_data->investors;

$img_url = wp_get_attachment_url( get_post_thumbnail_id($post->ID), 'thumbnail' );
?>

<div class="col-xl-3 clo-lg-6 col-md-6 col-sm-6 mr__top">
               <div class="portfolio__card">
                  <a href="<?php the_permalink();?>">
                      <?php
                      $term_list = get_the_terms($post->ID, 'investments-cat');
                      foreach ( $term_list as $term ) { ?>
                      <div class="category__tag"><?php echo $term->name; ?></div>
                      <?php } ?>
                     <div class="cover__banner"><img src="<?php echo $img_url; ?>" alt="" /></div>
                     <div class="portfolio__card__content">
                        <h3><?php echo get_field('title',$post->ID); ?></h3>
                        <div class="progress__bar success__bar"></div>
                        <p> <?php echo substr(get_field('subtitle',$post->ID),0,20)."..."; ?></p>
                        <div class="investment__detail">
                           <div class="investment__detail__inner">
                              <div class="offering__stats">
                                 <h5><?php echo count_style($totalinvestment_round); ?></h5>
                                 <h6>Raised</h6>
                              </div>
                           </div>
                           <div class="investment__detail__inner">
                              <div class="offering__stats">
                                 <h5><?php echo count_style($investors_count); ?></h5>
                                 <h6>Investors</h6>
                              </div>
                           </div>
                           <div class="investment__detail__inner">
                              <div class="offering__stats">
                                 <h5><?php echo get_field('min_investment',$post->ID); ?></h5>
                                 <h6>Min Invest</h6>
                              </div>
                           </div>
                        </div>
                     </div>
                  </a>
               </div>
            </div>

<?php
endwhile;

$big = 999999999; 
echo paginate_links( array(
    'base' => str_replace( $big, '%#%', esc_url( get_pagenum_link( $big ) ) ),
    'format' => '?paged=%#%',
    'current' => max( 1, get_query_var('paged') ),
    'total' => $query->max_num_pages
) );
endif;
wp_reset_postdata();
?>
         </div>
      </div>
   </div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta2/dist/js/bootstrap.bundle.min.js" integrity="sha384-b5kHyXgcpbZJO/tY9Ul7kGkf1S0CWuKcCD38l8YkeH8z8QjE0GmW1gYU5S9FOnJ0" crossorigin="anonymous"></script>
<?php
}

add_shortcode('single_portfolio', 'portfolio_single');
   function portfolio_single(){
    ob_start();
    portfolio_single_show();
    return ob_get_clean();
   }

function portfolio_single_show() {
    $site_url = site_url()."/login";
    $get_permalink = get_permalink();
    setcookie("get_permalink", $get_permalink, time() + (86400 * 30), "/");
    global $post;
    global $wpdb;
    $pid = $post->ID;

$investors_data = $wpdb->get_row("SELECT COUNT(DISTINCT `cust_id`) AS investors from transaction WHERE `item_number` = '".$pid."'");
  $investors_count = $investors_data->investors;

<div class="portfolio__detail__top__wrapp">
    <div class="portfolio__video__imege">
     <div class="display__brand">
    <div class="image__box"><img src="<?php the_field('logo',$post->ID); ?>" alt="" /></div>
    <div class="brand__detail">
      <h3><?php echo get_field('title',$post->ID); ?></h3>
            <h4><?php   echo get_field('subtitle',$post->ID); ?></h4>
    </div>  
    </div> 
     <div class="image__box">
       <iframe width="420" height="315" src="<?php  echo get_field('media_link',$post->ID); ?>"></iframe> 
     </div>
     <div class="portfolio__categories">
        <div class="site__location">
        <a href="<?php echo get_field('website_link',$post->ID); ?>" target="_blank"><i class="ico__box"><img src="<?php echo site_url(); ?>/wp-content/plugins/investments/images/link.svg" alt="" /></i>Website</a>
        <p><i class="ico__box"><img src="<?php echo site_url(); ?>/wp-content/plugins/investments/images/location-pin.svg" alt="" /></i><?php echo get_field('place_name',$post->ID); ?></p>
      </div>
      <?php
    $term_list = get_the_terms($post->ID, 'investments-cat');
      foreach ( $term_list as $term ) {
        ?>
       <div class="category"><?php echo $term->name; ?></div> 
      <?php } ?>
     
     </div>
      
     <p>

<p><?php echo get_field('description',$post->ID); ?></p>
</p> 
      
      
    </div>
    
   <div class="investment__detail">
    <div class="raised__amount">
      <h2>$<?php echo $total_investment; ?></h2>
      <div class="raised" data-toggle="tooltip" title="" data-original-title="IntriEnergy is raising up to $1.07M with a minimum goal of $10K">raised</div> 
      <div class="i__container"><i class="ico__box" data-toggle="tooltip" title="" data-original-title="IntriEnergy is raising up to $1.07M with a minimum goal of $10K">
        <img src="<?php echo site_url(); ?>/wp-content/plugins/investments/images/info.svg" alt="" /></i>
          </div>  
    </div>
    <div class="investment__detail__inner">
      <div class="offering__stats">
      <h5><?php echo $investors_count; ?></h5>
            <h6>Investors</h6>
      </div>
      <div class="offering__stats">
      <h5><?php echo get_field('valuation',$post->ID); ?></h5>
            <h6>Valuation</h6>
      </div>  
    </div> 
    <div class="investment__detail__inner">
      <div class="offering__stats">
      <h5><?php echo get_field('price_per_share',$post->ID); ?></h5>
            <h6>Price per Share </h6>
      </div>
      <div class="offering__stats">
      <h5><?php echo get_field('min_investment',$post->ID); ?></h5>
            <h6> Min. Investment </h6>
      </div> 
      <div class="offering__stats">
      <h5><?php echo get_field('shares_offered',$post->ID); ?></h5>
            <h6>Shares Offered</h6>
      </div>  
    </div> 
    <div class="investment__detail__inner">
      <div class="offering__stats">
      <h5><?php echo get_field('offering_type',$post->ID); ?></h5>
            <h6>Offering Type</h6>
      </div>
      <div class="offering__stats">
      <h5><?php echo get_field('offering_max',$post->ID); ?></h5>
            <h6>Offering Max</h6>
      </div>  
    </div> 
    <div class="investment__detail__inner">
      <div class="offering__stats">
      <h5><?php echo get_field('offering',$post->ID); ?></h5>
            <h6>Offering</h6>
      </div>
       
    </div>  
     
    <a href="<?php echo site_url(); ?>/payment/?pid=<?php echo $post->ID; ?>">invest now</a>
   </div> 
  </div>

<?php

}

add_shortcode('payment_form', 'single_payment');
   function single_payment(){
    ob_start();
    payment_form();
    return ob_get_clean();
   }

function payment_form() {
    global $wpdb;
    $site_url = site_url()."/login";
    if ( ! is_user_logged_in() ) {
      wp_redirect($site_url);
    }

if(isset($_GET['pid'])) {
        $pid = $_GET['pid'];
    }
    echo $product_name = get_field('title',$pid);
     echo "<br>";
    echo $min_investment = get_field('min_investment',$pid);
     echo "<br>";
    echo $price_per_share = get_field('price_per_share',$post->ID);
 echo "<br>";

$investment_avg_data = $wpdb->get_row("SELECT AVG(`paid_amount`) AS avg_investment FROM transaction WHERE `item_number` = '".$pid."'");
    $avginvestment = $investment_avg_data->avg_investment/100;
    $avg_investment_round = round($avginvestment);
    echo $avg_investment = number_format($avg_investment_round,2,".",",");
       echo "<br>";

$investment_data = $wpdb->get_row("SELECT MAX(`paid_amount`) AS largest_investment FROM transaction WHERE `item_number` = '".$pid."'");
    $largestinvestment = $investment_data->largest_investment/100;
    $largest_investment_round = round($largestinvestment);
    echo $largest_investment = number_format($largest_investment_round,2,".",",");
       echo "<br>";
?>

<div class="investment__wrapp">
         <div class="container">
            <div class="display__brand">
               <div class="image__box"><img src="<?php echo site_url(); ?>/wp-content/plugins/investments/images/logo.png" alt=""></div>
               <div class="brand__detail">
                  <h3>Invest in VICAS</h3>
                  <h4>VAULTCHIP TECHNOLOGY</h4>
               </div>
            </div>
			 
			 
			 <form>
                           <div class="form-group form__group">
                              <label>Amount</label>
                              <div class="input__group">
                                 <i class="ico__box">$</i>
                                 <input type="text" name="total_amount" class="form-control form__control" placeholder="480.00 minimum">
                              </div>
                              <p>Your investment amount will be rounded up to be a multiple of the share price.</p>
                           </div>
                           <div class="form-group form__group">
                              <label>Annual Income</label>
                              <div class="input__group">
                                 <i class="ico__box">$</i>
                                 <input type="text" name="annual_income" class="form-control form__control" placeholder="Annual Income">
                              </div>
                           </div>
                           <div class="form-group form__group">
                              <label>Net Worth</label>
                              <div class="input__group">
                                 <i class="ico__box">$</i>
                                 <input type="text" name="net_worth" class="form-control form__control" placeholder="Net Worth">
                              </div>
                              <p>This information is used to calculate your investment limits for crowdfunding.</p>
                           </div>
				 
				 
                           <div class="row">
                              <div class="col-xl-6 col-lg-6 col-md-6">
                                 <div class="form-group form__group">
                                    <label>Legal First Name</label>
                                    <input type="text" name="customerName" class="form-control form__control" placeholder="">
                                 </div>
                              </div>
                              <div class="col-xl-6 col-lg-6 col-md-6">
                                 <div class="form-group form__group">
                                    <label>Legal Last Name</label>
                                    <input type="text"  name="last_name" class="form-control form__control" placeholder="">
                                 </div>
                              </div>
                           </div>
                           <div class="form-group form__group">
                              <label>Country of Residence</label>
                              <select name="customerCountry" class="selectpicker form-control select__picker">
                                 <option value="US">United States</option>
                                 <option value="AW">Aruba</option>
                                 <option value="AF">Afghanistan</option>
                                 <option value="AO">Angola</option>
                                 <option value="AI">Anguilla</option>
                                 <option value="AX">Åland Islands</option>
                                 <option value="AL">Albania</option>
                                 <option value="AD">Andorra</option>
                                 <option value="AE">United Arab Emirates</option>
                                 <option value="AR">Argentina</option>
                                 <option value="AM">Armenia</option>
                                 <option value="AQ">Antarctica</option>
                                 <option value="TF">French Southern and Antarctic Lands</option>
                                 <option value="AG">Antigua and Barbuda</option>
                                 <option value="AU">Australia</option>
                                 <option value="AT">Austria</option>
                                 <option value="AZ">Azerbaijan</option>
                                 <option value="BI">Burundi</option>
                                 <option value="BE">Belgium</option>
                                 <option value="BJ">Benin</option>
                                 <option value="BF">Burkina Faso</option>
                                 <option value="BD">Bangladesh</option>
                                 <option value="BG">Bulgaria</option>
                                 <option value="BH">Bahrain</option>
                                 <option value="BS">Bahamas</option>
                                 <option value="BA">Bosnia and Herzegovina</option>
                                 <option value="BL">Saint Barthélemy</option>
                                 <option value="BY">Belarus</option>
                                 <option value="BZ">Belize</option>
                                 <option value="BM">Bermuda</option>
                                 <option value="BO">Bolivia</option>
                                 <option value="BR">Brazil</option>
                                 <option value="BB">Barbados</option>
                                 <option value="BN">Brunei</option>
                                 <option value="BT">Bhutan</option>
                                 <option value="BV">Bouvet Island</option>
                                 <option value="BW">Botswana</option>
                                 <option value="CF">Central African Republic</option>
                                 <option value="CC">Cocos (Keeling) Islands</option>
                                 <option value="CH">Switzerland</option>
                                 <option value="CL">Chile</option>
                                 <option value="CN">China</option>
                                 <option value="CI">Ivory Coast</option>
                                 <option value="CM">Cameroon</option>
                                 <option value="CD">DR Congo</option>
                                 <option value="CG">Republic of the Congo</option>
                                 <option value="CK">Cook Islands</option>
                                 <option value="CO">Colombia</option>
                                 <option value="KM">Comoros</option>
                                 <option value="CV">Cape Verde</option>
                                 <option value="CR">Costa Rica</option>
                                 <option value="CU">Cuba</option>
                                 <option value="CW">Curaçao</option>
                                 <option value="CX">Christmas Island</option>
                                 <option value="KY">Cayman Islands</option>
                                 <option value="CY">Cyprus</option>
                                 <option value="CZ">Czech Republic</option>
                                 <option value="DE">Germany</option>
                                 <option value="DJ">Djibouti</option>
                                 <option value="DM">Dominica</option>
                                 <option value="DK">Denmark</option>
                                 <option value="DO">Dominican Republic</option>
                                 <option value="DZ">Algeria</option>
                                 <option value="EC">Ecuador</option>
                                 <option value="EG">Egypt</option>
                                 <option value="ER">Eritrea</option>
                                 <option value="EH">Western Sahara</option>
                                 <option value="ES">Spain</option>
                                 <option value="EE">Estonia</option>
                                 <option value="ET">Ethiopia</option>
                                 <option value="FI">Finland</option>
                                 <option value="FJ">Fiji</option>
                                 <option value="FK">Falkland Islands</option>
                                 <option value="FR">France</option>
                                 <option value="FO">Faroe Islands</option>
                                 <option value="GA">Gabon</option>
                                 <option value="GE">Georgia</option>
                                 <option value="GG">Guernsey</option>
                                 <option value="GH">Ghana</option>
                                 <option value="GI">Gibraltar</option>
                                 <option value="GN">Guinea</option>
                                 <option value="GP">Guadeloupe</option>
                                 <option value="GM">Gambia</option>
                                 <option value="GW">Guinea-Bissau</option>
                                 <option value="GQ">Equatorial Guinea</option>
                                 <option value="GR">Greece</option>
                                 <option value="GD">Grenada</option>
                                 <option value="GL">Greenland</option>
                                 <option value="GT">Guatemala</option>
                                 <option value="GF">French Guiana</option>
                                 <option value="GY">Guyana</option>
                                 <option value="HK">Hong Kong</option>
                                 <option value="HM">Heard Island and McDonald Islands</option>
                                 <option value="HN">Honduras</option>
                                 <option value="HR">Croatia</option>
                                 <option value="HT">Haiti</option>
                                 <option value="HU">Hungary</option>
                                 <option value="IM">Isle of Man</option>
                                 <option value="ID">Indonesia</option>
                                 <option value="IN">India</option>
                                 <option value="IO">British Indian Ocean Territory</option>
                                 <option value="IE">Ireland</option>
                                 <option value="IR">Iran</option>
                                 <option value="IQ">Iraq</option>
                                 <option value="IS">Iceland</option>
                                 <option value="IL">Israel</option>
                                 <option value="IT">Italy</option>
                                 <option value="JM">Jamaica</option>
                                 <option value="JE">Jersey</option>
                                 <option value="JO">Jordan</option>
                                 <option value="JP">Japan</option>
                                 <option value="KZ">Kazakhstan</option>
                                 <option value="KE">Kenya</option>
                                 <option value="KG">Kyrgyzstan</option>
                                 <option value="KH">Cambodia</option>
                                 <option value="KI">Kiribati</option>
                                 <option value="KN">Saint Kitts and Nevis</option>
                                 <option value="KR">South Korea</option>
                                 <option value="XK">Kosovo</option>
                                 <option value="KW">Kuwait</option>
                                 <option value="LA">Laos</option>
                                 <option value="LB">Lebanon</option>
                                 <option value="LR">Liberia</option>
                                 <option value="LY">Libya</option>
                                 <option value="LC">Saint Lucia</option>
                                 <option value="LI">Liechtenstein</option>
                                 <option value="LK">Sri Lanka</option>
                                 <option value="LS">Lesotho</option>
                                 <option value="LT">Lithuania</option>
                                 <option value="LU">Luxembourg</option>
                                 <option value="LV">Latvia</option>
                                 <option value="MO">Macau</option>
                                 <option value="MF">Saint Martin</option>
                                 <option value="MA">Morocco</option>
                                 <option value="MC">Monaco</option>
                                 <option value="MD">Moldova</option>
                                 <option value="MG">Madagascar</option>
                                 <option value="MV">Maldives</option>
                                 <option value="MX">Mexico</option>
                                 <option value="MH">Marshall Islands</option>
                                 <option value="MK">Macedonia</option>
                                 <option value="ML">Mali</option>
                                 <option value="MT">Malta</option>
                                 <option value="MM">Myanmar</option>
                                 <option value="ME">Montenegro</option>
                                 <option value="MN">Mongolia</option>
                                 <option value="MZ">Mozambique</option>
                                 <option value="MR">Mauritania</option>
                                 <option value="MS">Montserrat</option>
                                 <option value="MQ">Martinique</option>
                                 <option value="MU">Mauritius</option>
                                 <option value="MW">Malawi</option>
                                 <option value="MY">Malaysia</option>
                                 <option value="YT">Mayotte</option>
                                 <option value="NA">Namibia</option>
                                 <option value="NC">New Caledonia</option>
                                 <option value="NE">Niger</option>
                                 <option value="NF">Norfolk Island</option>
                                 <option value="NG">Nigeria</option>
                                 <option value="NI">Nicaragua</option>
                                 <option value="NU">Niue</option>
                                 <option value="NL">Netherlands</option>
                                 <option value="NO">Norway</option>
                                 <option value="NP">Nepal</option>
                                 <option value="NR">Nauru</option>
                                 <option value="NZ">New Zealand</option>
                                 <option value="OM">Oman</option>
                                 <option value="PK">Pakistan</option>
                                 <option value="PA">Panama</option>
                                 <option value="PN">Pitcairn Islands</option>
                                 <option value="PE">Peru</option>
                                 <option value="PH">Philippines</option>
                                 <option value="PW">Palau</option>
                                 <option value="PG">Papua New Guinea</option>
                                 <option value="PL">Poland</option>
                                 <option value="PT">Portugal</option>
                                 <option value="PY">Paraguay</option>
                                 <option value="PS">Palestine</option>
                                 <option value="PF">French Polynesia</option>
                                 <option value="QA">Qatar</option>
                                 <option value="RE">Réunion</option>
                                 <option value="RO">Romania</option>
                                 <option value="RU">Russia</option>
                                 <option value="RW">Rwanda</option>
                                 <option value="SA">Saudi Arabia</option>
                                 <option value="SD">Sudan</option>
                                 <option value="SN">Senegal</option>
                                 <option value="SG">Singapore</option>
                                 <option value="GS">South Georgia</option>
                                 <option value="SJ">Svalbard and Jan Mayen</option>
                                 <option value="SB">Solomon Islands</option>
                                 <option value="SL">Sierra Leone</option>
                                 <option value="SV">El Salvador</option>
                                 <option value="SM">San Marino</option>
                                 <option value="SO">Somalia</option>
                                 <option value="PM">Saint Pierre and Miquelon</option>
                                 <option value="RS">Serbia</option>
                                 <option value="SS">South Sudan</option>
                                 <option value="ST">São Tomé and Príncipe</option>
                                 <option value="SR">Suriname</option>
                                 <option value="SK">Slovakia</option>
                                 <option value="SI">Slovenia</option>
                                 <option value="SE">Sweden</option>
                                 <option value="SZ">Swaziland</option>
                                 <option value="SX">Sint Maarten</option>
                                 <option value="SC">Seychelles</option>
                                 <option value="SY">Syria</option>
                                 <option value="TC">Turks and Caicos Islands</option>
                                 <option value="TD">Chad</option>
                                 <option value="TG">Togo</option>
                                 <option value="TH">Thailand</option>
                                 <option value="TJ">Tajikistan</option>
                                 <option value="TK">Tokelau</option>
                                 <option value="TM">Turkmenistan</option>
                                 <option value="TL">Timor-Leste</option>
                                 <option value="TO">Tonga</option>
                                 <option value="TT">Trinidad and Tobago</option>
                                 <option value="TN">Tunisia</option>
                                 <option value="TR">Turkey</option>
                                 <option value="TV">Tuvalu</option>
                                 <option value="TW">Taiwan</option>
                                 <option value="TZ">Tanzania</option>
                                 <option value="UG">Uganda</option>
                                 <option value="UA">Ukraine</option>
                                 <option value="UM">United States Minor Outlying Islands</option>
                                 <option value="UY">Uruguay</option>
                                 <option value="UZ">Uzbekistan</option>
                                 <option value="VA">Vatican City</option>
                                 <option value="VC">Saint Vincent and the Grenadines</option>
                                 <option value="VE">Venezuela</option>
                                 <option value="VG">British Virgin Islands</option>
                                 <option value="VN">Vietnam</option>
                                 <option value="VU">Vanuatu</option>
                                 <option value="WF">Wallis and Futuna</option>
                                 <option value="WS">Samoa</option>
                                 <option value="YE">Yemen</option>
                                 <option value="ZA">South Africa</option>
                                 <option value="ZM">Zambia</option>
                                 <option value="ZW">Zimbabwe</option>
                              </select>
                              <p>At this time, StartEngine does not accept investors from Canada or the United Kingdom.</p>
                           </div>
                           <div class="form-group form__group">
                              <label>Address Line 1</label>
                              <input type="text" class="form-control form__control" placeholder="">
                              <p>PO boxes are not permitted</p>
                           </div>
                           <div class="form-group form__group">
                              <label>Address Line 2</label>
                              <input type="text" class="form-control form__control" placeholder="">
                           </div>
                           <div class="row">
                              <div class="col-xl-4 col-lg-4">
                                 <div class="form-group form__group">
                                    <label>City</label>
                                    <input type="text" class="form-control form__control" placeholder="City">
                                 </div>
                              </div>
                              <div class="col-xl-4 col-lg-4 col-md-6">
                                 <div class="form-group form__group">
                                    <label>State</label>
                                    <input type="text" class="form-control form__control" placeholder="Sate">
                                 </div>
                              </div>
                              <div class="col-xl-4 col-lg-4 col-md-6">
                                 <div class="form-group form__group">
                                    <label>Zip Code</label>
                                    <input type="text" name="customerZipcode" class="form-control form__control" placeholder="Zip Code">
                                 </div>
                              </div>
                           </div>
                           <div class="form-group form__group">
                              <label>Cell Phone Number</label>
                              <input type="text" name="cell_phone_number" class="form-control form__control" placeholder="123-456-7890">
                              <p>By entering your mobile phone number, you consent to receive SMS messages for StartEngine investment reconfirmations when a company makes a material change to their offering.</p>
                           </div>
                           <div class="form__group__inner">
                              <input type="checkbox">
                              <label>I want to invest as a non-person legal entity such as a company, trust, or self-directed IRA</label>
                           </div>
                           <div class="form-group form__group">
                              <label>Country of Residence</label>
                              <select name="country_of_residence" class="selectpicker form-control select__picker">
                                 <option value="US">Company</option>
                                 <option value="AW">Trust</option>
                                 <option value="AF">Self-Directed IRA</option>
                              </select>
                           </div>
				 
				 
				           <div class="form__group form__group__single">
                              <input type="checkbox">
                              <label>I agree to pay for this investment by wire transfer.</label>
                              <p>Note: Minimum wire investment is $750.</p>
                           </div>
				 
				 
				 <div class="form__group form__group__single">
                              <input type="radio" name="optradio" checked>
                              <label>I am a US Citizen or US Legal Resident</label>
                           </div>
                           <div class="form__group form__group__single">
                              <input type="radio" name="optradio">
                              <label>I am not a US Citizen or US Legal Resident</label>    
                           </div>
                           <div class="form-group form__group">
                              <label>Government Issued Identification Number</label>
                              <input type="text" class="form-control form__control" placeholder="SSN, SIN, or Tax ID">
                              <p>If you do not have a national id number, enter '0000'</p>
                           </div>
                           <div class="form-group form__group">
                              <label>Date of Birth</label>
                              <div class="input-group date input__group" data-provide="datepicker">
                                 <input id="datepicker-1" name="dob" class="form-control form__control" placeholder="MM-DD-YYYY" />
                                 <div class="input-group-addon">
                                    <span class="glyphicon glyphicon-th"></span>
                                 </div>
                              </div>
                           </div>
                           <div class="form-group form__group">
                              <label>International Identification</label>
                              <p>Please upload a photo of your government-issued ID.</p>
                              <p>If your ID does not display the address of your residence, please submit a document dated within the last 90 days that clearly states your full name and residential address (No P.O. Box or commercial addresses). Examples include: Utility/Telephone Bill, Credit Card/Bank Statement.</p>
                              <div class="input-group input__group">
                                 <input type="text" name="filename" class="form-control form__control" placeholder="Upload File" readonly>
                                 <span class="input-group-btn">
                                    <div class="btn btn-default  custom-file-uploader">
                                       <input type="file" name="file" onchange="this.form.filename.value = this.files.length ? this.files[0].name : ''" />
                                       Select a file
                                    </div>
                                 </span>
                              </div>
                           </div>
                           <div class="form-group form__group">
                              <label>International Identification</label>
                              <p>Please upload a photo of your government-issued ID.</p>
                              <p>If your ID does not display the address of your residence, please submit a document dated within the last 90 days that clearly states your full name and residential address (No P.O. Box or commercial addresses). Examples include: Utility/Telephone Bill, Credit Card/Bank Statement.</p>
                              <div class="input-group input__group">
                                 <input type="text" name="filename" class="form-control form__control" placeholder="Upload File" readonly>
                                 <span class="input-group-btn">
                                    <div class="btn btn-default  custom-file-uploader">
                                       <input type="file" name="file" onchange="this.form.filename.value = this.files.length ? this.files[0].name : ''" />
                                       Select a file
                                    </div>
                                 </span>
                              </div>
                           </div>
				 
				 <div class="form-group form__group">
                              <p>I acknowledge that the entry of my name in the field below represents an e-signature as detailed in our <a href="#">terms of use</a>. I acknowledge that I have reviewed and understand the educational materials. I understand that the entire amount of my investment is at risk and may be lost, and am in a financial position to bear the loss of the investment. . I confirm that this purchase price is not more than the greater of 10% of my annual income or net worth (or no more than the greater of 10% of revenue or net assets for a business), unless I am an accredited investor.</p>
                              <p>I have read and agree to the terms set in the <a href="#">Subscription Agreement</a></p>
                           </div>
                           <div class="form-group form__group">
                              <input type="text" class="form-control form__control" placeholder="Sign your name by typing out your full name">
                           </div>
                           <div class="form-group form__group">
                              <p>By clicking "Submit" you agree with our <a href="#">Terms and Conditions</a>  &  <a href="#">Privacy Policy</a></p>
                           </div>
				 
				 
				 
                           <div class="button__wrapp__submit"><input type="submit" class="submit__btn" value="Continue"></div>
                        </form>
				
         </div>
      </div>
      <script src="<?php echo site_url(); ?>/wp-content/plugins/investments/js/bootstrap.bundle.min.js"></script>
      <script src="<?php echo site_url(); ?>/wp-content/plugins/investments/js/jquery.min.js"></script>
      <script src="<?php echo site_url(); ?>/wp-content/plugins/investments/js/bootstrap-select.min.js"></script>
      <script src="<?php echo site_url(); ?>/wp-content/plugins/investments/js/popper.min.js"></script>
      <script src="<?php echo site_url(); ?>/wp-content/plugins/investments/js/bootstrap.min.js"></script>
      <script src="<?php echo site_url(); ?>/wp-content/plugins/investments/js/gijgo.min.js" type="text/javascript"></script>
      <script>
         $('#datepicker').datepicker({
             uiLibrary: 'bootstrap4'
         });
         $('#datepicker-1').datepicker({
             uiLibrary: 'bootstrap4'
         });
         $('#datepicker-2').datepicker({
             uiLibrary: 'bootstrap4'
         });
      </script>

<div class="panel panel-default">     
      <div class="panel-heading">Order Process</div>
      <div class="panel-body">
        <form action="http://162.215.253.89/ercabarter/dev/payment-process/" method="POST" id="paymentForm">  
          <div class="row">
            <div class="col-md-8" style="border-right:1px solid #ddd;">
              <h4 align="center">Customer Details</h4>

<div class="form-group">
                <label><b>Price<span class="text-danger">*</span></b></label>
                <input type="text" name="total_amount" id="total_amount" class="form-control" value="">
              </div>

<div class="form-group">
                <label><b>Card Holder Name <span class="text-danger">*</span></b></label>
                <input type="text" name="customerName" id="customerName" class="form-control" value="">
                <span id="errorCustomerName" class="text-danger"></span>
              </div>
              <div class="form-group">
                <label><b>Email Address <span class="text-danger">*</span></b></label>
                <input type="text" name="emailAddress" id="emailAddress" class="form-control" value="">
                <span id="errorEmailAddress" class="text-danger"></span>
              </div>
              <div class="form-group">
                <label><b>Address <span class="text-danger">*</span></b></label>
                <textarea name="customerAddress" id="customerAddress" class="form-control"></textarea>
                <span id="errorCustomerAddress" class="text-danger"></span>
              </div>
              <div class="row">
                <div class="col-sm-6">
                  <div class="form-group">
                    <label><b>City <span class="text-danger">*</span></b></label>
                    <input type="text" name="customerCity" id="customerCity" class="form-control" value="">
                    <span id="errorCustomerCity" class="text-danger"></span>
                  </div>
                </div>
                <div class="col-sm-6">
                  <div class="form-group">
                    <label><b>Zip <span class="text-danger">*</span></b></label>
                    <input type="text" name="customerZipcode" id="customerZipcode" class="form-control" value="">
                    <span id="errorCustomerZipcode" class="text-danger"></span>
                  </div>
                </div>
              </div>
              <div class="row">
                <div class="col-sm-6">
                  <div class="form-group">
                    <label><b>State </b></label>
                    <input type="text" name="customerState" id="customerState" class="form-control" value="">
                  </div>
                </div>
                <div class="col-sm-6">
                  <div class="form-group">
                    <label><b>Country <span class="text-danger">*</span></b></label>
                    <input type="text" name="customerCountry" id="customerCountry" class="form-control">
                    <span id="errorCustomerCountry" class="text-danger"></span>
                  </div>
                </div>
              </div>
              <hr>
              <h4 align="center">Payment Details</h4>
              <div class="form-group">
                <label>Card Number <span class="text-danger">*</span></label>
                <input type="text" name="cardNumber" id="cardNumber" class="form-control" placeholder="1234 5678 9012 3456" maxlength="20" onkeypress="">
                <span id="errorCardNumber" class="text-danger"></span>
              </div>
              <div class="form-group">
                <div class="row">
                  <div class="col-md-4">
                    <label>Expiry Month</label>
                    <input type="text" name="cardExpMonth" id="cardExpMonth" class="form-control" placeholder="MM" maxlength="2" onkeypress="return validateNumber(event);">
                    <span id="errorCardExpMonth" class="text-danger"></span>
                  </div>
                  <div class="col-md-4">
                    <label>Expiry Year</label>
                    <input type="text" name="cardExpYear" id="cardExpYear" class="form-control" placeholder="YYYY" maxlength="4" onkeypress="return validateNumber(event);">
                    <span id="errorCardExpYear" class="text-danger"></span>
                  </div>
                  <div class="col-md-4">
                    <label>CVC</label>
                    <input type="text" name="cardCVC" id="cardCVC" class="form-control" placeholder="123" maxlength="4" onkeypress="return validateNumber(event);">
                    <span id="errorCardCvc" class="text-danger"></span>
                  </div>
                </div>
              </div>
              <br>
              <div align="center">
              <input type="hidden" name="currency_code" value="USD">
              <input type="hidden" name="item_details" value="<?php echo $product_name; ?>">
              <input type="hidden" name="item_number" value="<?php echo $pid; ?>">
              <input type="hidden" name="order_number" value="<?php echo  generateRandomString(); ?>">
              <input type="button" name="payNow" id="payNow" class="btn btn-success btn-sm" onclick="stripePay(event)" value="Pay Now" />
              </div>
              <br>
            </div>

</div>
        </form>
      </div>
    </div>      
  </div>    
</div>
<script type="text/javascript" src="https://js.stripe.com/v2/"></script>
<script type="text/javascript" src="http://162.215.253.89/ercabarter/dev/wp-content/plugins/investments/payment1.js"></script>
<script type="text/javascript">
  Stripe.setPublishableKey('pk_test_51JQdZZEAJtDMbuhoGvZkiYwfBlflB0FLbKke242tY9JwnUM5OeMkYxb7l2gzRgC9py98TvGFUZwtm35OpFNijpb500dUkZ5ACv');

add_shortcode('payment_process', 'payment_process');
   function payment_process(){
    ob_start();
    payment_process_code();
    return ob_get_clean();
   }

function payment_process_code() {

$paymentMessage = '';
if(!empty($_POST['stripeToken'])){
    
  // get token and user details
    $stripeToken  = $_POST['stripeToken'];
    $customerName = $_POST['customerName'];
    $customerEmail = $_POST['emailAddress'];
  
  $customerAddress = $_POST['customerAddress'];
  $customerCity = $_POST['customerCity'];
  $customerZipcode = $_POST['customerZipcode'];
  $customerState = $_POST['customerState'];
  $customerCountry = $_POST['customerCountry'];
  
    $cardNumber = $_POST['cardNumber'];
    $cardCVC = $_POST['cardCVC'];
    $cardExpMonth = $_POST['cardExpMonth'];
    $cardExpYear = $_POST['cardExpYear'];    
    
  //include Stripe PHP library
    require_once('stripe-php/init.php'); 
  
    //set stripe secret key and publishable key
    $stripe = array(
      "secret_key"      => "sk_test_51JQdZZEAJtDMbuhoDE3lmRJ1R69SsFjOhIUYHqH5BZwEB5yZU6Heaxjd8EL0w8i3Fjcfee6ePpswrQf00iMtaVoy00iUHL5S5M",
      "publishable_key" => "pk_test_51JQdZZEAJtDMbuhoGvZkiYwfBlflB0FLbKke242tY9JwnUM5OeMkYxb7l2gzRgC9py98TvGFUZwtm35OpFNijpb500dUkZ5ACv"
    );    
  
    \Stripe\Stripe::setApiKey($stripe['secret_key']);    
    
  //add customer to stripe
    $customer = \Stripe\Customer::create(array(
    'name' => $customerName,
    'description' => 'test description',
    'email' => $customerEmail,
    'source'  => $stripeToken,
    "address" => ["city" => $customerCity, "country" => $customerCountry, "line1" => $customerAddress, "line2" => "", "postal_code" => $customerZipcode, "state" => $customerState]
    ));  
  
    // item details for which payment made
  $itemName = $_POST['item_details'];
  $itemNumber = $_POST['item_number'];
  // $itemPrice = $_POST['price'];
  $rawAmount = $_POST['total_amount'];
  $totalAmount = $rawAmount*100;
  // $totalAmount = $_POST['total_amount'];
  $currency = $_POST['currency_code'];
  $orderNumber = $_POST['order_number'];   
    
    // details for which payment performed
    $payDetails = \Stripe\Charge::create(array(
        'customer' => $customer->id,
        'amount'   => $totalAmount,
        'currency' => $currency,
        'description' => $itemName,
        'metadata' => array(
        'order_id' => $orderNumber
        )
    ));   
  
    // get payment details
    $paymenyResponse = $payDetails->jsonSerialize();
  
    // check whether the payment is successful
    if($paymenyResponse['amount_refunded'] == 0 && empty($paymenyResponse['failure_code']) && $paymenyResponse['paid'] == 1 && $paymenyResponse['captured'] == 1){
        
        echo "<pre>";
        print_r($paymenyResponse);
        echo "<pre>";
    // transaction details 
        $payment_method = $paymenyResponse['payment_method'];
        $description = $paymenyResponse['description'];
        $order_id = $paymenyResponse['metadata']['order_id'];
        $amountPaid = $paymenyResponse['amount'];
        $balanceTransaction = $paymenyResponse['balance_transaction'];
        $paidCurrency = $paymenyResponse['currency'];
        $paymentStatus = $paymenyResponse['status'];
        $paymentDate = date("Y-m-d H:i:s");        
       
     //insert tansaction details into database
      global $wpdb;
      $current_user_id = get_current_user_id();
       $userdata = array(
          'cust_id'    => $current_user_id,
          'cust_name'    =>$customerName,
          'cust_email'     =>$customerEmail,
          'card_number'  =>$cardNumber,
          'card_cvc'  =>$cardCVC,
          'card_exp_month'  =>$cardExpMonth,
          'card_exp_year'    =>   $cardExpYear,
          'item_name'    =>   $itemName,
          'item_number'     =>   $itemNumber,
          'order_id'    =>   $order_id,
          'item_price_currency'     =>   $paidCurrency,
          'paid_amount'      =>   $amountPaid,
          'transaction_id'      =>   $balanceTransaction,
          'payment_status'  =>   $paymentStatus,
          'created_date'=> $paymentDate
        );

$successful_data = $wpdb->insert('transaction', $userdata);
       
       if ($successful_data) {
        update_user_meta( $current_user_id, 'cust_name', $customerName );
        update_user_meta( $current_user_id, 'customerAddress', $customerCity );
        update_user_meta( $current_user_id, 'customerCity', $customerCity );
        update_user_meta( $current_user_id, 'customerState', $customerState );
        update_user_meta( $current_user_id, 'customerCountry', $customerCountry );

$site_url = site_url()."/dashboard";
         wp_redirect($site_url);
       }else{
        $paymentMessage = "failed";
       }
    
    } else{
        $paymentMessage = "failed";
    }
} else{
    $paymentMessage = "failed";
}
$_SESSION["message"] = $paymentMessage;

}

add_shortcode('user_dashboard', 'user_dashboard');
   function user_dashboard(){
    ob_start();
    user_dashboard_show();
    return ob_get_clean();
   }

function user_dashboard_show() {

global $wpdb;
    $site_url = site_url()."/login";
    if ( ! is_user_logged_in() ) {
      wp_redirect($site_url);
    }
    $current_user_id = get_current_user_id();
    $user_meta=get_userdata($current_user_id);

if(isset($_GET['pid'])) {
        $pid = $_GET['pid'];
    }

$investment_data = $wpdb->get_results("SELECT * FROM `transaction` WHERE `cust_id` = '".$current_user_id."'");

$investment_sum_data = $wpdb->get_row("SELECT SUM(`paid_amount`) AS sum_investment FROM transaction WHERE `cust_id` = '".$current_user_id."'");
    $suminvestment = $investment_sum_data->sum_investment/100;
    $sum_investment_round = round($suminvestment);
    echo $sum_investment = number_format($sum_investment_round,2,".",",");
       echo "<br>";

$item_numbers = $wpdb->get_results("SELECT DISTINCT `item_number` AS item_number from transaction WHERE `cust_id` = '".$current_user_id."'");

foreach ($item_numbers as $item) {
   $pid = $item->item_number;

echo $product_name = get_field('title',$pid);
     echo "<br>";
    echo $min_investment = get_field('min_investment',$pid);
     echo "<br>";
    echo $price_per_share = get_field('price_per_share',$post->ID);
 echo "<br>";

$investmentdata = $wpdb->get_row("SELECT SUM(`paid_amount`) AS total_investment FROM transaction WHERE  `cust_id` = '".$current_user_id."' AND `item_number` = '".$pid."'");
    $totalinvestment = $investmentdata->total_investment/100;
    $totalinvestment_round = round($totalinvestment);
   echo $total_investment = number_format($totalinvestment_round,2,".",",");
echo "<br>";

}

[+] js
[-] portfolio.php-19-11-2021 [edit]
[+] stripe-php
[+] ..
[-] Investments.php-- [edit]
[-] portfolio.php [edit]
[-] Investments.php-29-10-2021 [edit]
[-] portfolio.php----subho-bk [edit]
[-] Investments.php--28-last-su [edit]
[+] vendor
[-] Investments.php-pay-27 [edit]
[-] Investments.php----an-29 [edit]
[-] Investments.php-28-10-2021 [edit]
[+] css
[-] portfolio.php-17-11-2021 [edit]
[-] portfolio.php--01 [edit]
[-] payment1.js-01-11-2021 [edit]
[-] Investments.php-01-11-2021 [edit]
[+] images
[-] portfolio.php-24-11-2021 [edit]
[-] payment1.js [edit]
[-] portfolio.php-18-11-2021 [edit]