Rate Card Calculator

[MrHinsh]

The rate calculator is based off my previous work in PHP to create this:

/**
 * Usage: [displayrate2021 location="remote|onsite" mode="public|direct|reseller|peer|cotrainer" scope="private|public" type="training|consulting"  hours='8' rate='200' ratemodifyer='none|Introductory|Beginner|Intermediate|Advanced' students='0' traveldays="1" coursewarecap="10", output="total|traineronly|courseware|students|trainer" percentage="0"]
 */

function calculateStudentGraduatedFee($studentsChargable, $rateStudentDay, $days) {
  $studentFee = 0;
  if ($studentsChargable > 0)
            {
             //echo "Students Chargeable: $studentsChargable <br />";  
              $baseStudentDayModifyer = 2;
              for ($si = 1; $si < $studentsChargable+1; $si++)
              {
                $baseStudentDayRate = ((($baseStudentDayModifyer*2) / 10)+1) * $rateStudentDay;
                //echo "Student[$si]:";  
                $studentFee = $studentFee + (($baseStudentDayRate) * $days);
                //echo "[$baseStudentDayModifyer]$studentFee"; 
                if ($si % 6 == 0) 
                {
                  $baseStudentDayModifyer++;
                  //echo "[increment]";
                }
                //echo "<br />"; 
              }
            }
  return $studentFee;
}

function calculateConsultingFees($mode, $baseRateDay, $baseDays, $traveldays) {
	$consultingTotal = 0;
    $consultingTotal=  $baseRateDay * ($baseDays + $traveldays);
    return $consultingTotal;
}


function calculateConsultingRoleModifier($role)
{
	$roleModifyer = 0;
	switch (strtolower($role))
	   {
			case "training":
				$roleModifyer = 3.125;
				break;
			case "strategic":
				$roleModifyer = 1.5625;
				break;
			case "leadership":
				$roleModifyer = 1.3333;
				break;
			case "tactical":
				$roleModifyer = 0.75;
				break;
			case "admin":
				$roleModifyer = 0.5;
				break;
		   	default:
			  	$roleModifyer = 1;
				break;
	   }
	return $roleModifyer;
}

function calculateConsultingLevelModifyer($level)
{
	$levelModifyer = 0;
	switch ($level) 
	   {
			case "1":
				$levelModifyer = 0.5;
				break;
			case "2":
				$levelModifyer = 0.7;
				break;
			case "3":
				$levelModifyer = 0.8;
				break;
			case "4":
				$levelModifyer =  0.9;
				break;
		   	case "5":
				$levelModifyer = 1;
				break;
		   	default:
			  	$levelModifyer = -1;
				break;
	   }
	return  $levelModifyer;
}

function consultingRates($params, $content = null) {
	// default parameters
	extract(shortcode_atts(array(
      	'currancySource' => get_option('woocommerce_currency'),
        'currancyTarget' => \get_woocommerce_currency(),
		'role' => "",
		'level' => "5",
      	'hours' => 8,
		'traveldays' => 0,
      	'ratemodifyer' => 'default',
      	'percentage' => 100,
      	'wrap' => 1,
      	'debug' => 0
	), $params));
	
	$debugData .= "[consultingRates currancySource=$currancySource currancyTarget=$currancyTarget role=$role level=$level hours=$hours traveldays=$traveldays ratemodifyer=$ratemodifyer ]" ;
	
	$debugData = "";
	$outTotal = 0;
	$baseRate = 275;
	$baseDays = ($hours /8);
	$baseRateDay =  $baseRate * 8;
	
	$debugData .= "[calculateConsultingRoleModifier role[$role] ";
	$roleModifyer = calculateConsultingRoleModifier($role);
	$debugData .= "roleModifyer[$roleModifyer] ] ";
	
	$debugData .= "[calculateConsultingLevelModifyer level[$level] ";
	$levelModifyer = calculateConsultingLevelModifyer($level);
	$debugData .= "levelModifyer[$levelModifyer] ] ";
	
	$debugData .= "[calculateConsultingFees baseRateDay[$baseRateDay] baseDays[$baseDays] traveldays[$traveldays] ";
	$outTotal = calculateConsultingFees("direct", $baseRateDay, $baseDays, $traveldays);
	$debugData .= "outTotal[$outTotal] ] ";
	
	$outTotal = $outTotal * $levelModifyer;
	$outTotal = $outTotal * $roleModifyer;
	$percentageAsDecimal = $percentage / 100;
  	$outTotal = $outTotal * $percentageAsDecimal;
	$debugData = $debugData . " outTotal[$outTotal] " ;
	return outputRateToHtml($outTotal, $wrap, $debug, $debugData); 
}

