PHP - Apply Different Tax Rate Based On Customer Roles

While I am impressed with much of Symfony, the needing to know everything the "symfony way" is a little annoying.  For an application, I will have several types of users:

To expose the data, I am using api-platform.  Currently, I am just trying to create endpoints to retrieve a list of vendors, normal users, etc.

One possible solution I know how to accomplish but don't believe is the correct way is to create an AbstractUser and create VendorUser, NormalUser, etc which extend AbstractUser.  Doing so will create routes for each of these user types and meet my immediate needs.

Alternatively, I can create only a single User entity, and then assign roles such as ROLE_ADMIN, ROLE_VENDOR, ROLE_USER, or ROLE_SUPER.  Ideally, I could then add new routes such as /vendors instead of making it /users?type=vendor.

Or maybe I should be doing something totally different.

If I was building this from scratch, I can definitely figure something out, however, would like to take advantage of symfony and do it their way.  But I am a complete newbie when it comes to symfony, and don't even know where to start, and would appreciate a strategy to go which won't lead me down to bad of wrong path.

I use the Wholesale Suite Premium Prices plugin with WooCommerce. I have 6 specific wholesale roles out of 15 that I wish to hide two specific shipping methods from being selected for the 6 exceptions. I'm just trying this on my staging server at this time using a code snippet example that I found and modified for my specific conditions. Would the following work for this purpose?

/* Hide specific shipping methods for specific wholesale roles */
add_filter( 'woocommerce_package_rates', function( $shipping_rates ) {
// User role and shipping method ID to hide for the user role
    $role_shipping_method_arr = array(
    'ws_silvia_silver' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    );

    // Getting the current user role
    $curr_user = wp_get_current_user(); 
    $curr_user_data = get_userdata($current_user->ID); 

    // Wholesale Suite Roles 
    if (isset($current_user) && class_exists('WWP_Wholesale_Roles')) {
        $wwp_wholesale_roles = WWP_Wholesale_Roles::getInstance();
        $wwp_wholesale_role = $wwp_wholesale_roles->getUserWholesaleRole(); 

// Loop through the user role and shipping method pair
    foreach( $role_shipping_method_arr as $role => $shipping_methods_to_hide ) {

// Check if defined role exist in current user role or not
    if( in_array( $role, $current_user->roles) ) {

// Loop through all the shipping rates
    foreach( $shipping_rates as $shipping_method_key => $shipping_method ) {
$shipping_id = $shipping_method->get_id();

// Unset the shipping method if found
    if( in_array( $shipping_id, $shipping_methods_to_hide) ) {
unset($shipping_rates[$shipping_method_key]);
}
}
}
}
}
    return $shipping_rates;
});

Any insights as to how to accomplish this would be greatly appreciated. Lyse

Php Folks,

I started learning php originally from 2015. On & off. Part time.

Started getting into it seriously around 2017. From home. No classes. From forums and php manual and tutorial sites.

Still at oop & mysqli. Had ups & downs as first learnt a lot of old stuffs then found out they been deprecated. For example, if I had originally known pdo is modern over mysqli then I would started on pdo from beginning. Got no real guidance anywhere. Just learnt things the hard way, coming across obstacles and bugging forums. Half-way learning mysqli I come across pdo. So you see, if I had taken school classes then they would have started me on the new stuffs. But because I learning from home, I came across a lot of old tutorials and started from there without knowing they are sort of outdated stuffs. Anyway, I don't like quitting half-way and so did not quit mysqli for pdo when a lot of programmers advised me to dump mysqli for pdo. Thought,  since I "wasted time" on mysqli then might aswell build a few sites with it before ditching it.

Part time study. Full time working on projects for 3yrs now. projects are own "hobby sites" so to speak and not for clients. I am not the freelancer type or professional type. layman type. Never really have launched any sites. I finish one site/project then move onto another project for learning purpose. So I learn very little then moving onto building sites based on what little I learnt.

When I learnt how to use the SELECT, INSERT. DELETE, UPDATE in sql, I jumped into learning to build my own membership site (reg, log-in, logout, etc. pages) to deal with mysql db.

So far, built membership parts (login, logout, account homepage, pagination). All by copying codes from tutorials and forums from people like you and changing here and there according to my needs. And when I get stuck. I bug programmers like you. I do have a conscious and do not like plagiarism even while learning and so everytime I copy paste codes from tutorials or forums (where I get help), I retype every line and then delete the copy-pasted lines and leave my typed lines in the file. that way, I feel good I atleast made some effort to build the site rather than copy & paste. Then, I change the codes here and there to suit my purpose.

