wc_status(); if(self::$wc_status !== 1){ self::$slug=$this->get_slug(); add_action( 'admin_notices', array( $this, 'install_wc_notice' ) ); add_action( 'after_plugin_row_'.self::$slug, array( $this, 'install_wc_notice_plugin_row' ) ); return; } require_once(self::$path . "includes/plugin-pages.php"); require_once(self::$path . "includes/crmperks-wc.php"); $notice_file=self::$path . "wp/crmperks-notices.php"; if(file_exists($notice_file)){ include_once($notice_file); }else{ $this->plugin_api(true); $file=self::$path . "pro/add-ons.php"; if(file_exists($file)){ include_once($file); } self::$is_pr=true; } } public function setup_main(){ // hook into woocommerce order status changed hook to handle the desired subscription event trigger add_action( 'woocommerce_order_status_changed',array($this,'status_changed'), 10, 3 ); add_action( 'woocommerce_subscription_status_updated',array($this,'status_changed_subscription'), 10, 3 ); add_action( 'woocommerce_checkout_update_order_meta',array($this,'order_submit'), 20 ); add_action( 'woocommerce_new_order',array($this,'order_submit_new'),10,2 ); //order_id add_action( 'profile_update',array($this,'profile_update'), 999 ); add_action('save_post_product',array($this,'save_product'),999,2); self::$path=$this->get_base_path(); $sync_file=self::$path . "pro/sync-cron.php"; if( file_exists($sync_file) ){ require_once( $sync_file ); } if(is_admin()){ add_action('init', array($this,'init')); //loading translations load_plugin_textdomain('wp-woocommerce-quickbooks', FALSE, $this->plugin_dir_name() . '/languages/' ); self::$db_version=get_option($this->type."_version"); if( self::$db_version != $this->version && current_user_can( 'manage_options' )){ $this->install_plugin(); } } add_action( 'before_woocommerce_init', function() { if ( class_exists( '\Automattic\WooCommerce\Utilities\FeaturesUtil' ) ) { \Automattic\WooCommerce\Utilities\FeaturesUtil::declare_compatibility( 'custom_order_tables', __FILE__, true ); } } ); } public function plugin_api($start_instance=false){ if(empty(self::$path)){ self::$path=$this->get_base_path(); } $api_file=self::$path . "pro/plugin-api.php"; if(!class_exists('vxcf_plugin_api') && file_exists($api_file)){ include_once($api_file); } if(class_exists('vxcf_plugin_api')){ $slug=$this->get_slug(); $settings_link=$this->link_to_settings(); $is_plugin_page=$this->is_crm_page(); self::$plugin=new vxcf_plugin_api($this->id,$this->version,$this->type,$this->domain,$this->update_id,self::$title,$slug,self::$path,$settings_link,$is_plugin_page); if($start_instance){ self::$plugin->instance(); } } } public function install_plugin(){ self::$path=$this->get_base_path(); include_once(self::$path . "includes/install.php"); $class=$this->id.'_install'; $install=new $class(); $install->create_tables(); $install->create_roles(); update_option($this->type."_version", $this->version); } /** * Woocommerce status * */ public function wc_status() { $installed = 0; if(!class_exists('WooCommerce')) { if(file_exists(WP_PLUGIN_DIR.'/woocommerce/woocommerce.php')) { $installed=2; } }else{ $installed=1; if(!version_compare(WOOCOMMERCE_VERSION, $this->min_wc_version, ">=")){ $installed=3; } } if($installed !=1){ if($installed === 0){ // not found $message = sprintf(__("%sWooCommerce%s is required. %sDownload latest version!%s", 'wp-woocommerce-quickbooks'), "", "", "", ""); }else if($installed === 2){ // not active $message = sprintf(__('WooCommerce is installed but not active. %sActivate WooCommerce%s to use the WooCommerce QuickBooks Plugin','wp-woocommerce-quickbooks'), '', ''); } else if($installed === 3){ // not supported $message = sprintf(__("A higher version of %sWooCommerce%s is required. %sDownload latest version!%s", 'wp-woocommerce-quickbooks'), "", "", "", ""); } self::$wc_status_msg=$message; } return $installed; } /** * Install Woocommerec Notice * */ public function install_wc_notice(){ $message=self::$wc_status_msg; if(!empty($message)){ $this->display_msg('admin',$message,'woocommerce'); $this->notice_js=true; } } /** * Install Woocommerec Notice (plugin row) * */ public function install_wc_notice_plugin_row(){ $message=self::$wc_status_msg; if(!empty($message)){ $this->display_msg('',$message,'woocommerce'); } } /** * web2lead fields * * @param mixed $module * @param mixed $map */ public function web_fields($module,$map){ //////////////////////////// $web['Lead']='{"1":{"label":"First Name","max":"40","name":"first_name","type":"text"},"2":{"label":"Last Name","max":"80","name":"last_name","type":"text","req":"true"},"3":{"label":"Email","max":"80","name":"email","type":"text","req":"true"},"4":{"label":"Company","max":"40","name":"company","type":"text"},"5":{"label":"City","max":"40","name":"city","type":"text"},"6":{"label":"State/Province","max":"20","name":"state","type":"text"},"7":{"label":"Salutation","name":"salutation","type":"select"},"8":{"label":"Title","max":"40","name":"title","type":"text"},"9":{"label":"Website","max":"80","name":"URL","type":"text"},"10":{"label":"Phone","max":"40","name":"phone","type":"text"},"11":{"label":"Mobile","max":"40","name":"mobile","type":"text"},"12":{"label":"Fax","max":"40","name":"fax","type":"text"},"13":{"label":"Address","name":"street","type":"select"},"14":{"label":"Zip","max":"20","name":"zip","type":"text"},"15":{"label":"Country","max":"40","name":"country","type":"text"},"16":{"label":"Description","name":"description","type":"select"},"17":{"label":"Lead Source","name":"lead_source","type":"select"},"18":{"label":"Industry","name":"industry","type":"select"},"19":{"label":"Rating","name":"rating","type":"select"},"20":{"label":"Annual Revenue","name":"revenue","type":"text"},"21":{"label":"Employees","name":"employees","type":"text"},"22":{"label":"Email Opt Out","name":"emailOptOut","type":"checkbox"},"23":{"label":"Fax Opt Out","name":"faxOptOut","type":"checkbox"},"24":{"label":"Do Not Call","name":"doNotCall","type":"checkbox"}}'; $web['Case']='{"1":{"label":"Contact Name","max":"80","name":"name","type":"text"},"2":{"label":"Email","max":"80","name":"email","type":"text"},"3":{"label":"Phone","max":"40","name":"phone","type":"text"},"4":{"label":"Subject","max":"80","name":"subject","type":"text"},"5":{"label":"Description","name":"description","type":"select"},"6":{"label":"Company","max":"80","name":"company","type":"text"},"7":{"label":"Type","name":"type","type":"select"},"8":{"label":"Status","name":"status","type":"select"},"9":{"label":"Case Reason","name":"reason","type":"select"},"10":{"label":"Priority","name":"priority","type":"select"}}'; ////////////////// if(isset($web[$module])){ $fields_arr=json_decode($web[$module],true); $fields=array(); $phone=array('phone','mobile','fax'); foreach($fields_arr as $k=>$v){ if(self::$is_pr === false && in_array($v['name'],$phone)){ continue; } $fields[$v['name']]=$v; } foreach($map as $k=>$v){ if(isset($v['name_c'])) $fields[$k]=$v; } } return $fields; } /** * check custom filters * * @param mixed $feed * @param mixed $order */ public function check_filter($feed){ $filters=$this->post('filters',$feed); $final=$this->filter_condition=null; if(is_array($filters)){ $time=current_time('timestamp'); foreach($filters as $filter_s){ $check=null; $and=null; $and_c=array(); if(is_array($filter_s)){ foreach($filter_s as $filter){ $field=$filter['field']; $fval=$filter['value']; $val=$this->get_field_val($filter); //make case insensitive $val=strtolower($val); $fval=strtolower($fval); // $country_fields=array("billing_country","shipping_country","country"); if(in_array($field,$country_fields)){ $countries=WC()->countries->countries; if(in_array($filter['op'],array("is","is_not"))){ if(strlen($field)>2){ $fval=ucwords($fval); if(is_array($countries)){ foreach($countries as $c_code=>$c_name){ if(preg_match('/'.$fval.'/i',$c_name)){ $fval=$c_code; break; } } } }else{ $fval=strtoupper($fval); } }else{ //convert both to lowercase full country names $val=isset($countries[$val]) ? strtolower($countries[$val]) : ""; } } switch($filter['op']){ case"is": $check=$fval == $val;break; case"is_not": $check=$fval != $val; break; case"contains": $check=strpos($val,$fval) !==false; break; case"not_contains": $check=strpos($val,$fval) ===false; break; case"is_in": $check=strpos($fval,$val) !==false; break; case"not_in": $check=strpos($fval,$val) ===false; break; case"starts": $check=strpos($val,$fval) === 0; break; case"not_starts": $check=strpos($val,$fval) !== 0; break; case"ends": $check=(strpos($val,$fval)+strlen($fval)) == strlen($val); break; case"not_ends": $check=(strpos($val,$fval)+strlen($fval)) != strlen($val); break; case"less": $check=(float)$val<(float)$fval; break; case"greater": $check=(float)$val>(float)$fval; break; case"less_date": $check=strtotime($val,$time) < strtotime($fval,$time); break; case"greater_date": $check=strtotime($val,$time) > strtotime($fval,$time); break; case"equal_date": $check=strtotime($val,$time) == strtotime($fval,$time); break; case"empty": $check=$val == ""; break; case"not_empty": $check=$val != ""; break; } $and_c[]=array("check"=>$check,"field_val"=>$fval,"input"=>$val,"field"=>$field,"op"=>$filter['op']); if($check !== null){ if($and !== null){ $and=$and && $check; }else{ $and=$check; } } } //end and loop filter } if($and !== null){ if($final !== null){ $final=$final || $and; }else{ $final=$and; } } $this->filter_condition[]=$and_c; } // end or loop } return $final === null ? true : $final; } public function status_changed_subscription($sub,$status,$old){ $this->push($sub,'vxswc-'.$status); } /** * On status change send order to Zoho * * @param mixed $id * @param mixed $old_status * @param mixed $new_status */ public function status_changed($id,$old_status,$new_status){ // if(in_array($new_status,array("processing","completed")) ){ $this->push($id,$new_status); // } } /** * Send order to Zoho when user submits the order * * @param mixed $id * @param mixed $posted */ public function profile_update($user_id){ $res=$this->push($user_id,'save_user'); } public function save_product($post_id,$post){ if(isset($post->post_status) && $post->post_status == 'publish' && !defined( 'DOING_CRON' ) ){ //do not run with cron becuase our pluin's sync cron creates new zoho product in woo , which is again sent to zoho $res=$this->push($post_id,'save_product'); } } public function order_submit($id){ $status="submit"; // $status="user_created"; $this->push($id,$status); } public function order_submit_new($id,$order){ if($this->do_actions()){ do_action('vx_addons_save_entry',$id,'','wc',''); } } /** * Check settings * if settings are not complete then ask user to complete settings first * */ public function verify_settings_msg($info=""){ $link=$this->link_to_settings(); return "
".sprintf(__("Please Configure %sQuickBooks Settings%s",'wp-woocommerce-quickbooks'),"","")."
"; } /** * Get CRM info * */ public function get_info($id){ global $wpdb; $id=(int)$id; $table= $this->get_table_name('accounts'); $info = $wpdb->get_row( 'SELECT * FROM '.$table.' where id='.$id.' limit 1',ARRAY_A ); $info_arr=array(); $data=array(); $meta=array(); if(is_array($info)){ if(!empty($info['data'])){ $info['data']=trim($info['data']); if(strpos($info['data'],'{') !== 0){ $info['data']=$this->de_crypt($info['data']); } $info_arr=json_decode($info['data'],true); if(!is_array($info_arr)){ $info_arr=array(); } } $info_arr['time']=$info['time']; $info_arr['id']=$info['id']; $info['data']=$info_arr; if(!empty($info['meta'])){ $meta=json_decode($info['meta'],true); } $info['meta']=is_array($meta) ? $meta : array(); } return $info; } /** * display plugins row or admin notice * * @param mixed $type * @param mixed $message * @param mixed $id */ public function display_msg($type,$message,$id=""){ //exp global $wp_version; $ver=floatval($wp_version); if($type == "admin"){ if($ver<4.2){ ?>

. dismiss

.

'.$info['info_title'].''."\n"; } if(is_array($info['info']) && count($info['info'])>0){ $str.=''; foreach($info['info'] as $f_k=>$f_val){ $str.=''."\n"; } $str.="
'.$f_k.''.$f_val.'
"; } }else{ if(isset($info['title'])) $str.="\n".$info['title']."\n"; foreach($info['info'] as $f_k=>$f_val){ $str.=$f_k." : ".$f_val."\n"; } } } if($is_html){ $str=str_replace(array("{title}","{msg}","{sf_contents}"),array($info['title'],$info['msg'],$str),$file); } return $str; } /** * deactivate * * @param mixed $action */ public function deactivate($action="deactivate"){ // do_action('plugin_status_'.$this->type,$action); } /** * activate plugin * */ public function activate(){ $this->plugin_api(true); $this->install_plugin(); do_action('plugin_status_'.$this->type,'activate'); } public function do_actions(){ if(!is_object(self::$plugin) ){ $this->plugin_api(); } if(is_object(self::$plugin) && method_exists(self::$plugin,'valid_addons')){ return self::$plugin->valid_addons(); } return false; } /** * Insert Log * * @param mixed $arr */ public function __log($arr,$log_id=""){ global $wpdb; if(!is_array($arr) || count($arr) == 0) return; ///$wpdb->show_errors(); $table_name = $this->get_table_name(); $sql_arr=array(); foreach($arr as $k=>$v){ $sql_arr[$k]=is_array($v) ? json_encode($v) : $v; } $log_id=(int)$log_id; $res=false; if(!empty($log_id)){ // update $res=$wpdb->update($table_name,$sql_arr,array("id"=>$log_id)); }else{ $res=$wpdb->insert($table_name,$sql_arr); $log_id=$wpdb->insert_id; } return $log_id; } /** * Tooltip image * * @param mixed $str */ public function tooltip($str){ if($str == ""){return;} ?> id.'_msg' => 'true' ), $location ); } /** * Returns true if the current page is an Feed pages. Returns false if not * * @param mixed $page */ public function is_crm_page($plugin_page=""){ $page=''; if(isset($_GET['tab'])){ $page=$this->post('tab'); }else if(isset($_GET['page'])){ $page=$this->post('page'); } if(!empty($plugin_page)){ if($page == $plugin_page){ return true; }else{ return false; } } $pages=array($this->id,$this->id.'_log'); if(in_array($page,$pages)){ return true; } global $post; if(isset($post->post_type) && $post->post_type == $this->id){ return true; } return false; } /** * complete address * * @param mixed $value * @param mixed $f_key * @param mixed $order */ public function verify_address($value,$f_key,$order){ if( $f_key=='_billing_address_1' && isset($order['_billing_address_2'][0]) && $order['_billing_address_2'][0]!=""){ $value.=" ".$order['_billing_address_2'][0]; } if( $f_key=='_shipping_address_1' && isset($order['_shipping_address_2'][0]) && $order['_shipping_address_2'][0]!=""){ $value.=" ".$order['_shipping_address_2'][0]; } return $value; } /** * Send Request * * @param mixed $body * @param mixed $path * @param mixed $method */ public function request($path="",$method='POST',$body="",$head=array()) { if($path=="") $path = $this->url; $args = array( 'body' => $body, 'headers'=> $head, 'method' => strtoupper($method), // GET, POST, PUT, DELETE, etc. 'sslverify' => false, 'timeout' => 30, ); $response = wp_remote_request($path, $args); if(is_wp_error($response)) { $this->errorMsg = $response->get_error_message(); return false; } else if(isset($response['response']['code']) && $response['response']['code'] != 200 && $response['response']['code'] != 404) { $this->errorMsg = strip_tags($response['body']); return false; } else if(!$response) { return false; } $result=wp_remote_retrieve_body($response); return $result; } /** * plugin base url * */ public function get_base_url(){ return plugin_dir_url(__FILE__); } /** * plugin slug * */ public function get_slug(){ if(empty(self::$slug)){ self::$slug=plugin_basename(__FILE__); } return self::$slug; } /** * plugin root directory * */ public function get_base_path(){ return plugin_dir_path(__FILE__); } /** * plugin settings link * */ public function link_to_settings($part=""){ return admin_url( 'admin.php?page=wc-settings&tab='.$this->id.$part); } /** * get plugin direcotry name * */ public function plugin_dir_name(){ if(!empty($this->plugin_dir)){ return $this->plugin_dir; } self::$path=$this->get_base_path(); $this->plugin_dir=basename(self::$path); return $this->plugin_dir; } /** * email validation * * @param mixed $email */ public function is_valid_email($email){ if(function_exists('filter_var')){ if(filter_var($email, FILTER_VALIDATE_EMAIL)){ return true; } }else{ if(strpos($email,"@")>1){ return true; } } return false; } /** * Get Table names * * @param mixed $table */ public function get_table_name($table="log"){ global $wpdb; return $wpdb->prefix . $this->id."_".$table; } /** * Get time Offset * */ public function time_offset(){ $offset = (int) get_option('gmt_offset'); return $offset*3600; } /** * Get WP Encryption key * @return string Encryption key */ public static function get_key(){ $k='Wezj%+l-x.4fNzx%hJ]FORKT5Ay1w,iczS=DZrp~H+ve2@1YnS;;g?_VTTWX~-|t'; if(defined('AUTH_KEY')){ $k=AUTH_KEY; } return substr($k,0,30); } /** * Decrypts Values * @param array $info encrypted API info * @return array API settings */ public static function de_crypt($info){ $info=trim($info); if($info == "") return ''; $str=base64_decode($info); $key=self::get_key(); $decrypted_string=''; if(function_exists("openssl_encrypt") && strpos($str,':')!==false ) { $method='AES-256-CBC'; $arr = explode(':', $str); if(isset($arr[1]) && $arr[1]!=""){ $decrypted_string=openssl_decrypt($arr[0],$method,$key,false, base64_decode($arr[1])); } }else{ $decrypted_string=$str; } return $decrypted_string; } /** * Encrypts Values * @param string $str * @return string Encrypted Value */ public static function en_crypt($str){ $str=trim($str); if($str == "") return ''; $key=self::get_key(); if(function_exists("openssl_encrypt")) { $method='AES-256-CBC'; $iv = openssl_random_pseudo_bytes(openssl_cipher_iv_length($method)); $enc_str=openssl_encrypt($str,$method, $key,false,$iv); $enc_str.=":".base64_encode($iv); }else{ $enc_str=$str; } $enc_str=base64_encode($enc_str); return $enc_str; } /** * Get variable from array * * @param mixed $key * @param mixed $arr */ public function post($key, $arr="") { if(is_array($arr)){ return isset($arr[$key]) ? $arr[$key] : ""; } //clean when getting extrenals return isset($_REQUEST[$key]) ? $this->clean($_REQUEST[$key]) : ""; } public function clean($var,$key=''){ if ( is_array( $var ) ) { $a=array(); foreach($var as $k=>$v){ $a[$k]=$this->clean($v,$k); } return $a; }else { $var=wp_unslash($var); if(in_array($key,array('note_val','value'))){ $var=sanitize_textarea_field($var); }else{ $var=sanitize_text_field($var); } return $var; } } /** * Get variable from array * * @param mixed $key * @param mixed $key2 * @param mixed $arr */ public function post2($key,$key2, $arr="") { if(is_array($arr) && isset($arr[$key]) && is_array($arr[$key])){ return isset($arr[$key][$key2]) ? $arr[$key][$key2] : ""; } return isset($_REQUEST[$key][$key2]) && is_array($_REQUEST[$key]) ? $this->clean($_REQUEST[$key][$key2]) : ""; } /** * Get variable from array * * @param mixed $key * @param mixed $key2 * @param mixed $arr */ public function post3($key,$key2,$key3, $arr="") { if(is_array($arr)){ return isset($arr[$key][$key2][$key3]) ? $arr[$key][$key2][$key3] : ""; } return isset($_REQUEST[$key][$key2][$key3]) ? $this->clean($_REQUEST[$key][$key2][$key3]) : ""; } /** * Logs a message * * @param mixed $msg */ public function log_msg($msg){ if ( class_exists( 'WC_Logger' ) ) { $logger = new WC_Logger(); $slug=$this->plugin_dir_name(); $logger->add( $slug, $msg); } } /*************************************plugin functions******************************************/ /** * Formates crm response * * @param mixed $note * @param mixed $show_error */ public function format_note($note,$show_error=false){ $object=$this->post('object',$note); $id=$this->post('id',$note); $error=$this->post('error',$note); $msg=""; if(!empty($note['status'])){ if($note['status'] == "4"){ $msg=sprintf(__('QuickBooks (%s) Filtered','wp-woocommerce-quickbooks'),$object); }else{ //web2lead do not have link $link=sprintf(__("with ID # %s",'wp-woocommerce-quickbooks'),$this->post('id',$note)); if($this->post('link',$note) !=""){ $id_link=''.$this->post('id',$note).''; $link=sprintf(__('with ID # %s','wp-woocommerce-quickbooks'),$id_link); } if($this->post('status',$note) == 3){ $link="Web2".$object; } $action=$this->post('action',$note); if($note['status'] == '1'){ $msg=sprintf(__('Added to QuickBooks (%s) ','wp-woocommerce-quickbooks'),$object).$link; }else{ $msg=sprintf(__("Updated to QuickBooks (%s) ",'wp-woocommerce-quickbooks'),$object).$link; } } }else if($show_error){ if(empty($error)){ if(!empty($note['meta'])){ $error=$note['meta']; }else{ $error= __("Error While Posting to QuickBooks",'wp-woocommerce-quickbooks'); } } $msg=$error; } if(isset($note['log_id'])){ $log_url=admin_url( 'admin.php?page='.$this->id.'_log&id='.$note['log_id']); $msg.=' - '.__('View Detail','wp-woocommerce-quickbooks').""; } return $msg; } /** * order information fields * * @param mixed $f_key */ public function order_info_fields($f_key=""){ $_order=self::$_order; $val=""; switch($f_key){ case"_order_total": $val=$_order->get_total(); break; case"_order_subtotal": $val=$_order->get_subtotal(); break; case"_total_refunded": $val=$_order->get_total_refunded(); break; case"_total_refunded_tax": $val=$_order->get_total_tax_refunded(); break; case"_total_shipping_refunded": $val=$_order->get_total_shipping_refunded(); break; case"_total_qty_refunded": $val=$_order->get_total_qty_refunded(); break; case"_items_count": $val=$_order->get_item_count(); break; case"_order_status": $val=$_order->get_status(); break; case"_customer_notes": $val=$_order->get_customer_note(); break; case"_shipping_method_title": $val=$_order->get_shipping_method(); break; case"parent_post_id": $post_id=$_order->get_id(); $val=wp_get_post_parent_id($post_id); break; case"_order_discount_total": $val=$_order->get_discount_total(); break; case"_order_discount_total_refunded": $val=$_order->get_discount_total(); $refund=$_order->get_total_refunded(); $val+=$refund; break; case"_order_total_refunded": $val=$_order->get_total() - $_order->get_total_refunded(); break; case"_order_tax_total": $val=$_order->get_total_tax(); break; case"_order_shipping_total": $val=$_order->get_shipping_total(); break; case"_order_shipping_total_tax": $val=$_order->get_shipping_total()+$_order->get_shipping_tax(); break; case"_used_coupns": $coupons=$_order->get_coupon_codes(); if(is_array($coupons)){ $val=implode(', ',$coupons); } break; case"_order_fees": ////get fees $fees=$_order->get_fees(); if(is_array($fees) && version_compare( WC_VERSION, '3.0.0', '>=' ) ){ $val=array(); foreach($fees as $fee){ $val[]=$fee->get_name().' : '.$fee->get_total(); } $val=implode("\r\n ----- \r\n",$val); } break; default: if(in_array($f_key,array('_order_fees_total','_order_fees_total_tax','_order_fees_total_shipping'))){ $fees=$_order->get_fees(); $val=$valt=0; if(version_compare( WC_VERSION, '3.0.0', '>=' )){ foreach($fees as $fee){ $val+=$fee->get_total(); $valt+=$fee->get_total()+$fee->get_total_tax(); } } self::$order['_order_fees_total_tax']= abs($valt); self::$order['_order_fees_total']= abs($val); //plugins add negitive fees as discount line , that is why convert - to + self::$order['_order_fees_total_shipping']= $val + $_order->get_shipping_total(); } else if(in_array($f_key,array('_order_items_skus','_order_items_titles','_order_items_qty','_order_items'))){ $items=$_order->get_items(); ///var_dump($items); die(); $info=array(); if(is_array($items) && count($items)>0){ foreach($items as $k=>$item){ if(method_exists($item,'get_product_id')){ $product=$item->get_product(); if(!$product){ continue; } $sku=$product->get_sku(); $item_info=array( __('Title','woo-zoho')=>$item->get_name() ,__('Quantity','woo-zoho')=>$item->get_quantity() // ,__('Line Tax','woo-zoho')=>$item['line_tax'] // ,__('Line Subtotal Tax','woo-zoho')=>$item['line_subtotal_tax'] ,__('Total','woo-zoho')=>$item->get_total() // ,__('Line Subtotal','woo-zoho')=>$item['line_subtotal'] ); if(!empty($sku)){ $item_info['SKU']=$sku; } if(method_exists($item,'get_total_tax')){ // $item_info['Line Tax']=$item->get_total_tax(); } $extra_ops=wc_get_order_item_meta($item->get_id(),'_tmcartepo_data',true); if(!empty($extra_ops)){ foreach($extra_ops as $v){ if(!empty($v['name'])){ $item_info[$v['name']]=$v['value'].' - '.$v['price']; } } } /// line items attributes $item_attrs=$this->get_item_attrs($item); foreach($item_attrs as $attr=>$attr_val){ $item_info[$attr]=$attr_val; } $info[]=$item_info; } } } if(count($info)>0){ $skus=array(); $titles=$qtys=array(); foreach($info as $meta){ if(isset($meta['SKU'])){ $skus[]=$meta['SKU']; } $titles[]=$meta['Title']; $qtys[]=$meta['Title'].'('.$meta['Quantity'].')'; if(!empty($val)){ $val.="------------\n"; } foreach($meta as $k=>$v){ $val.=$k." : ".$v."\n"; } } self::$order['_order_items_titles']=implode(', ', $titles); self::$order['_order_items_skus']= implode(', ', $skus); self::$order['_order_items_qty']= implode(', ', $qtys); self::$order['_order_items']= $val; } } else if( strpos($f_key,'__vxo') !== false && !isset(self::$order[ '__vxo_last_order_number' ]) ){ $customer_orders=array(); $user_id = $_order->get_user_id(); if(!empty($user_id)){ $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_customer_user', 'meta_value' => $user_id, 'post_type' => 'shop_order', 'post_status' => array_keys( wc_get_order_statuses() ), 'order' => 'DESC', ) ); } $counter = 0; self::$order[ '__vxo_order_total' ]=0; foreach( $customer_orders as $order_details ){ // get the order id. $order_id = isset( $order_details->ID ) ? intval( $order_details->ID ) : 0; // if order id not found let's check for another order. if( !$order_id ) { continue; } // get order. $order = new WC_Order( $order_id ); if( empty( $order ) || is_wp_error( $order ) ) { continue; } // get all order items first. $order_items = $order->get_items(); $order_total=0; if(!in_array($order->get_status(),array('cancelled','refunded'))){ $order_total = $order->get_total(); } $order_count=count( $customer_orders ); self::$order[ '__vxo_order_total' ] += floatval( $order_total ); self::$order[ '__vxo_order_count' ]=$order_count; $order_date=''; if(method_exists($order,'get_date_created')){ $order_date=$order->get_date_created()->format('F d, Y H:i:s'); }else{ $order_date=$order->order_date; } // check for last order and finish all last order calculations. if( !$counter ){ // last order calculations over here. self::$order[ '__vxo_last_order_date' ] = $order_date; self::$order[ '__vxo_last_order_value' ] = $order_total; self::$order[ '__vxo_last_order_number' ] = $order_id; self::$order[ '__vxo_last_order_status' ] = "wc-".$order->get_status(); } // check for first order. if( $counter == $order_count - 1 ) { self::$order[ '__vxo_first_order_date' ] = $order_date; self::$order[ '__vxo_first_order_value' ] = $order_total; } $counter++; } } else if(strpos($f_key,'_vxst') === 0 && !isset(self::$order['_vxst_billing_country']) && is_object($_order) && method_exists($_order,'get_billing_country')){ $contb=$_order->get_billing_country(); $conts=$_order->get_shipping_country(); $stateb=$_order->get_billing_state(); $states=$_order->get_shipping_state(); $contbs=WC()->countries->get_countries(); if(!empty($contb) && !empty($contbs[$contb])){ self::$order['_vxst_billing_country'] = $contbs[$contb]; } if(!empty($stateb)){ $statesb=WC()->countries->get_states($contb); if(!empty($statesb[$stateb])){ self::$order['_vxst_billing_state'] = $statesb[$stateb]; } } if(!empty($conts) && !empty($contbs[$conts])){ self::$order['_vxst_shipping_country'] = $contbs[$conts]; } if(!empty($states)){ $statesb=WC()->countries->get_states($conts); if(!empty($statesb[$states])){ self::$order['_vxst_shipping_state'] = $statesb[$states]; } } } else if($f_key == '_order_notes' && !isset(self::$order[$f_key]) ){ $order_id=$_order->get_id(); $comments = wc_get_order_notes(array('order_id'=>$order_id)); $notes=array(); foreach($comments as $v){ $notes[]=$v->content; } $val=self::$order[$f_key]=implode("\r\n ----- \r\n",$notes); } else if(is_object($_order) && method_exists($_order,'get_meta')){ $keys=array('_address', '_address_1', '_address_2', '_city', '_postcode', '_state', '_country', '_company', '_email', '_first_name', '_last_name', '_phone' ); $s_key=str_replace(array('_billing','_shipping'),'',$f_key); if(in_array($s_key,$keys)){ $function = 'get_' . ltrim( $f_key, '_' ); if ( is_callable( array( $_order, $function ) ) ) { $val=$_order->{$function}(); } }else{ $val=$_order->get_meta($f_key); } } if(isset(self::$order[$f_key])){ $val=self::$order[$f_key]; } $f_key=''; break; } if(!empty($f_key)){ self::$order[$f_key]=$val; } return $val; } public function get_item_attrs($item){ $meta_data=$item->get_meta_data(); $item_info=array(); foreach ( $meta_data as $meta ) { if ( empty( $meta->id ) || '' === $meta->value || ! is_scalar( $meta->value ) || substr( $meta->key, 0, 1 ) == '_' ) { continue; } $meta->key = rawurldecode( (string) $meta->key ); $meta->value = rawurldecode( (string) $meta->value ); $attribute_key = str_replace( 'attribute_', '', $meta->key ); $product=$item->get_product(); $display_key = wc_attribute_label( $attribute_key, $product ); $display_value = wp_strip_all_tags( $meta->value ); if ( taxonomy_exists( $attribute_key ) ) { $term = get_term_by( 'slug', $meta->value, $attribute_key ); if ( ! is_wp_error( $term ) && is_object( $term ) && $term->name ) { $display_value = $term->name; } } $item_info[$display_key]=$display_value; } return $item_info; } /** * Get log of order and feed * * @param mixed $feed_id * @param mixed $order_id */ public function get_feed_log($feed_id,$order_id,$object,$parent_id=""){ global $wpdb; $table= $this->get_table_name('log'); $sql= $wpdb->prepare('SELECT * FROM '.$table.' where order_id = %d and feed_id = %d and crm_id!="" and object=%s and parent_id=%d order by id desc limit 1',$order_id,$feed_id,$object,$parent_id); $results = $wpdb->get_row( $sql ,ARRAY_A ); if(empty($results)){ $results=array('status'=>100,'object'=>'xxx','crm_id'=>'','link'=>'','extra'=>''); } return $results; } /** * Push order to quickbooks feeds * * @param mixed $order_id * @param mixed $status */ public function push($order_id,$status="user",$log=array()){ $log_id=''; self::$processing_feed=true; if(is_array($log) && !empty($log)){ if(isset($log['id'])){ $log_id=$log['id']; } $feeds=array($log['feed_id']); }else{ if(empty(self::$all_feeds)){ //get feeds of a form self::$all_feeds= get_posts( array( 'post_type' => $this->id, 'ignore_sticky_posts' => true, 'nopaging' => true, 'post_status' => 'publish', 'fields' => 'ids' ) ); } $feeds=self::$all_feeds; } $other_events=array('save_user','save_product'); $is_order=true; $item=array(); $feeds_meta=array(); $k=1000; $e=2000; $i=1; foreach($feeds as $id){ $feed=get_post_meta($id,$this->id.'_meta',true); $event=$this->post('event',$feed); if(!is_array($feed)){ continue; } if(in_array($status,$other_events) && !in_array($event,$other_events) ){ // if saving user or product , skip all other evnts continue; } if( $status == '' && (in_array($event,$other_events) || strpos($event,'vxswc-') === 0 ) ){ // skip user and product and subscriptions on manual submission continue; } if( $status == 'admin_sub' && strpos($event,'vxswc-') === false){ // only allow subscription events on manual submission of subsc continue; } $feed['id']=$id; $object=$this->post('object',$feed); if(!empty($feed['contract_check']) || !empty($feed['customer_check'])){ if($object == 'Order'){ $feeds_meta[$e++]=$feed; }else{ $feeds_meta[$k++]=$feed; } }else{ $feeds_meta[$i++]=$feed; } } ksort($feeds_meta); if(is_array($feeds_meta) && count($feeds_meta)>0){ $is_subscription=false; if( is_object($order_id) && (strpos($status,'vxswc-') === 0 || $status == 'admin_sub') ){ self::$_order=$_order=$order_id; $order_id=$order_id->get_id(); $is_subscription=true; } if($status == 'admin_sub'){ $status=''; } global $post_id; self::$order=$order=array(); if(in_array($status,array('save_user'))){ self::$_order=get_user_by('id',esc_attr($order_id)); }else{ if(empty($post_id)){ //$post_id is empty with bulk product update $post_id=$order_id; } if($post_id){ self::$order=$order=get_post_meta($order_id); } self::$order['_post_id']=$order_id; } if(isset($log['__vx_data'])){ self::$order=$log['__vx_data']; }else if(!in_array($status,$other_events)){ if(!empty($order['_billing_email'][0])){ $email=$order['_billing_email'][0]; $email_domain=substr($email,strpos($email,'@')+1); self::$order['_email_domain']=array($email_domain); } self::$order['_order_id']=$order_id; if(!$is_subscription){ self::$_order=$_order = new WC_Order($order_id); if($_order){ self::$order['_order_id']=$_order->get_id(); } } $order_status=$_order->get_status(); if(!$order_status){ $this->log_msg('Order #'.$order_id.' - order status is not valid'); return; } $date= current_time( 'mysql' ); if(method_exists(self::$_order,'get_date_created') && !empty(self::$_order->get_date_created())){ $date=self::$_order->get_date_created()->date('d-M-Y H:i:s'); //self::$_order->get_date_created() becomes null on saving shipping line } self::$order['_order_date']=$date; if(!isset($order['_completed_date'])){ self::$order['_completed_date']=$date; } self::$order=$order=apply_filters('vx_crm_post_fields', self::$order ,$order_id,'wc',''); }else{ $is_order=false; $key= $status == 'save_product' ? 'product_id': 'user_id'; $item=array($key=>$order_id); } $data=$res=array(); $msg=""; $notice=""; $class="updated"; $error=""; $n=0; while($feed=current($feeds_meta)){ next($feeds_meta); $current_pos=key($feeds_meta); $n++; $id=$this->post('id',$feed); self::$feeds_res[$id]=array(); $no_filter=true; $account=$this->post('account',$feed); $info=$this->get_info($account); $info_data=array(); if(isset($info['data'])){ $info_data=$info['data']; } $api_type=$this->post('api',$info_data); $meta=$this->post('meta',$info); if(is_array($feed) && is_array($meta)){ $feed=array_merge($meta,$feed); } $object=$this->post('object',$feed); $map=$this->post('map',$feed); if($api_type =="web"){ $feed['fields']=$this->web_fields($object,$map); } $fields=isset($feed['fields']) ? $feed['fields'] : array(); if(!is_array($fields) || count($fields) == 0 || empty($object) || empty($object)){ continue; } $parent_id=0; if(isset(self::$order['__vx_parent_id'])){ $parent_id=self::$order['__vx_parent_id']; } $temp=array(); $force_send=false; $post_comment=true; //filter optin condition + events if($status !="" ){ //it is not submitted by admin if( in_array($status,array('restore','update','delete','add_note','delete_note'))){ // web2lead does not supports notes , delete/update object if($api_type =="web"){ continue; } if($status == 'delete_note' && !empty(self::$note)){ $parent_id=self::$note['id']; } $search_object=$object; if(in_array($status,array('delete_note','add_note'))){ //check feed $order_notes=$this->post('order_notes',$feed); //if notes sync not enabled in feed return if( empty($order_notes) ){ continue; } //change main object to Note $feed['related_object']=$object; $object=$feed['object']='Note'; } if($status == 'delete_note'){ //when deleting note search note object $search_object='Note'; } $feed_log=$this->get_feed_log($id,$order_id,$search_object,$parent_id); if($status == 'restore' && $feed_log['status'] != 5) { // only allow successfully deleted records continue; } if( in_array($status,array('update','delete') ) && !in_array($feed_log['status'],array(1,2) ) ){ // only allow successfully sent records continue; } if(in_array($status, array('delete','restore')) && in_array($feed_log['object'],array('customer'))){ //quickbookes does not support customer deletion continue; } if(empty($feed_log['crm_id']) || empty($feed_log['object']) || $feed_log['object'] != $search_object){ //feed + log entry validation continue; } if($status !='restore'){ //restore is like normal send to crm $feed['crm_id']=$feed_log['crm_id']; //unset($feed['primary_key']); find new sync token } $feed['event']=$status; // add note and save related extra info if( $status == 'add_note' && !empty(self::$note)){ $temp=array('Title'=>array('value'=>self::$note['title']),'Body'=>array('value'=>self::$note['body']),'ParentId'=>array('value'=> $feed['crm_id'])); $parent_id=self::$note['id']; $feed['note_object_link']=''.esc_html($feed_log['crm_id']).''; } // delete not and save extra info if( $status == 'delete_note'){ $feed_log_arr= json_decode($feed_log['extra'],true); if(isset($feed_log_arr['note_object_link'])){ $feed['note_object_link']=$feed_log_arr['note_object_link']; } $temp=array('ParentId'=>array('value'=> $feed['crm_id'])); } //delete object if( $status == 'delete'){ $temp=array('Id'=>array('value'=> $feed['crm_id'])); } // if(!in_array($status, array('update','restore'))){ //other case settings(add note, delete note, delete) //do not apply filters on all other cases(add note, delete note, delete) $force_send=true; } //do not post comment in al other cases $post_comment=false; } //var_dump(self::$note,$object,$feed['note_object'],$feed['object'],$feed['crm_id'],$feed['event'],$temp,$feed_log); die(); // filter on basis of events if($feed['event'] == "manual" && $status=="user") //on order submission by user , if set to manual , do not post order continue; if($feed['event'] != $status) // if event is set , if event not matched , then continue continue; //if user created account if($status == "user_created"){ $user=false; if(method_exists($_order,'get_user') ){ $user=$_order->get_user(); } if(!$user){ continue; } } } //if submitted by admin, $status is empty , so always continue on admin submit button if(!$force_send && isset($feed['map']) && count($feed['map'])>0){ if($is_order){ //add new fields found in map $items=self::$_order->get_items(); if(!empty($feed['each_line'])){ unset($feed['each_line']); $items_total=count($items); if($items_total>1){ $feed_n=$feed; $f_n=0; foreach($items as $item_k=>$itm){ $f_n++; if($f_n>1){ $feed_n['_vx_item_id']=$item_k; $feeds_meta[$items_total++]=$feed_n; } } } } if(!empty($feed['_vx_item_id'])){ $item=$items[$feed['_vx_item_id']]; }else{ $item=reset($items); } } self::$order=$order=apply_filters('vx_crm_add_map_fields', self::$order ,$order_id,$feed,'wc',''); $skip_feed=false; foreach($feed['map'] as $k=>$v){ if(isset($v['field'])){ if(!isset($fields[$k])){ continue; } $field=$fields[$k]; $field_name=$this->post('field',$v); if($this->post('type',$v) == "value"){ $value=trim($this->post('value',$v)); $value=$this->process_tags($value,$item); }else if(strpos($field_name,'_vx_feed-') !== false){ $temp_feed_id=substr($field_name,9); if(isset(self::$feeds_res[$temp_feed_id])){ $value= !empty(self::$feeds_res[$temp_feed_id]['id']) ? self::$feeds_res[$temp_feed_id]['id'] : ''; }else if($n < count($feeds_meta) ){ // it is not last element $feeds_meta[]=$feed; $skip_feed=true; break; } }else{ $value=$this->get_field_val($v,$item); } if($value !==false){ //custom value $f=array("value"=>$value,"label"=>$field['label']); if($value === ''){ $f['field']=$v['field']; } $temp[$k]=$f; } } } ///var_dump($temp); die(); if($skip_feed){ continue; } //add account or contract if(!empty($feed['customer_check']) && !empty($feed['object_customer'])){ $contract_feed=$feed['object_customer']; if( isset(self::$feeds_res[$contract_feed]) ){ $contract_res=self::$feeds_res[$contract_feed]; if(!empty($contract_res['id']) && !isset($temp['CustomerRef'])){ $temp['CustomerRef']=array('value'=> $contract_res['id'],'label'=>'Customer ID'); } } } // if(!empty($feed['note_check']) && !empty($feed['note_val']) ){ $entry_note=''; $entry_note=$this->process_tags($feed['note_val']); if(!empty($entry_note)){ $temp['Notes']=array('value'=>$entry_note,'label'=>'Feed Note'); } } } $temp=apply_filters($this->id.'_post_data', $temp ,esc_attr($order_id)); if(isset($_REQUEST['bulk_action']) && $_REQUEST['bulk_action'] =="send_to_crm_bulk_force" && !empty($log_id)){ $force_send=true; } if(!$force_send && $this->post('optin_enabled',$feed) == "1" ){ //check filters if not sending by force and optin condition enabled //&& $api !="web" $no_filter=$this->check_filter($feed); $res=array("status"=>"4","extra"=>array("filter"=>$this->filter_condition),"data"=>$temp); } /* if($this->post('class',$info) !="updated"){ return; } */ if($no_filter){ //get feeds $api=$this->get_api($info); $res=$api->push_object($object,$temp,$feed); //var_dump($temp,$res); die(); } $res['time']=current_time('timestamp'); $res['object']=$feed['object']; self::$feeds_res[$id]=$res; if(empty($res['status'])){ $class="error"; } if(isset($res['error']) && $res['error']!="" && !is_admin()){ $this->send_error_email($order_id,$info,$res); } if(!empty($feed['order_notice'])){ $qres=$res['response']; if(is_array($qres)){ $qres=reset($qres); if(method_exists(self::$_order,'get_total') && isset($qres['TotalAmt'])){ $wc_total=(int)self::$_order->get_total(); $qb_total=(int)$qres['TotalAmt']; if($wc_total != $qb_total){ $email=array('error'=>'WooCommerce Order Total('.$wc_total.') does not match Quickbooks Total('.$qb_total.')'); $this->send_error_email($order_id,$info,$email); } } } } // $settings=get_option($this->type.'_settings',array()); //insert log // if($this->post('disable_log',$settings) !="yes"){ $arr=array("object"=>$feed["object"],"order_id"=>$order_id,"crm_id"=>$this->post('id',$res),"meta"=>$this->post('error',$res),"time"=>date('Y-m-d H:i:s'),"status"=>$this->post('status',$res),"link"=>$this->post('link',$res),"data"=>$this->post('data',$res),"response"=>$this->post('response',$res),"extra"=>$this->post('extra',$res),"feed_id"=>$id,'parent_id'=>$parent_id,'event'=>$status); $log_id_i=$this->__log($arr,$log_id); if($log_id_i!=""){ // $res['log_id']=$log_id_i; } // } $note_text=$this->format_note($res,true); if($notice!=""){ $notice.="\n"; } $notice.=$note_text; if($notice!=""){ // $_order->add_order_note($notice, false); } if(count($res)>0){ $data[]=$res; } } //send crm response to other plugins do_action('crm_response_'.$this->id,$res); if(count($data)>0){ if($post_comment){ //update_post_meta($order_id,$this->id.'_post',$data); } return array("class"=>$class,"msg"=>nl2br($notice)); // for multiple feed and multiple messages } } return false; } public function process_tags($value,$item=array()){ //starts with { and ends } , any char in brackets except { preg_match_all('/\{[^\{]+\}/',$value,$matches); if(!empty($matches[0])){ $vals=array(); foreach($matches[0] as $m){ $m=trim($m,'{}'); $val_cust=$this->get_field_val(array('field'=>$m),$item); if(is_array($val_cust)){ $val_cust=trim(json_encode($val_cust)); } $vals['{'.$m.'}']=$val_cust; } $value=str_replace(array_keys($vals),array_values($vals),$value); } return $value; } /** * notify error email * * @param mixed $order_id * @param mixed $info * @param mixed $res */ public function send_error_email($order_id,$info,$res){ if(!empty($info['data']['error_email'])){ $subject=__('Error While Posting to QuickBooks','wp-woocommerce-quickbooks'); $page_url = ( is_ssl() ? 'https://' : 'http://' ) . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $order_url=''.esc_html($order_id).''; $email_info=array("msg"=>$res['error'],"title"=>__("QuickBooks Error",'wp-woocommerce-quickbooks'),"info_title"=>"More Detail","info"=>array("Order Id"=>$order_url,"Time"=>date('d/M/y H:i:s',current_time('timestamp')),"Page URL"=>''.esc_url($page_url).'')); $email_body=self::format_user_info($email_info,true); $error_emails=explode(",",$info['data']['error_email']); $headers = array('Content-Type: text/html; charset=UTF-8'); foreach($error_emails as $email) wp_mail(trim($email),$subject, $email_body,$headers); } } /** * check if other version of this plugin exists * */ public function other_plugin_version(){ $status=0; if(class_exists('vxc_qbookss_wp')){ $status=1; }else if( file_exists(WP_PLUGIN_DIR.'/wp-woocommerce-quickbooks/woocommerce-qbooks-crm.php')) { $status=2; } return $status; } /** * get field value from woocommerce order * * @param mixed $map_field */ public function get_field_val($map_field,$item=array()){ $order=self::$order; if($this->post('type',$map_field) == ""){ $type="field"; $f_key=$map_field[$type]; }else{ $type=$map_field['type']; $f_key=$map_field[$type]; } $value=''; if($this->post($type,$map_field) == ""){ return false; } if(in_array($type,array("field",'custom'))){ //if value stored in order if(strpos($f_key,"__vx_wp-") ===0){ //if user field $f_key=substr($f_key,8); if(is_object(self::$_order) && method_exists(self::$_order,'get_user_id')){ $user=self::$_order->get_user(); //get_user_id }else{ $user=self::$_order; } if( is_object($user) && property_exists($user,'ID')){ $user_id=$user->ID; if(in_array($f_key,array('user_email','display_name','user_nicename','user_registered','roles','user_login','user_url','ID','caps'))){ $value=$user->$f_key; }else{ $value=get_user_meta($user_id,$f_key,true); } } } else if(strpos($f_key,"__vxp") === 0 && !empty($item) ){ $f_key_type=substr($f_key,0,10); $f_key=substr($f_key,10); $p_id=''; if(is_object($item) && method_exists($item,'get_product_id')){ $p_id=$item->get_product_id(); }else if(is_array($item) && isset($item['product_id'])){ $p_id=$item['product_id']; $item=new stdClass(); } $product=wc_get_product($p_id); // var_dump($product->get_name()); die(); // $display_key = wc_attribute_label( $attribute_key, $product ); if( in_array($f_key,array('sku','price','regular_price','sale_price')) && method_exists($item,'get_variation_id')){ $var_id=$item->get_variation_id(); if(!empty($var_id)){ $product=wc_get_product($var_id); } } if( method_exists($product,'get_attributes')){ if($f_key_type == '__vxp_fun-'){ $fun='get_'.$f_key; if(in_array($f_key,array('get_category_ids','get_category'))){ $terms = get_the_terms( $p_id, 'product_cat' ); $val_temp=array(''); if($terms){ $val_temp=array(); foreach($terms as $term){ $val_temp[]=$term->name; } } if($f_key == 'get_category'){ $value=$val_temp[0]; }else{ $value=implode(', ',$val_temp); } }else if(in_array($f_key,array('product_img'))){ $img_id=$product->get_image_id(); if(!empty($img_id)){ $value=wp_get_attachment_url( $img_id ); } }else{ $value=$product->$fun(); } if( in_array($f_key,array('short_description','description','name'))){ $value=wp_strip_all_tags($value); //php=strip_tags } } else if($f_key_type == '__vxp_iun-'){ $fun='get_'.$f_key; if(method_exists($item,$fun)){ $value=$item->$fun(); } }else if($f_key_type == '__vxp_vtr-'){ if(method_exists($item,'get_id')){ // $item_product=$item->get_product(); // $value=$item_product->get_attribute($f_key); //$l=wc_attribute_label('pa_car-color',$product); $value=$item->get_meta($f_key,true); $book_items=array('get_end_date','get_start_date','get_persons_total'); //,'is_booked_on_day' if( in_array($f_key,$book_items) && class_exists('WC_Booking')){ $f_key_temp=$f_key; if(!isset($order['get_start_date'])){ $item_id=$item->get_id(); $booking_id=$this->get_booking_ids_from_order_item_id($item_id); if(!empty($booking_id[0])){ $booking = new WC_Booking( $booking_id[0] ); foreach($book_items as $v){ self::$order[$v]=$booking->$v(); } $order=self::$order; } } if(isset($order[$f_key_temp])){ $value=$order[$f_key_temp]; } } if ( taxonomy_exists( $f_key ) ) { $term = get_term_by( 'slug', $value, $f_key ); if ( ! is_wp_error( $term ) && is_object( $term ) && $term->name ) { $value = $term->name; } } } } else if($f_key_type == '__vxp_mta-'){ $value=get_post_meta($p_id,$f_key,true); }else{ if($f_key == 'product_cats'){ $terms = get_the_terms( $p_id, 'product_cat' ); $cats=array(); foreach($terms as $v){ $cats[]=$v->slug; } $value=implode(', ',$cats); }else{ $value=$product->get_attribute($f_key); //var_dump($value,$f_key,$product); die(); } } } } else if(strpos($f_key,"__vx_pa") === 0 && is_object($item) && method_exists($item,'get_id') ){ //line item fields $f_key=substr($f_key,8); if($f_key == 'discount_amount' ){ $value= $item->get_subtotal() - $item->get_total(); }else{ $value=wc_get_order_item_meta($item->get_id(),$f_key,true); } } else if(strpos($f_key,"__vx_sh") === 0 && is_object($item) && method_exists($item,'get_id') ){ //line item fields $f_key=substr($f_key,8); $items=self::$_order->get_items('shipping'); if(!empty($items)){ $item=reset($items); $value=wc_get_order_item_meta($item->get_id(),$f_key,true); } } else if(strpos($f_key,'__vxs_') === 0 && is_object(self::$_order) && method_exists(self::$_order,'get_date') ){ $f_key_type=substr($f_key,0,10); $f_key=substr($f_key,10); $value=self::$_order->get_date($f_key); } else if(strpos($f_key,'__yth_qte') === 0 ){ if(!empty($order['_order_id'])){ $qdata=get_post_meta($order['_order_id'],'_raq_request',true); $f_key_type=substr($f_key,0,10); $f_key=substr($f_key,10); if(isset($qdata[$f_key]['value'])){ $value=trim($qdata[$f_key]['value']); } } } else if($f_key == '_refund_reason'){ if(is_object(self::$_order) && method_exists(self::$_order,'get_refunds')){ $re=self::$_order->get_refunds(); if(isset($re[0]) && is_object($re[0]) && method_exists($re[0],'get_reason')){ $value=$re[0]->get_reason(); } } } else if($f_key == '_order_status_label'){ if(is_object(self::$_order) && method_exists(self::$_order,'get_status')){ $wc_status=self::$_order->get_status(); $status_list=wc_get_order_statuses(); if(is_array($status_list) && isset($status_list['wc-'.$wc_status])){ $value=$status_list['wc-'.$wc_status]; } } } else if(strpos($f_key,'vxship_') === 0){ if( isset($order['_wc_shipment_tracking_items'][0]) ){ $value=maybe_unserialize($order['_wc_shipment_tracking_items'][0]); if(isset($value[0])){ $value=$value[0]; } $real_key=substr($f_key,7); if(isset($value[$real_key])){ $value=$value[$real_key]; } } } else{ // general fields if(isset($order[$f_key])){ if( is_array($order[$f_key])){ $value=maybe_unserialize($order[$f_key][0]); }else{ $value=$order[$f_key]; } //// verify address fieods // $value=$this->verify_address($value,$f_key,$order); }else{ //get order info fields $f_key_temp=trim($f_key,'_'); if(isset($order[$f_key_temp]) && is_array($order[$f_key_temp])){ $value=maybe_unserialize($order[$f_key_temp][0]); }else{ $value=$this->order_info_fields($f_key); } } } if(is_array($value)){ $value=implode("; ",$value); } }else{ //custom value $value=$map_field['value']; } return $value; } /** * Initialize quickbooks api * * @param mixed $crm * @return VXQuickBooksAPI */ public function get_api($crm){ $api = false; $api_class=$this->id."_api"; if(!class_exists($api_class)) require_once(self::$path."api/api.php"); $api = new $api_class($crm); return $api; } /** * update account * * @param mixed $data * @param mixed $id */ public function update_info($data,$id) { global $wpdb; if(empty($id)){ return; } $table= $this->get_table_name('accounts'); $time = current_time( 'mysql' ,1); $sql=array('updated'=>$time); if(is_array($data)){ if(isset($data['meta'])){ $sql['meta']= json_encode($data['meta']); } if( isset($data['data']) && is_array($data['data'])){ if(array_key_exists('time' , $data['data']) && empty($data['data']['time'])){ $sql['time']= $time; $sql['status']= '2'; } if(isset($data['data']['class'])){ $sql['status']= $data['data']['class'] == 'updated' ? '1' : '2'; } if(isset($data['data']['meta'])){ unset($data['data']['meta']); } if(isset($data['data']['status'])){ unset($data['data']['status']); } if(isset($data['data']['name'])){ $sql['name']=$data['data']['name']; }else if(isset($_GET['id'])){ $sql['name']="Account #".$this->post('id'); } $enc_str=json_encode($data['data']); // $enc_str=$this->en_crypt($enc_str); $sql['data']=$enc_str; } } $result = $wpdb->update( $table,$sql,array('id'=>$id) ); return $result; } /** * Get Objects from local options or from quickbooks * * @param mixed $check_option * @return array */ public function get_objects($info="",$refresh=false){ $objects=array('customer'=>'Customer','invoice'=>'Invoice'); $objects=apply_filters('quickbooks_woo_objects_list',$objects); return $objects; } } endif; $vxc_qbooks=new vxc_qbooks(); $vxc_qbooks->instance(); $vx_wc['vxc_qbooks']='vxc_qbooks';