add_shortcode('consultingRates','consultingRates');


function displayrate2021($params, $content = null) {
	// default parameters
	extract(shortcode_atts(array(
      	'currancySource' => get_option('woocommerce_currency'),
        'currancyTarget' => \get_woocommerce_currency(),
        'scope' => 'private',
      	'mode' => 'direct',
		'delivery' => "immersive",
      	'hours' => 8,
      	'students' => 0,
      	'location' => 'remote',
      	'traveldays' => 0,
        'coursewarecap' => 10,
      	'rate' => 200,
      	'ratemodifyer' => 'default',
        'output' => 'total',
      	'percentage' => 100,
      	'wrap' => 1,
		'flag' => '',
      	'debug' => 0
	), $params));
 // 
//$fmt = new NumberFormatter( 'es_MX', NumberFormatter::CURRENCY );
//$fmt->setTextAttribute(NumberFormatter::CURRENCY_CODE, $currancyTarget);
//$fmt->setAttribute(NumberFormatter::FRACTION_DIGITS, 0);

  $baseRate = 210;//$rate; // GBP/hour
   $ratemodifyerlower = strtolower($ratemodifyer);
   switch (strtolower($ratemodifyerlower)) 
   {
     	case "advanced":
       	case "premium":
       	case "3":
       		$baseRate = $baseRate * 1.5;
        	break;
       	case "intermediate":
       case "expert":
       case "2":
       		$baseRate = $baseRate * 1.25;
        	break;
     case "introductory":
     case "0":
       		$baseRate = $baseRate * 0.75;
        	break;
       default:
          //do nothing
   }
	
	switch (strtolower($delivery))
	{
		case "immersive":
			if ($scope == "private")
			{
				$baseRate = $baseRate * 1.50;
			} else
			{
				$baseRate = $baseRate * 1;
			}			
        	break;
		case "traditional":
			if ($scope == "private")
			{
				$baseRate = $baseRate * 1.25;
			} else
			{
				$baseRate = $baseRate * 0.8;
			}			
        	break;
		default:
          //do nothing
	}
  
  
  $baseRateTraining = $baseRate * 2.5;
  $baseRateStudentDay = 125; // GBP/student/day
  $BaseRateCoursewareDay = 75; // GBP/student/day
  //echo "Courseware: $BaseRateCoursewareDay <br />";
  
  $baseRateResellerModifyer = 0.75;
  $baseRateTrainingResellerModifyer = 0.75;
  $baseRatePeerModifyer = 0.70;
  $baseRateTrainingPeerModifyer = 0.60;
  $baseRateCoTrainerModifyer = 0.40;
  $baseRateTrainingCoTrainerModifyer = 0.40;
  
  $baseDays = ($hours /8);
  $baseRateDay =  $baseRate * 8;
  $baseRateTrainingDay = $baseRateTraining * 8;
  
  $outTotal = 0;
	
	$additionalTrainerFee = 0;

    $trainingTotal = 0;
    $StudentExtra = 0;
    // Trainer Fee
    $trainerTotal =  $baseRateTrainingDay * $baseDays;
    if($location!=="remote")
    {
         $trainerTotal = $trainerTotal + ($baseRateTrainingDay * $traveldays);
    }
    // modifyer for Mode
    //echo "[mode:$mode][START][trainerTotal=$trainerTotal]<br />";
    switch (strtolower($mode)) 
    {
      case "direct":
        //do nothing
        break;
      case "public":
        $trainerTotal = (($baseRateTrainingDay /8) *  $baseDays) * 0.75; // This applies a 70% modifyer to the public market rate as it was too high.
        break;
      case "reseller":
        // discount for reselling
      $trainerTotal = $trainerTotal * $baseRateTrainingResellerModifyer;
        break;
      case "peer":
        $trainerTotal = $trainerTotal * $baseRateTrainingPeerModifyer;
        break;
      case "cotrainer":
        $trainerTotal = $trainerTotal * $baseRateTrainingCoTrainerModifyer;
        break;
      default:
        $trainerTotal = -1;
    }   
    //echo "[mode:$mode][END][trainerTotal=$trainerTotal]<br />";
    
    // Add per student fees
    $studentFee = 0;
    $coursewareTotal = 0;
	if ($students > 0)
    {
      // courseware fee
      $coursewareTotal = 0;
      if ($scope == "private" && $students > $coursewarecap)
      {
        $coursewareTotal = $coursewarecap * ($BaseRateCoursewareDay * $baseDays);
      }
      else
      {
        $coursewareTotal = $students * ($BaseRateCoursewareDay * $baseDays);
      }     
      
      //students
      $studentsChargable = 0;
      if ($students > 12)
      {
        $studentsChargable = ($students-12);
      }  
      
       // modifyer for Mode
        switch (strtolower($mode)) 
        {
          case "direct":
            // escelating student fee per 4
            $studentFee = calculateStudentGraduatedFee($studentsChargable,$baseRateStudentDay, $baseDays);
            break;
          case "reseller":
            // discount for reselling
            // simple all students at same rate
       		$studentFee = $studentsChargable * ($baseRateStudentDay * $baseDays) ;
            break;
          case "peer":
            // discount for reselling
            $studentFee = calculateStudentGraduatedFee($studentsChargable,$baseRateStudentDay, $baseDays)  * $baseRateTrainingPeerModifyer;
            break;
          case "cotrainer":
            $studentFee = calculateStudentGraduatedFee($studentsChargable,$baseRateStudentDay, $baseDays)  * $baseRateTrainingCoTrainerModifyer;
            break;
          default:
            $studentFee = -1;
        }   
      
         
        
      // Add second trainer
      $additionalTrainerFee = 0;
      if ($scope == "public" && $students > 20)
      {
        $additionalTrainerFee = ($baseRateDay * $baseDays);
      }    
    }

    switch (strtolower($output)) 
    {
      case "traineronly":
        $outTotal = $trainerTotal;
        break;
      case "courseware":
        $outTotal = $coursewareTotal;
        break;
      case "students":
        $outTotal = $studentFee;
        break;
      case "trainer":
        $outTotal = $additionalTrainerFee;
        break;
      default:
        $outTotal = $trainerTotal + $coursewareTotal + $studentFee + $additionalTrainerFee;
    }

  
  $percentageAsDecimal = $percentage / 100;
  $outTotal = $outTotal * $percentageAsDecimal;
  //$outTotal = $percentage;
  	$debugData = "currancySource[$currancySource] currancyTarget[$currancyTarget] flag[$flag] scope[$scope] mode[$mode] hours[$hours] students[$students] location[$location] traveldays[$traveldays] coursewarecap[$coursewarecap] rate[$rate] ratemodifyer[$ratemodifyer] output[$output] outTotal[$outTotal] " ;
	if ($flag == "raw" || $wrap == 0 )
	{
		return round($outTotal);
	}
  return outputRateToHtml($outTotal, $wrap, $debug, $debugData); 
}