Don't you like me ? ;). You probably chuckling inside reading this.

Here's an example of how I copy-paste then re-write the lines.

	<?php
//Code from: https://www.w3schools.com/howto/tryit.asp?filename=tryhow_css_login_form
?>
	<!DOCTYPE html>
<!DOCTYPE html>
<html>
<html>
<head>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
<style>
body {font-family: Arial, Helvetica, sans-serif;}
body {font-family: Arial, Helvetica, sans-serif;}
form {border: 3px solid #f1f1f1;}
form {border: 3px solid #f1f1f1;}
	input[type=text], input[type=password] {
input[type=text], input[type=password] {
  width: 100%;
  width: 100%;
  padding: 12px 20px;
  padding: 12px 20px;
  margin: 8px 0;
  margin: 8px 0;
  display: inline-block;
  display: inline-block;
  border: 1px solid #ccc;
  border: 1px solid #ccc;
  box-sizing: border-box;
  box-sizing: border-box;
}
}
	button {
button {
  background-color: #4CAF50;
  background-color: #4CAF50;
  color: white;
  color: white;
  padding: 14px 20px;
  padding: 14px 20px;
  margin: 8px 0;
  margin: 8px 0;
  border: none;
  border: none;
  cursor: pointer;
  cursor: pointer;
  width: 100%;
  width: 100%;
}
}
	button:hover {
button:hover {
  opacity: 0.8;
  opacity: 0.8;
}
}
	.cancelbtn {
.cancelbtn {
  width: auto;
  width: auto;
  padding: 10px 18px;
  padding: 10px 18px;  
  background-color: #f44336;
  background-color: #f44336;
}
}
	.imgcontainer {
.imgcontainer {
  text-align: center;
  text-align: center;
  margin: 24px 0 12px 0;
  margin: 24px 0 12px 0;
}
}
	img.avatar {
img.avatar {
  width: 40%;
  width: 40%;
  border-radius: 50%;
  border-radius: 50%;
}
}
	.container {
.container {
  padding: 16px;
  padding: 16px;
}
}
	span.psw {
span.psw {
  float: right;
  float: right;
  padding-top: 16px;
  padding-top; 16px;
}
}
	/* Change styles for span and cancel button on extra small screens */
/* Change styles for span and cancel button on extra small screens */
@media screen and (max-width: 300px) {
@media screen and (max-width: 300px) {
  span.psw {
  span.psw {
     display: block;
     display: block;
     float: none;
     float: none;
  }
  }
  .cancelbtn {
  .cancelbtn {
     width: 100%;
     width: 100%;
  }
  }
}
}
</style>
</style>
</head>
</head>
<body>
<body>
	<h2>Login Form</h2>
<h2>Login Form</h2>
	<form action="/action_page.php" method="post">
<form action="/action_page.php" method="post">
  <div class="imgcontainer">
  <div class="imgcontainer">
    <img src="img_avatar2.png" alt="Avatar" class="avatar">
    <img src="img_avatar2.png" alt="Avatar" class="avatar">
  </div>
  </div>
	  <div class="container">
  <div class="container">
    <label for="uname"><b>Username</b></label>
    <label for="uname"><b>Username</b></label>
    <input type="text" placeholder="Enter Username" name="uname" required>
    <input type="text" placeholder="Enter Username" name="uname" required>
    <label for="psw"><b>Password</b></label>
    <label for="psw"><b>Password</b></label>
    <input type="password" placeholder="Enter Password" name="psw" required>
    <input type="password" placeholder="Enter Password" name="psw" required>    
    <button type="submit">Login</button>
    <button type="submit">Login</button>
    <label>
    <label>
      <input type="checkbox" checked="checked" name="remember"> Remember me
      <input type="checkbox" checked="checked" name="remember"> Remember me
    </label>
    </label>
  </div>
  </div>
	  <div class="container" style="background-color:#f1f1f1">
  <div class="container" style="background-color:#f1f1f1">
    <button type="button" class="cancelbtn">Cancel</button>
    <button type="submit" class="cancelbtn">Cancel</button>
    <span class="psw">Forgot <a href="#">password?</a></span>
    <span class="psw">Forgot <a href="#">password?</a></span>
  </div>
  </div>
</form>
</form>
	</body>
</body>
</html>
</html>
	

One thing I gain from this type of re-writings is that, typing the same thing over and over again sort of gets codes sink into my subconscious. Helps to memorise the codes.

Ok. So now you know a little about me.

As you can see, I always start on somebody else's skeleton, be it from a tutorial forum or a tutorial site or php manual.

I have completed 3 websites, so to speak, in that way. 2 days ago I thought, I been doing this for 3yrs now. Let's test and see how well I can code without working on somebody else's skeleton. No copy-pasting from forums or tutorial sites or php manual.

And so, look what I did. I coded all the following from my own memory. let me know how well I did. That repetition of lines re-writing has done me some good to memorise codes.

I did make 2 mistakes. Note the comments in the code. You will notice "MY CODE ..." and then a correction "WHAT IT SHOULD BE ...". Compare the 2 and see how close or far away I was from the correction. And then give me score from 1-10 (where 10 is best) how well I did as a home study middle aged guy. Hard learning things at middle age. I think, if I had toild you I started learning a month ago then you'd give 9/10 but because it's been 3 yrs, you'll give 1/9 or 0. Just bear in mind it's not easy to learn things at middle age and remember them without forgetting. I learn fast but forget double fast. Lol!

One thing though. My codes are not working. They do not INSERT data into db nor extract & display data from db. What is wrong ?

TEST NUMBER 1:

On this one, I first tried displaying data rows from mysql using mysqli_stmt_get_result(). That failed and so I tried with mysqli_stmt_bind_result() afterwards and so bear that in mind and don't ask me why I used both instead of one.

Clicking the "search" button gives no response. Nothing happens on page. I did search for a ketywords that exist in each mysql tbl columns.

	<?php
include('error_reporting.php');
require('conn.php');
//require('search_form.php');
?>
	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<label for="search_column">Search in ... ?</label>
<select name="search_column" id="search_column">
<option value="page_url">Page Url</option>
<option value="link_anchor_text">Link Anchor Text</option>
<option value="page_description">Page Description</option>
<option value="keyphrase">Keyphrase</option>
<option value="keywords">Keywords</option>
</select>
<br>
<label for="tos_agreement">Agree to TOS or not ? *</label>
<select name="tos_agreement" id="tos_agreement" required>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['search_links']))
    {
        $_POST['page_url'];
        $_POST['link_anchor_text'];
        $_POST['page_description'];
        $_POST['keyphrase'];
        $_POST['keywords'];
        
        //I WROTE 2 QUERIES HERE AS I WASN'T SURE HOW IT SHOULD BE. FINALLY, STUCK TO THE LATTER. HOWEVER, ON TESTS NONE OF THEM WORK!
        //QUERY 1. $query = "SELECT FROM links (page_url,link_anchor_text,page_description,keyphrases,keywords) WHERE keywords = ?";
        //QUERY 2...
        $query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE page_url = ?, link_anchor_text = ?, page_description = ?, keyphrases = ?, keywords = ?";
	        $stmt = mysqli_stmt_init($conn);
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'sssss',$_POST['page_url'],$_POST['link_anchor_text'],$_POST['page_description'],$_POST['keyphrase'],$_POST['keywords']);
            
            //WRONG: FORGOT TO ADD "$result = " ...
            //mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            
            //CORRECTION: WHAT IT SHOULD BE ...
            $result = mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            //mysqli_stmt_execute($stmt);WRONG! THIS LINE SHOULDN'T EXIST UNLESS IT'S mysqli_stmt_get_result().
            
            mysqli_stmt_fetch($stmt);
            
            //WASN'T SURE WHICH OF THE 3 FOLLOWING LINES ARE CORRECT REGARDING THE WHILE LOOP. FINALLY, STUCK TO THE 1ST LINE ...
            //1)...
            while(mysqli_stmt_fetch($stmt))
            //2)...
            //while(mysqli_fetch_array($stmt,mysqli_assoc))
            //3)...
            //while(mysqli_fetch($stmt))
            {
                echo "url"; echo "<br>";
                echo "anchor_text"; echo "<br>";
                echo "description"; echo "<br>";
                echo "keyphrases"; echo "<br>";
                echo "keywords"; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);//CORRECTION: THIS SHOULD BE OUTSIDE THE "WHILE LOOP"
            mysqli_close($conn);//CORRECTION: THIS SHOULD BE OUTSIDE "IF"
        }
        else
        {
            echo "1. QUERY failed!";
        }
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'sssss',$_POST['page_url'],$_POST['link_anchor_text'],$_POST['page_description'],$_POST['keyphrases'],$_POST['keywords']);
            mysqli_stmt_execute($stmt);
            
            //CORRECTION: FORGOT TO ADD "$result = "
            $result = mysqli_stmt_get_result($stmt);
            
            /* MY CODE
            WRONG! TRIED ECGHOING THE ARRAY "$row[]"!
            while($row = mysqli_fetch_array($result,mysqli_assoc))
            {
                echo $row['page_url']; echo "<br>";
                echo $row['link_anchor_text']; echo "<br>";
                echo $row['page_description']; echo "<br>";
                echo $row['keyphrases']; echo "<br>";
                echo $row['keywords']; echo "<br>";
                echo "|";
                echo "<br>";
            }
            */
            //CORRECTION: HOW IT SHOULD BE:
            //$VARIABLE SHOULD BE ECHOED. NOT THE ARRAY $row[]
            while($row = mysqli_fetch_array($result,mysqli_assoc))
            {
                $page_url = $row['page_url']; echo $page_url; echo "<br>";
                $link_anchor_text = $row['link_anchor_text']; echo $link_anchor_text; echo "<br>";
                $page_description = $row['page_description']; echo $page_description; echo "<br>";
                $keyphrases = $row['keyphrases']; echo $keyphrases; echo "<br>";
                $keywords = $row['keywords']; echo $keywords; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("2. QUERY failed!");
        }
    }
}
	