function  outputRateToHtml($outTotal, $wrap, $debug, $debugData) {
	// currancy convertion and return
	//$outTotal = \WOOMC\API::convert($outTotal, $currancyTarget, $currancySource);
	//
	
	$flag = $_GET["flag"];
	//echo "Flag: " . $flag . "<br />";
	if ($flag == "raw" || $wrap == 0 )
	{
		return round($outTotal);
	}
	$outputData = "";
	if ($wrap >= 1)
	  {
		 $outTotal = do_shortcode( '[wcpbc_convert amount="' . $outTotal . '"]');
		//$outTotal = \wc_price($outTotal,array('currency' => $currancyTarget,'decimals' => null));
		if ($wrap >= 2)
		{
		  $outTotal = str_replace('<bdi>', '', $outTotal);
		  $outTotal = str_replace('</bdi>', '', $outTotal);
		}
	  }
	  if ($debug == 1)
	  {
		$outputData = "<span title='$debugData'>$outTotal</span>";
	  }
	  else
	  {
		$outputData = $outTotal;
	  }   
	return $outputData;
}


add_shortcode('displayrate2021','displayrate2021');

[MrHinsh]

GTP converts this to JS as:

// Helper function to calculate student fee
function calculateStudentGraduatedFee(studentsChargable, rateStudentDay, days) {
    let studentFee = 0;
    if (studentsChargable > 0) {
        let baseStudentDayModifier = 2;
        for (let si = 1; si <= studentsChargable; si++) {
            let baseStudentDayRate = (((baseStudentDayModifier * 2) / 10) + 1) * rateStudentDay;
            studentFee += baseStudentDayRate * days;
            if (si % 6 === 0) {
                baseStudentDayModifier++;
            }
        }
    }
    return studentFee;
}