?>
	

TEST NUMBER 2:

On this one, clicking the "submit links" button gives no response atall!.

	<?php
include('error_reporting.php');
require('conn.php');
//equire('link_submission_form.php');
?>
	<form name = "submit_link" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="domain">Domain:</label>
<input type="text" name="domain" id="domain" placeholder="Input Domain">
<br>
<label for="domain_email">Domain Email:</label>
<input type="email" name="domain_email" id="domain_email" placeholder="Input Domain Email">
<br>
<label for="url">Url:</label>
<input type="url" name="url" id="url" placeholder="Input Url">
<br>
<label for="link_anchor_text">Link Anchor Text:</label>
<input type="text" name="link_anchor_text" id="link_anchor_text" placeholder="Input Link Anchor Text">
<br>
<textarea rows="10" cols="20">Page Description</textarea>
<br>
<label for="keywords">Keywords:</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords related to Page">
<br>
<label for="tos_agreement">Agree to TOS or not ?</label>
<select name="tos_agreement" id="tos_agreement">
<option value="yes">Yes</option>
<option value="no">No</option>
</select>
<br>
<input type="button" name="submit_link" id="submit_link" value="Submit Link!">
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['submit_link']))
    {
        $query = "INSERT into links (domain,domain_email,url,link_anchor_text,page_description,keywords) VALUES ?,?,?,?,?,?";
	        $stmt = mysqli_stmt_init($conn);
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'ssssss',$_POST['domain'],$_POST['domain_email'],$_POST['url'],$_POST['link_anchor_text'],$_POST['page_description'],$_POST['keywords']);
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("INSERT failed!");
        }
    }
}
	
?>
	

What is wrong ? Why both codes don't work ?

function wsProcessClientMessage($clientID, $opcode, &$data, $dataLength) {
global $wsClients;
 
// check opcodes
if ($opcode == WS_OPCODE_PING) {
// received ping message
return wsSendClientMessage($clientID, WS_OPCODE_PONG, $data);
}
elseif ($opcode == WS_OPCODE_PONG) {
// received pong message (it's valid if the server did not send a ping request for this pong message)
if ($wsClients[$clientID][4] !== false) {
$wsClients[$clientID][4] = false;
}
}
elseif ($opcode == WS_OPCODE_CLOSE) {
// received close message
if (substr($data, 1, 1) !== false) {
$array = unpack('na', substr($data, 0, 2));
$status = $array['a'];
}
else {
$status = false;
}
 
if ($wsClients[$clientID][2] == WS_READY_STATE_CLOSING) {
// the server already sent a close frame to the client, this is the client's close frame reply
// (no need to send another close frame to the client)
$wsClients[$clientID][2] = WS_READY_STATE_CLOSED;
}
else {
// the server has not already sent a close frame to the client, send one now
wsSendClientClose($clientID, WS_STATUS_NORMAL_CLOSE);
}
 
wsRemoveClient($clientID);
}
elseif ($opcode == WS_OPCODE_TEXT || $opcode == WS_OPCODE_BINARY) {
// received text or binary message
if (function_exists('wsOnMessage')) wsOnMessage($clientID, $data, $dataLength, $opcode == WS_OPCODE_BINARY);
}
else {
// unknown opcode
return false;
}
 
return true;
}