// Helper function to calculate consulting fees
function calculateConsultingFees(baseRateDay, baseDays, traveldays) {
    return baseRateDay * (baseDays + traveldays);
}

// Helper function to calculate consulting role modifier
function calculateConsultingRoleModifier(role) {
    const roleModifiers = {
        training: 3.125,
        strategic: 1.5625,
        leadership: 1.3333,
        tactical: 0.75,
        admin: 0.5
    };
    return roleModifiers[role.toLowerCase()] || 1;
}

// Helper function to calculate consulting level modifier
function calculateConsultingLevelModifier(level) {
    const levelModifiers = {
        "1": 0.5,
        "2": 0.7,
        "3": 0.8,
        "4": 0.9,
        "5": 1
    };
    return levelModifiers[level] || -1;
}

// Main function to calculate consulting rates
function consultingRates(params) {
    const defaults = {
        currencySource: "USD", // default currency, replace with actual logic if needed
        currencyTarget: "USD", // replace with actual logic
        role: "",
        level: "5",
        hours: 8,
        traveldays: 0,
        ratemodifyer: "default",
        percentage: 100,
        wrap: 1,
        debug: 0
    };
    params = Object.assign(defaults, params);

    const baseRate = 275;
    const baseDays = params.hours / 8;
    const baseRateDay = baseRate * 8;

    let roleModifier = calculateConsultingRoleModifier(params.role);
    let levelModifier = calculateConsultingLevelModifier(params.level);

    let outTotal = calculateConsultingFees(baseRateDay, baseDays, params.traveldays);
    outTotal *= levelModifier;
    outTotal *= roleModifier;

    const percentageAsDecimal = params.percentage / 100;
    outTotal *= percentageAsDecimal;

    return outputRateToHtml(outTotal, params.wrap, params.debug, "");
}

// Main function to calculate display rate
function displayRate2021(params) {
    const defaults = {
        currencySource: "USD",
        currencyTarget: "USD",
        scope: "private",
        mode: "direct",
        delivery: "immersive",
        hours: 8,
        students: 0,
        location: "remote",
        traveldays: 0,
        coursewarecap: 10,
        rate: 200,
        ratemodifyer: "default",
        output: "total",
        percentage: 100,
        wrap: 1,
        flag: "",
        debug: 0
    };
    params = Object.assign(defaults, params);

    let baseRate = 210;
    let rateModifier = params.ratemodifyer.toLowerCase();

    switch (rateModifier) {
        case "advanced":
        case "premium":
        case "3":
            baseRate *= 1.5;
            break;
        case "intermediate":
        case "expert":
        case "2":
            baseRate *= 1.25;
            break;
        case "introductory":
        case "0":
            baseRate *= 0.75;
            break;
        default:
            break;
    }

    switch (params.delivery.toLowerCase()) {
        case "immersive":
            baseRate *= params.scope === "private" ? 1.5 : 1;
            break;
        case "traditional":
            baseRate *= params.scope === "private" ? 1.25 : 0.8;
            break;
        default:
            break;
    }

    const baseRateTraining = baseRate * 2.5;
    const baseRateStudentDay = 125;
    const BaseRateCoursewareDay = 75;

    const baseDays = params.hours / 8;
    const baseRateDay = baseRate * 8;
    const baseRateTrainingDay = baseRateTraining * 8;

    let trainerTotal = baseRateTrainingDay * baseDays;
    if (params.location !== "remote") {
        trainerTotal += baseRateTrainingDay * params.traveldays;
    }

    switch (params.mode.toLowerCase()) {
        case "public":
            trainerTotal *= 0.75;
            break;
        case "reseller":
            trainerTotal *= 0.75;
            break;
        case "peer":
            trainerTotal *= 0.7;
            break;
        case "cotrainer":
            trainerTotal *= 0.4;
            break;
        default:
            break;
    }

    let studentFee = 0;
    let coursewareTotal = 0;
    if (params.students > 0) {
        coursewareTotal = (params.students > params.coursewarecap ? params.coursewarecap : params.students) * (BaseRateCoursewareDay * baseDays);

        const studentsChargable = Math.max(0, params.students - 12);
        switch (params.mode.toLowerCase()) {
            case "direct":
                studentFee = calculateStudentGraduatedFee(studentsChargable, baseRateStudentDay, baseDays);
                break;
            case "reseller":
                studentFee = studentsChargable * (baseRateStudentDay * baseDays);
                break;
            case "peer":
                studentFee = calculateStudentGraduatedFee(studentsChargable, baseRateStudentDay, baseDays) * 0.7;
                break;
            case "cotrainer":
                studentFee = calculateStudentGraduatedFee(studentsChargable, baseRateStudentDay, baseDays) * 0.4;
                break;
            default:
                break;
        }
    }

    let additionalTrainerFee = 0;
    if (params.scope === "public" && params.students > 20) {
        additionalTrainerFee = baseRateDay * baseDays;
    }

    let outTotal = 0;
    switch (params.output.toLowerCase()) {
        case "traineronly":
            outTotal = trainerTotal;
            break;
        case "courseware":
            outTotal = coursewareTotal;
            break;
        case "students":
            outTotal = studentFee;
            break;
        case "trainer":
            outTotal = additionalTrainerFee;
            break;
        default:
            outTotal = trainerTotal + coursewareTotal + studentFee + additionalTrainerFee;
            break;
    }

    outTotal *= params.percentage / 100;

    return outputRateToHtml(outTotal, params.wrap, params.debug, "");
}

// Helper function to output the final rate in HTML
function outputRateToHtml(outTotal, wrap, debug, debugData) {
    if (wrap === 0) {
        return Math.round(outTotal);
    }

    let outputData = outTotal;
    if (wrap >= 2) {
        outputData = String(outputData).replace(/<bdi>/g, "").replace(/<\/bdi>/g, "");
    }

    return debug === 1 ? `<span title='${debugData}'>${outputData}</span>` : outputData;
}